SAP ABAP Table ORSQLAREA (DDIC Structure According to Oracle Table V$SQLAREA)

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	ORSQLAREA	Table Relationship Diagram
Short Description	DDIC Structure According to Oracle Table V$SQLAREA

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	☐	ORASHARMEM	ORAPNUMBER	DEC	31	0	Total shareable memory
3	PERSISTENT	☐	ORAPERSMEM	ORAMEMORY	INT4	10	0	Total 'persistent memory'
4	RUNTIME_ME	☐	ORARUNTMEM	ORAMEMORY	INT4	10	0	Total "runtime memory"
5	SORTS	☐	ORASORTS	ORANUMB8	INT4	10	0	Sum of the number of sorts
6	VERSION_CO	☐	ORAVERSCOU	ORANUMBER	INT4	10	0	Number of children
7	LOADED_VER	☐	ORALOADVER	ORANUMB8	INT4	10	0	Loaded cursor versions
8	OPEN_VERSI	☐	ORAOPENVER	ORANUMB8	INT4	10	0	Number of opened cursor versions
9	USERS_OPEN	☐	ORAUSROPEN	ORANUMB8	INT4	10	0	Number of users who have opened cursor version
10	EXECUTIONS	☐	ORAEXECNUM	ORAPNUMBER	DEC	31	0	Total number of executions
11	USERS_EXEC	☐	ORAUSREXEC	ORANUMB7	INT4	10	0	Number of users executing
12	LOADS	☐	ORALOADS	ORANUMB5	INT4	10	0	Number of loads or reloads
13	FIRST_LOAD	☐	ORALOAD_T	ORATIMESTA	CHAR	19	0	Time SQL statement loaded
14	INVALIDATI	☐	ORAINVALID	ORANUMB8	INT4	10	0	Number of 'invalidations' for all versions
15	PARSE_CALL	☐	ORAPARSEC	ORANUMB8	INT4	10	0	Sum of all 'parse calls'
16	DISK_READS	☐	ORADISKR	ORAPNUMBER	DEC	31	0	Sum of all 'disk reads'
17	BUFFER_GET	☐	ORABUFFERG	ORAPNUMBER	DEC	31	0	Total number of "buffer gets"
18	ROWS_PROCE	☐	ORAROWPROC	ORAPNUMBER	DEC	31	0	Number of processed rows
19	COMMAND_TY	☐	ORACOMTYPE	ORANUMBER	INT4	10	0	Oracle command type definition
20	OPTIM_MODE	☐	ORAOPTMODE	ORAOPTMODE	CHAR	10	0	Optimizer mode
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	HASH_VALUE	☐	ORAHASHVAL	ORAP16	FLTP	16	16	Hash value of statement
26	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
27	MODULE_HAS	☐	ORAMODULEH	ORAP16	FLTP	16	16	Hash value of module
28	ACTION	☐	ORAACTION	CHAR64	CHAR	64	0	Action name
29	ACTION_HAS	☐	ORAACTIONH	ORAP16	FLTP	16	16	Hash value of action
30	SERIALIZAB	☐	ORASERIAL	ORANUMBER	INT4	10	0	Number of producing ORA-8177

History

Last changed by/on	SAP	20130604
SAP Release Created in