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