SAP ABAP Table ORA_TABLE_ACCESS (Structure for the table access monitor)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ORA_TABLE_ACCESS	Table Relationship Diagram
Short Description	Structure for the table access monitor

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	☐	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
2	OWNER	☐			CHAR	64	0
3	TABLE_NAME	☐			CHAR	1000	0
4	SIZE_KB	☐			DEC	22	0
5	TYPE	☐			DEC	22	0
6	BUFFER_POOL	☐			CHAR	7	0
7	OPERATION	☐			CHAR	6	0
8	SQL_TEXT	☐			CHAR	1000	0
9	SQL_MODULE	☐	ORA_SQL_MODULE	ORA_CHAR_64	CHAR	64	0	Oracle Monitoring: MODULE: Name of Module Causing Parsing
10	ACTION	☐	ORA_ACTION_LATCH	ORA_CHAR_64	CHAR	64	0	Oracle Monitoring: gv$sql action
11	EXECUTIONS	☐			DEC	22	0
12	CACHE_HIT_RAT	☐			DEC	22	3
13	DISK_READS	☐			DEC	22	0
14	DISK_READ_RAT	☐			DEC	22	3
15	BUFFER_GETS	☐			DEC	22	0
16	LOG_READ_RAT	☐			DEC	22	3
17	ROWS_PROC	☐			DEC	22	0
18	ROWS_PER_EXEC	☐			DEC	22	3
19	BUFFGETS_PER_ROW	☐			DEC	22	3
20	SORTS	☐			DEC	22	0
21	CPU_TIME	☐			DEC	22	0
22	USER_OPEN	☐			DEC	22	0
23	OPENING_VERS	☐			DEC	22	0
24	LOAD_VERS	☐			DEC	22	0
25	NB_CHILDS	☐			DEC	22	0
26	SH_MEM	☐			DEC	22	0
27	PERS_MEM	☐			DEC	22	0
28	RUNTIME_MEM	☐			DEC	22	0
29	INVALIDATIONS	☐			DEC	22	0
30	PARSE_CALL	☐			DEC	22	0
31	ITL_WAITS	☐			DEC	22	0
32	BUFF_BUSY_W	☐			DEC	22	0
33	DB_BLOCK_CHANGES	☐			DEC	22	0
34	GLOB_CACHE_CR	☐			DEC	22	0
35	GLOBAL_CACHE_CUR	☐			DEC	22	0
36	LOGICAL_READS	☐			DEC	22	0
37	PHYSICAL_READS	☐			DEC	22	0
38	PHYS_READS_DIR	☐			DEC	22	0
39	PHYSICAL_WRITES	☐			DEC	22	0
40	PHYS_WRITES_DIR	☐			DEC	22	0
41	ROW_LOCK_WAITS	☐			DEC	22	0

History

Last changed by/on	SAP	20070813
SAP Release Created in	700