SELECT queue_name, queue_table, queue_type
FROM DBA_QUEUES;

SELECT queue_table, comment, message_type
FROM DBA_QUEUE_TABLES;