SAP ABAP Table ORAVSQLAR (Restictions on Display of Cursor Cache Statistical Data)

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	ORAVSQLAR	Table Relationship Diagram
Short Description	Restictions on Display of Cursor Cache Statistical Data

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	SQLTEXT	☐	ORARSQLTXT	CHAR40	CHAR	40	0	Restriction on SQL statements to be analyzed
2	BUFFERGETS	☐	ORARBUFGET	ORANUMBER	INT4	10	0	Restriction on number of 'buffer gets'
3	DISKREADS	☐	ORARDISKRD	ORANUMBER	INT4	10	0	Restriction on number of 'disk reads'
4	EXECUTIONS	☐	ORARTEXEC	ORANUMBER	INT4	10	0	Restriction on the number of total executions
5	CURRENTEXE	☐	ORARCUREXE	ORANUMBER	INT4	10	0	Restriction on number of 'current executions'
6	SHAREDMEM	☐	ORARSHAMEM	ORANUMBER	INT4	10	0	Restriction on shared memory
7	MAXNUMBER	☐	ORARMNSTET	ORANUMC4	NUMC	4	0	Maximum number of statements
8	SKIP_SELC	☐	ORARSKIPSC	CHAR1_CBOX	CHAR	1	0	Field list display for select statements
9	USERNAME	☐	DB_USER	CHAR30	CHAR	30	0	Database user

History

Last changed by/on	SAP	20070813
SAP Release Created in