SNAPSHOT_ID |
✔ |
Oracle monitor: snapshot ID |
ORA_SNAPSHOT_ID |
NUMC |
10 |
* |
INST_ID |
✔ |
Oracle monitor: Instance ID |
ORA_INST_ID |
DEC |
22 |
|
CACHE_NR |
✔ |
Oracle Monitoring: CACHE# |
ORA_CACHE |
DEC |
22 |
|
TYPE |
✔ |
Oracle Monitoring: Parent or subordinate row cache type |
ORA_TYPE_ROW |
CHAR |
11 |
|
SUBORDINATE |
✔ |
Oracle Monitoring: Subordinate set number |
ORA_SUBORDINATE |
DEC |
22 |
|
PARAMETER_ROW |
|
Oracle monitoring: Name of the initialization parameter |
ORA_PARAMETER_ROW |
CHAR |
32 |
|
COUNT_ROW |
|
Oracle monitoring: COUNT |
ORA_COUNT |
DEC |
22 |
|
USAGE_ROW |
|
Oracle monitoring: Number of cache entries that contain vali |
ORA_USAGE |
DEC |
22 |
|
FIXED |
|
Oracle monitoring: Number of fixed entries in the cache |
ORA_FIXED |
DEC |
22 |
|
GETS |
|
Oracle monitoring: Total number of requests for information |
ORA_GETS_CACHE |
DEC |
22 |
|
GETMISSES |
|
Oracle monitoring: Number of data requests resulting in cach |
ORA_GET_MISSES |
DEC |
22 |
|
SCANS |
|
Oracle monitoring: Number of scan requests |
ORA_SCANS |
DEC |
22 |
|
SCANMISSES |
|
Oracle monitoring: # scan failed to find data in cache |
ORA_SCANMISSES |
DEC |
22 |
|
SCANCOMPLETES |
|
Oracle monitoring: number of times the list was scanned comp |
ORA_SCANCOMPLETES |
DEC |
22 |
|
MODIFICATIONS |
|
Oracle monitoring: Number of inserts, updates, and deletions |
ORA_MODIFICATIONS |
DEC |
22 |
|
FLUSHES |
|
Oracle monitoriing: Number of times flushed to disk |
ORA_FLUSHES |
DEC |
22 |
|
DLM_REQUESTS |
|
Oracle monitoring: Number of DLM requests |
ORA_DLM_REQUESTS |
DEC |
22 |
|
DLM_CONFLICTS |
|
Oracle monitoring: Number of DLM conflicts |
ORA_DLM_CONFLICTS |
DEC |
22 |
|
DLM_RELEASES |
|
Oracle monitoring: Number of DLM releases |
ORA_DLM_RELEASES |
DEC |
22 |
|