8.116 V$PERSISTENT_QMN_CACHE
V$PERSISTENT_QMN_CACHE
displays detailed information and statistics about the background activities for all queue tables in the system. There is one row per queue table. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.
Column | Datatype | Description |
---|---|---|
|
|
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 ID of the container to which the data pertains. Possible values include:
|