Advanced Queuing Data

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

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
OEM_MONITOR SYS ALERT_QUE SYS 0 1

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 value 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 value ENQUEUE_TIME SINGLE NONE
SYSTEM DEF$_AQERROR VARIANT Null value ENQUEUE_TIME SINGLE NONE

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 730 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

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 87332

Back to top