Question: What does the
v$qmon_task_stats view do?
Answer: Starting in 11g, the
v$qmon_task_stats shows all the
QMON tasks. Also see:
The Oracle docs note that
v$qmon_task_stats
view shows details relating to the following
tasks, based on the
v$qmon_task_stats
columns, task_name and remark
:
Task Name
|
Remark
|
QMON_PERSISTENT_TM
|
Persistent
messages time manager activity
|
QMON_SPILL
|
Buffered messages
spilling
|
QMON_DEALLOC_SPILLED
|
Spilled messages
memory deallocation
|
QMON_DELETE_SPILLED
|
Dequeued spilled
messages deletion
|
QMON_PURGE
|
Not specified
|
QMON_COMPUTE_ACKS
|
Acknowledgement
update for a queue locally
|
QMON_FLUSH_STATS
|
Replay info table
update
|
QMON_PROCESS_IPC
|
IPC message send
and receive for queue operations
|
QMON_RECOVER_SPILLED
|
Spilled messages
recovery on startup
|
QMON_PROP_MSGDELETE
|
Acknowledged
buffered messages deletion
|
QMON_JOBCACHE_REPARTITION
|
Queue table
ownership change
|
QMON_PURGE_SPILLED
|
Purge spilled
messages at startup
|
QMON_BUFFERED_TM_COORD
|
Buffered messages
time manager activity check
|
QMON_BUFFERED_TM
|
Buffered messages
time manager activity
|
QMON_QUEUE_SERVICE_START Start queue services at
startup
|
Start queue
services at startup
|
QMON_PURGE_REGISTRATION
|
Notification
registration purge
|
QMON_RECOVER_EMON
|
EMON recovery at
startup
|
QMON_ORPHANED_MSGDELETE Orphaned messages deletion
|
Orphaned messages
deletion
|
QMON_SEND_ALTEROWNER
|
Non-owner
persistent time manager activity send to owner
|
QMON_NONDURSUB_SESS_DEL
|
Session end
nondurable subscriber delete
|
QMON_NONDURSUB_INST_DEL
|
Instance end
Nondurable subscriber delete
|
QMON_DELETE_DEADREG
|
Notification
delete registrations of dead locations
|