dbms_aq_monitor
edited Nov 5, 2013 10:14PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
Hello,
What I'm trying to find out are the features of the dbms_aq_monitor-package. The statistics have already been described, so data like total "enqueued messages" and "average time per enqueue/dequeue".
What I'm looking for is data like "total processing time per message". Can the dbms_aq_monitor package provide that for me? If so is there a way to get this same data from oracle views without having to install the dbms_aq_monitor-package? Any help is welcome. Thank you in advance...
What I'm trying to find out are the features of the dbms_aq_monitor-package. The statistics have already been described, so data like total "enqueued messages" and "average time per enqueue/dequeue".
What I'm looking for is data like "total processing time per message". Can the dbms_aq_monitor package provide that for me? If so is there a way to get this same data from oracle views without having to install the dbms_aq_monitor-package? Any help is welcome. Thank you in advance...
0