||Oracle Tips by Burleson
Oracle 10g Rule-based Propagations for User-enqueued
notification_action => 'www.myshop.com:8080'
You can monitor dequeue operations with the
newly introduced view dba_streams_message_consumers when
notifications are configured, and with dba_streams_message_rules
when rules for de-queuing or applying rules have been defined.
To view all the rules created with the
add_message_rule procedure of dbms_streams_adm, use the statement:
streams_name, streams_type, message_type_owner, message_type_name,
Get the complete story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details: