SAP ABAP Table ORASAREA_E (Additional Fields for "Oracle Cursor Cache Stats" List)

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	ORASAREA_E	Table Relationship Diagram
Short Description	Additional Fields for "Oracle Cursor Cache Stats" List

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	OPEN_VERSI	☐	ORAOPENVER	ORANUMB8	INT4	10	0	Number of opened cursor versions
2	USERS_OPEN	☐	ORAUSROPEN	ORANUMB8	INT4	10	0	Number of users who have opened cursor version
3	LOADED_VER	☐	ORALOADVER	ORANUMB8	INT4	10	0	Loaded cursor versions
4	SHARABLE_M	☐	ORASHARMEM	ORAPNUMBER	DEC	31	0	Total shareable memory
5	PERSISTENT	☐	ORAPERSMEM	ORAMEMORY	INT4	10	0	Total 'persistent memory'
6	RUNTIME_ME	☐	ORARUNTMEM	ORAMEMORY	INT4	10	0	Total "runtime memory"
7	INVALIDATI	☐	ORAINVALID	ORANUMB8	INT4	10	0	Number of 'invalidations' for all versions
8	LOADS	☐	ORALOADS	ORANUMB5	INT4	10	0	Number of loads or reloads
9	PARSE_CALL	☐	ORAPARSEC	ORANUMB8	INT4	10	0	Sum of all 'parse calls'
10	MODULE	☐	ORAMODULE	ORACHAR64	CHAR	64	0	Program Name
11	DB_USER	☐	ORAUSER	CHAR10	CHAR	10	0	Column USERNAME in V$SESSION
12	FIRST_LOAD	☐	ORALOAD_T	ORATIMESTA	CHAR	19	0	Time SQL statement loaded

History

Last changed by/on	SAP	20130604
SAP Release Created in