Monday, April 30, 2007

Oracle Advanced Queue -- View Subscriber Registrations

Have you ever wanted to see what registrations/notfications you have registered to a queue subscriber? I want to see that, but why is it so hard to figure out where the info is? I see some mention of SYS.AQ_SRVNTFN_TABLE_Q, but I haven't been able to look into that possibility.

Update: This gives what you need, but it is not as nice as I would like.
SELECT * FROM sys.reg$

No comments: