V$QMON_COORDINATOR_STATS
displays statistics of the non-sharded queue master process. There is one row per instance. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.
Column | Datatype | Description |
---|---|---|
|
|
Non-sharded queue master process ID |
|
|
Current status of the coordinator:
|
|
|
Number of QMON servers currently running |
|
|
Last server startup time |
|
|
Process ID of the last server process (Qnnn) created |
|
|
Next wakeup time of the coordinator |
|
|
Ready time of the first delayed task |
|
|
Expiry time of the next ready task |
|
|
Time when the coordinator went to sleep |
|
|
Last failure encountered |
|
|
Last failure time |
|
|
Maximum task latency across all the servers (in seconds) |
|
|
Minimum task latency across all the servers (in seconds) |
|
|
Cumulative latency across all the tasks (in seconds) |
|
|
Cumulative number of tasks serviced by all the servers |
|
|
Maximum number of servers present at any point of time |
|
|
The ID of the container to which the data pertains. The |