DBA_HIST_PERSISTENT_QMN_CACHE
displays the historical summary background queue table activity. This view contains snapshots from V$PERSISTENT_QMN_CACHE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Queue table object ID |
|
|
Type of the queue table's queue monitor cache |
|
|
|
Status of the queue table's queue monitor cache |
|
|
|
Time when the queue table should be serviced by QMON servers |
|
|
|
Time manager activity period for non-owner queue table operations |
|
|
|
Total number of times this queue table is served |
|
|
|
Cumulative latency in serving the queue table (in hundredths of a second) |
|
|
|
Total time spent in processing this queue table (in seconds) |
|
|
|
Cumulative CPU time for serving the queue table (in hundredths of a second) |
|
|
|
Number of time manager entries processed |
|
|
|
Cumulative time for time management activities (in hundredths of a second) |
|
|
|
Cumulative CPU time for time management activities (in hundredths of a second) |
|
|
|
Last timer manager processing time |
|
|
|
Number of dequeue log entries processed |
|
|
|
Total time for processing dequeue log entries (in hundredths of a second) |
|
|
|
Total CPU time for processing dequeue log entries (in hundredths of a second) |
|
|
|
Last dequeue log processing time |
|
|
|
Number of dequeue index blocks freed |
|
|
|
Number of history index blocks freed |
|
|
|
Number of time manager index blocks freed |
|
|
|
Number of times index block cleanup was attempted |
|
|
|
Total time for index block cleanup (in hundredths of a second) |
|
|
|
Total CPU time for index block cleanup (in hundredths of a second) |
|
|
|
Last index block cleanup time |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: