||Oracle Tips by Burleson
Oracle 10g Simplified Configuration
Oracle Database 10g has added quite a lot of
additional support by simplifying the configuration methodology for
enqueue and dequeue of messages.
The newly introduced package
dbms_streams_messaging provides an easy interface for enqueuing
messages to and dequeuing messages from queues created with
When specifying the queue into which the
message should be enqueued, the current database must contain the
queue and the queue must be a secure queue of sys.anydata type. The
DEQUEUE procedure of dbms_streams_messaging uses the specified
Streams messaging client to dequeue a message from the specified
Let us examine these enhancements, which are
mostly by way of adding new procedures.
and User-enqueued Messages
A new procedure, add_message_rule in the
dbms_streams_adm package, enables you to configure messaging clients
and the apply process, and it enables you to create the rules for
user-enqueued messages that control the behavior of these messaging
clients and apply processes.
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: