SAP ABAP Table ORA_TABACCESS (Oracle Table Access Monitor Structure)
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
⤷ 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_TABACCESS | Table Relationship Diagram |
Short Description | Oracle Table Access Monitor Structure |
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 |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 700 |