SAP ABAP Table ORAV_SQL (DDIC Structure According to Oracle Table V$SQL)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
     ⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB

Basic Data

Table Category	INTTAB	Structure
Structure	ORAV_SQL	Table Relationship Diagram
Short Description	DDIC Structure According to Oracle Table V$SQL

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SQL_TEXT	☐	ORASQLTEXT	CHAR60	CHAR	60	0	Start of SQL statement
2	SHARABLE_M	☐	ORSHARMEM	ORAMEMORY	INT4	10	0	Shareable memory
3	PERSISTENT	☐	ORPERSMEM	ORAMEMORY	INT4	10	0	Persistent memory
4	RUNTIME_ME	☐	ORRUNTMEM	ORAMEMORY	INT4	10	0	Ephemeral frame used
5	SORTS	☐	ORSORTS	ORANUMBER	INT4	10	0	Number of sorts
6	LOADED_VER	☐	ORLOADVER	ORANUMBER	INT4	10	0	Context heap load flag
7	OPEN_VERSI	☐	OROPENVER	ORANUMBER	INT4	10	0	Flag for child cursors is locked
8	USERS_OPEN	☐	ORUSROPEN	ORANUMBER	INT4	10	0	Number of users executing the statement
9	EXECUTIONS	☐	OREXECNUM	ORAPNUMBER	DEC	31	0	Number of executions
10	USERS_EXEC	☐	ORUSREXEC	ORANUMBER	INT4	10	0	Number of users executing
11	LOADS	☐	ORALOADS	ORANUMB5	INT4	10	0	Number of loads or reloads
12	FIRST_LOAD	☐	ORALOAD_T	ORATIMESTA	CHAR	19	0	Time SQL statement loaded
13	INVALIDATI	☐	ORINVALID	ORANUMBER	INT4	10	0	Invalidations for this child cursor
14	PARSE_CALL	☐	ORPARSEC	ORANUMBER	INT4	10	0	Parse calls for this child cursor
15	DISK_READS	☐	ORDISKR	ORAPNUMBER	DEC	31	0	Disk reads for this child cursor
16	BUFFER_GET	☐	ORBUFFERG	ORAPNUMBER	DEC	31	0	Buffer gets for this child cursor
17	ROWS_PROCE	☐	ORROWPROC	ORAPNUMBER	DEC	31	0	Number of rows parsed
18	COMMAND_TY	☐	ORACOMTYPE	ORANUMBER	INT4	10	0	Oracle command type definition
19	OPTIM_MODE	☐	ORAOPTMODE	ORAOPTMODE	CHAR	10	0	Optimizer mode
20	OPTIM_COST	☐	ORAOPTCOST	ORANUMBER	INT4	10	0	Cost of this query
21	PARSING_US	☐	ORAPARSUSR	ORANUMBER	INT4	10	0	ID of the user who built this child cursor
22	PARSING_SC	☐	ORAPARSSCH	ORANUMBER	INT4	10	0	Schema ID
23	KEPT_VERSI	☐	ORAKEPTVER	ORANUMBER	INT4	10	0	Indicator for using DBMS_SHARED_POOL
24	ADDRESS	☐	ORAADDRESS	CHAR16	CHAR	16	0	Address of statement in the cache
25	TYPE_CHK_H	☐	ORATYPECHK	ORARAW4	RAW	4	0	Descriptor of type
26	HASH_VALUE	☐	ORAHASHVAL	ORAP16	FLTP	16	16	Hash value of statement
27	PLAN_HASH_	☐	ORAPLANHAS	ORANUMBER	INT4	10	0	Numerical Representation of the SQL Plan
28	CHILD_NUMB	☐	ORACHILDNU	ORANUMBER	INT4	10	0	Number of child cursor
29	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
30	MODULE_HAS	☐	ORAMODULEH	ORAP16	FLTP	16	16	Hash value of module
31	ACTION	☐	ORAACTION	CHAR64	CHAR	64	0	Action name
32	ACTION_HAS	☐	ORAACTIONH	ORAP16	FLTP	16	16	Hash value of action
33	SERIALIZAB	☐	ORASERIAL	ORANUMBER	INT4	10	0	Number of producing ORA-8177
34	CPU_TIME	☐	ORACPUTIME	ORAPNUMBER	DEC	31	0	CPU Time in Miroseconds
35	ELAPSED_TI	☐	ORAELAPSED	ORAPNUMBER	DEC	31	0	Elapsed Time in Microseconds
36	LAST_LOAD_	☐	ORALASTLOA	CHAR19	CHAR	19	0	Last Load Time

History

Last changed by/on	SAP	20070813
SAP Release Created in