Several tools are available for configuring, administering, and monitoring your Oracle Streams environment. Oracle-supplied PL/SQL packages are the primary configuration and management tools, and the Oracle Streams tool in Oracle Enterprise Manager Cloud Control provides some configuration, administration, and monitoring capabilities to help you manage your environment. Additionally, Oracle Streams data dictionary views keep you informed about your Oracle Streams environment.
The following topics describe the tools that you can use for Oracle Streams administration:
14.1 Oracle-Supplied PL/SQL Packages
The following Oracle-supplied PL/SQL packages contain procedures and functions for configuring and managing an Oracle Streams environment.
14.1.1 DBMS_APPLY_ADM Package
DBMS_APPLY_ADM package provides an administrative interface for starting, stopping, and configuring an apply process. This package includes procedures that enable you to configure apply handlers, set enqueue destinations for messages, and specify execution directives for messages. This package also provides administrative procedures that set the instantiation SCN for objects at a destination database. This package also includes subprograms for configuring conflict detection and resolution and for managing apply errors.
14.1.2 DBMS_CAPTURE_ADM Package
DBMS_CAPTURE_ADM package provides an administrative interface for starting, stopping, and configuring a capture process. It also provides an administrative interface for configuring a synchronous capture. This package also provides administrative procedures that prepare database objects at the source database for instantiation at a destination database.
14.1.3 DBMS_COMPARISON Package
DBMS_COMPARISON package provides interfaces to compare and converge database objects at different databases.
14.1.4 DBMS_PROPAGATION_ADM Package
14.1.5 DBMS_RULE Package
DBMS_RULE package contains the
EVALUATE procedure, which evaluates a rule set. The goal of this procedure is to produce the list of satisfied rules, based on the data. This package also contains subprograms that enable you to use iterators during rule evaluation. Instead of returning all rules that evaluate to
MAYBE for an evaluation, iterators can return one rule at a time.
14.1.6 DBMS_RULE_ADM Package
14.1.7 DBMS_STREAMS Package
DBMS_STREAMS package provides interfaces to convert
ANYDATA objects into LCR objects, to return information about Oracle Streams attributes and Oracle Streams clients, and to annotate redo entries generated by a session with a tag. This tag can affect the behavior of a capture process, a synchronous capture, a propagation, an apply process, or a messaging client whose rules include specifications for these tags in redo entries or LCRs.
14.1.8 DBMS_STREAMS_ADM Package
DBMS_STREAMS_ADM package provides an administrative interface for adding and removing simple rules for capture processes, propagations, and apply processes at the table, schema, and database level. This package also enables you to add rules that control which messages a propagation propagates and which messages a messaging client dequeues. This package also contains procedures for creating queues and for managing Oracle Streams metadata, such as data dictionary information. This package also contains procedures that enable you to configure and maintain an Oracle Streams replication environment. This package is provided as an easy way to complete common tasks in an Oracle Streams environment. You can use other packages, such as the
DBMS_AQADM packages, to complete these same tasks, as well as tasks that require additional customization.
14.1.9 DBMS_STREAMS_ADVISOR_ADM Package
DBMS_STREAMS_ADVISOR_ADM package provides an interface to gather information about an Oracle Streams environment and advise database administrators based on the information gathered. This package is part of the Oracle Streams Performance Advisor.
14.1.10 DBMS_STREAMS_AUTH Package
DBMS_STREAMS_AUTH package provides interfaces for granting privileges to and revoking privileges from Oracle Streams administrators.
14.1.11 DBMS_STREAMS_HANDLER_ADM Package
14.1.12 DBMS_STREAMS_MESSAGING Package
DBMS_STREAMS_MESSAGING package provides interfaces to enqueue messages into and dequeue messages from an
14.1.13 DBMS_STREAMS_TABLESPACE_ADM Package
DBMS_STREAMS_TABLESPACE_ADM package provides administrative procedures for creating and managing a tablespace repository. This package also provides administrative procedures for copying tablespaces between databases and moving tablespaces from one database to another. This package uses transportable tablespaces, Data Pump, and the
14.1.14 UTL_SPADV Package
UTL_SPADV package provides subprograms to collect and analyze statistics for the Oracle Streams components in a distributed database environment. This package uses the Oracle Streams Performance Advisor to gather statistics.
Oracle Database PL/SQL Packages and Types Reference for more information about these packages
14.2 Oracle Streams Data Dictionary Views
Every database in an Oracle Streams environment has Oracle Streams data dictionary views. These views maintain administrative information about local rules, objects, capture processes, propagations, apply processes, and messaging clients. You can use these views to monitor your Oracle Streams environment.
14.3 Oracle Streams Tool in Oracle Enterprise Manager Cloud Control
To help configure, administer, and monitor Oracle Streams environments, Oracle provides an Oracle Streams tool in Oracle Enterprise Manager Cloud Control. You can also use the Oracle Streams tool to generate Oracle Streams configuration scripts, which you can then modify and run to configure your Oracle Streams environment. The Oracle Streams tool online Help contains the primary documentation for this tool.
The online Help for the Oracle Streams tool in the Oracle Enterprise Manager Cloud Control