SAP ABAP Table STI_ROWCACHE (Oracle monitoring: structure for GV$ROWCACHE.)
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 | STI_ROWCACHE | Table Relationship Diagram |
Short Description | Oracle monitoring: structure for GV$ROWCACHE. |
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 | CACHE_NR | ORA_CACHE | ORA_DEC_22 | DEC | 22 | 0 | Oracle Monitoring: CACHE# | ||
3 | TYPE | ORA_TYPE_ROW | ORA_CHAR_11 | CHAR | 11 | 0 | Oracle Monitoring: Parent or subordinate row cache type | ||
4 | SUBORDINATE | ORA_SUBORDINATE | ORA_NUM_22 | DEC | 22 | 0 | Oracle Monitoring: Subordinate set number | ||
5 | PARAMETER_ROW | ORA_PARAMETER_ROW | ORA_CHAR_32 | CHAR | 32 | 0 | Oracle monitoring: Name of the initialization parameter | ||
6 | COUNT_ROW | ORA_COUNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: COUNT | ||
7 | USAGE_ROW | ORA_USAGE | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of cache entries that contain vali | ||
8 | FIXED | ORA_FIXED | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of fixed entries in the cache | ||
9 | GETS | ORA_GETS_CACHE | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Total number of requests for information | ||
10 | GETMISSES | ORA_GET_MISSES | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of data requests resulting in cach | ||
11 | SCANS | ORA_SCANS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of scan requests | ||
12 | SCANMISSES | ORA_SCANMISSES | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: # scan failed to find data in cache | ||
13 | SCANCOMPLETES | ORA_SCANCOMPLETES | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: number of times the list was scanned comp | ||
14 | MODIFICATIONS | ORA_MODIFICATIONS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of inserts, updates, and deletions | ||
15 | FLUSHES | ORA_FLUSHES | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoriing: Number of times flushed to disk | ||
16 | DLM_REQUESTS | ORA_DLM_REQUESTS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of DLM requests | ||
17 | DLM_CONFLICTS | ORA_DLM_CONFLICTS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of DLM conflicts | ||
18 | DLM_RELEASES | ORA_DLM_RELEASES | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of DLM releases |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 700 |