5.38 DBA_HIST_ROWCACHE_SUMMARY
DBA_HIST_ROWCACHE_SUMMARY
displays historical summary statistics for data dictionary activity.
This view contains snapshots of V$ROWCACHE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Name of the initialization parameter that determines the number of entries in the data dictionary cache |
|
|
|
Sum of the total number of entries in the cache |
|
|
|
Number of cache entries that contain valid data |
|
|
|
Total number of requests for information on the data object |
|
|
|
Number of data requests resulting in cache misses |
|
|
|
Number of scan requests |
|
|
|
Number of times a scan failed to find the data in the cache |
|
|
|
For a list of subordinate entries, the number of times the list was scanned completely |
|
|
|
Number of inserts, updates, and deletions |
|
|
|
Number of times flushed to disk |
|
|
|
Number of DLM requests |
|
|
|
Number of DLM conflicts |
|
|
|
Number of DLM releases |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: