<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.23 -->
<!-- Module:S201DBA Version:2.12 Report:aq_data OS:linux -->
---+!! Advanced Queuing Data
%TOC%
---+ Table Privileges for AQ Roles
|*Grantee*|*Owner*|*Table Name*|*Grantor*|*Privilege*|*Grantable*|*Hierarchy*|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_TRANSFORM|SYS|EXECUTE|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_AQELM|SYS|EXECUTE|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_AQJMS_INTERNAL|SYS|EXECUTE|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_AQIN|SYS|EXECUTE|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBA_QUEUE_SUBSCRIBERS|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_RULE_EXIMP|SYS|EXECUTE|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|AQ$_PROPAGATION_STATUS|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBA_QUEUE_TABLES|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBA_QUEUES|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBA_QUEUE_SCHEDULES|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|V_$AQ|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|GV_$AQ|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|AQ$INTERNET_USERS|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBA_AQ_AGENTS|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBA_AQ_AGENT_PRIVS|SYS|SELECT|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_AQ|SYS|EXECUTE|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_AQADM|SYS|EXECUTE|NO|NO|
|AQ_ADMINISTRATOR_ROLE|SYS|DBMS_AQ_IMPORT_INTERNAL|SYS|EXECUTE|NO|NO|
|AQ_USER_ROLE|SYS|DBMS_AQ|SYS|EXECUTE|NO|NO|
|AQ_USER_ROLE|SYS|DBMS_AQIN|SYS|EXECUTE|NO|NO|
|AQ_USER_ROLE|SYS|DBMS_AQJMS_INTERNAL|SYS|EXECUTE|NO|NO|
|AQ_USER_ROLE|SYS|DBMS_TRANSFORM|SYS|EXECUTE|NO|NO|
[[#Top][Back to top]]
---+ Queue Privileges Data
|*Grantee*|*Owner*|*Name*|*Grantor*|*Enqueue Privilege*|*Dequeue Privilege*|
|PUBLIC|SYS|SCHEDULER$_EVENT_QUEUE|SYS|0|1|
|PUBLIC|SYS|SRVQUEUE|SYS|0|1|
[[#Top][Back to top]]
---+ Queue Tables Data
|*Owner*|*Queue Table*|*Type*|*Object Type*|*Sort Order*|*Recipients*|*Message Grouping*|
|SYS|ALERT_QT|OBJECT|SYS.ALERT_TYPE|ENQUEUE_TIME|MULTIPLE|NONE|
|SYS|AQ$_MEM_MC|RAW|%NULL%|ENQUEUE_TIME|MULTIPLE|NONE|
|SYS|AQ_EVENT_TABLE|OBJECT|SYS.AQ$_EVENT_MESSAGE|ENQUEUE_TIME|SINGLE|NONE|
|SYS|AQ_SRVNTFN_TABLE|OBJECT|SYS.AQ$_SRVNTFN_MESSAGE|ENQUEUE_TIME|SINGLE|NONE|
|SYS|KUPC$DATAPUMP_QUETAB|OBJECT|SYS.KUPC$_MESSAGE|ENQUEUE_TIME|MULTIPLE|NONE|
|SYS|SCHEDULER$_EVENT_QTAB|OBJECT|SYS.SCHEDULER$_EVENT_INFO|ENQUEUE_TIME|MULTIPLE|NONE|
|SYS|SCHEDULER$_JOBQTAB|OBJECT|SYS.ANYDATA|ENQUEUE_TIME|MULTIPLE|NONE|
|SYS|SYS$SERVICE_METRICS_TAB|OBJECT|SYS.SYS$RLBTYP|ENQUEUE_TIME|MULTIPLE|NONE|
|SYSMAN|MGMT_NOTIFY_QTABLE|OBJECT|SYSMAN.MGMT_NOTIFY_NOTIFICATION|ENQUEUE_TIME|MULTIPLE|NONE|
|SYSTEM|DEF$_AQCALL|VARIANT|%NULL%|ENQUEUE_TIME|SINGLE|NONE|
|SYSTEM|DEF$_AQERROR|VARIANT|%NULL%|ENQUEUE_TIME|SINGLE|NONE|
[[#Top][Back to top]]
---+ Queue Status Data
|*Owner*|*Name*|*Waiting*|*Ready*|*Expired*|
|SYSMAN|MGMT_NOTIFY_Q|0|0|0|
|SYSMAN|AQ$_MGMT_NOTIFY_QTABLE_E|0|0|0|
|SYS|SYS$SERVICE_METRICS|0|0|0|
|SYS|AQ$_SYS$SERVICE_METRICS_TAB_E|0|0|0|
|SYS|ALERT_QUE|0|0|0|
|SYS|AQ$_ALERT_QT_E|0|0|0|
|SYS|SRVQUEUE|0|0|0|
|SYS|AQ$_AQ$_MEM_MC_E|0|0|0|
|SYS|AQ$_KUPC$DATAPUMP_QUETAB_E|0|0|0|
|SYS|SCHEDULER$_EVENT_QUEUE|0|0|0|
|SYS|AQ$_SCHEDULER$_EVENT_QTAB_E|0|0|0|
|SYS|SCHEDULER$_JOBQ|0|0|0|
|SYS|AQ$_SCHEDULER$_JOBQTAB_E|0|0|0|
|SYSTEM|DEF$_AQERROR|0|0|0|
|SYSTEM|AQ$_DEF$_AQERROR_E|0|0|0|
|SYSTEM|DEF$_AQCALL|0|0|0|
|SYSTEM|AQ$_DEF$_AQCALL_E|0|0|0|
|SYS|AQ_SRVNTFN_TABLE_Q|0|0|0|
|SYS|AQ$_AQ_SRVNTFN_TABLE_E|0|0|0|
|SYS|AQ_EVENT_TABLE_Q|0|0|0|
|SYS|AQ$_AQ_EVENT_TABLE_E|0|0|0|
[[#Top][Back to top]]
---+ AQ$ Queue Tables Data
|*Schema*|*Name*|*Object Number*|
|SYS|AQ_EVENT_TABLE|4811|
|SYS|AQ_SRVNTFN_TABLE|4821|
|SYSTEM|DEF$_AQCALL|4888|
|SYSTEM|DEF$_AQERROR|4900|
|SYS|SCHEDULER$_JOBQTAB|5091|
|SYS|SCHEDULER$_EVENT_QTAB|5179|
|SYS|KUPC$DATAPUMP_QUETAB|7417|
|SYS|AQ$_MEM_MC|8755|
|SYS|ALERT_QT|8844|
|SYS|SYS$SERVICE_METRICS_TAB|9805|
|SYSMAN|MGMT_NOTIFY_QTABLE|53592|
[[#Top][Back to top]]
