Select All Queue Tables in Database 

DBA_QUEUE_TABLES 

Select User Queue Tables 

ALL_QUEUE_TABLES 

Select All Queues in Database 

DBA_QUEUES 

Select All Propagation Schedules 

DBA_QUEUE_SCHEDULES 

Select Queues for Which User Has Any Privilege 

ALL_QUEUES 

Select Queues for Which User Has Queue Privilege 

QUEUE_PRIVILEGES 

Select Messages in Queue Table 

AQ$<name of queue table> 

Select Queue Tables in User Schema 

USER_QUEUE_TABLES 

Select Queues In User Schema 

USER_QUEUES 

Select Propagation Schedules in User Schema 

USER_QUEUE_SCHEDULES 

Select Queue Subscribers 

AQ$<name of queue table>_S 

Select Queue Subscribers and Their Rules 

AQ$<name of queue table>_R 

Select the Number of Messages in Different States for the Whole Database 

GV$AQ 

Select the Number of Messages in Different States for Specific Instances 

VSAQ