SAP ABAP Table GORASAREA_A (RAC: Structure for "Statistics Cursor Cache" Field Catalog)

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	GORASAREA_A	Table Relationship Diagram
Short Description	RAC: Structure for "Statistics Cursor Cache" Field Catalog

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	INST_ID	☐	ORAINST_ID	ORANUMBER	INT4	10	0	Oracle Instance ID
2	.INCLUDE	☐				0	0	Structure for Field Catalog Creation "Cursor Cache Stats"
3	.INCLUDE	☐				0	0	Structure for Base List: "Oracle Cursor Cache Statistics"
4	EXECUTIONS	☐	ORAEXECNUM	ORAPNUMBER	DEC	31	0	Total number of executions
5	CURR_EXEC	☐	ORACURREX	ORANUMB7	INT4	10	0	Number of users executing this cursor
6	DISK_READS	☐	ORADISKR	ORAPNUMBER	DEC	31	0	Sum of all 'disk reads'
7	DISKRPER_E	☐	ORADRPERE	ORADEC16	DEC	31	1	Number of 'disk reads' for each execution
8	BUFFER_GET	☐	ORABUFFERG	ORAPNUMBER	DEC	31	0	Total number of "buffer gets"
9	BUFFGPER_E	☐	ORABGPERE	ORADEC16	DEC	31	1	Number of 'buffer gets' for each execution
10	ROWS_PROCE	☐	ORAROWPROC	ORAPNUMBER	DEC	31	0	Number of processed rows
11	ROWSPPER_E	☐	ORARPPERE	ORADEC16	DEC	31	1	Number of rows processed for each execution
12	BUFFGPER_R	☐	ORABGPERR	ORADEC16	DEC	31	1	Number of 'buffer gets' for each row
13	SORTS	☐	ORASQLSORT	ORANUMB8	INT4	10	0	Sort orders
14	CPU_TIME	☐	ORACPUTIME	ORAPNUMBER	DEC	31	0	CPU Time in Miroseconds
15	CPU_TIME_E	☐	ORACTPERE	ORADEC16	DEC	31	1	CPU Time per Execution
16	ELAPSED_TI	☐	ORAELAPSED	ORAPNUMBER	DEC	31	0	Elapsed Time in Microseconds
17	ELAPSEDTIE	☐	ORAELAPERE	ORADEC16	DEC	31	1	Elapsed Time per Execution
18	WAIT_TIME	☐	ORAWAITTIM	ORAPNUMBER	DEC	31	0	Wait time
19	WAITTIME_E	☐	ORAWTPERE	ORADEC16	DEC	31	1	Wait Time per Execution
20	SQL_TEXT	☐	ORASQLTEXT	CHAR60	CHAR	60	0	Start of SQL statement
21	.INCLUDE	☐				0	0	Additional Fields for "Oracle Cursor Cache Stats" List
22	OPEN_VERSI	☐	ORAOPENVER	ORANUMB8	INT4	10	0	Number of opened cursor versions
23	USERS_OPEN	☐	ORAUSROPEN	ORANUMB8	INT4	10	0	Number of users who have opened cursor version
24	LOADED_VER	☐	ORALOADVER	ORANUMB8	INT4	10	0	Loaded cursor versions
25	SHARABLE_M	☐	ORASHARMEM	ORAPNUMBER	DEC	31	0	Total shareable memory
26	PERSISTENT	☐	ORAPERSMEM	ORAMEMORY	INT4	10	0	Total 'persistent memory'
27	RUNTIME_ME	☐	ORARUNTMEM	ORAMEMORY	INT4	10	0	Total "runtime memory"
28	INVALIDATI	☐	ORAINVALID	ORANUMB8	INT4	10	0	Number of 'invalidations' for all versions
29	LOADS	☐	ORALOADS	ORANUMB5	INT4	10	0	Number of loads or reloads
30	PARSE_CALL	☐	ORAPARSEC	ORANUMB8	INT4	10	0	Sum of all 'parse calls'
31	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
32	DB_USER	☐	ORAUSER	CHAR10	CHAR	10	0	Column USERNAME in V$SESSION
33	FIRST_LOAD	☐	ORALOAD_T	ORATIMESTA	CHAR	19	0	Time SQL statement loaded

History

Last changed by/on	SAP	20130604
SAP Release Created in	710