11g and 10g both have the all_queue_subscribers (and user_, dba_) dictionary tables for listing the subscribers to queues, but this doesn't exist on 9i. Does the same concept of queue subscribers exist on 9i databases, and where can I get this information from?
Asked
Active
Viewed 320 times
0
thecoop
- 45,220
- 19
- 132
- 189
1 Answers
0
In 9i the interface was not as friendly. Each queue table had its own view, in the format AQ$<queue_table_name>_S. This is explained in the documentation. Find out more.
APC
- 144,005
- 19
- 170
- 281