最近花点时间在研究streams replication.下面是从Metalink上查来的关于Streams的configuration View帖上来和大家分享。文档号Note:225230.1
PURPOSE
-------
This Note describes Oracle 9i Streams DBA views

SCOPE & APPLICATION
-------------------
To be used by DBA's as a reference when configuring and
troubleshooting Oracle Streams.

OWNERSHIP
---------
The views are all owned by SYS

VIEWS
-----
dba_apply
dba_apply_conflict_columns
dba_apply_dml_handlers
dba_apply_error
dba_apply_instantiated_objects
dba_apply_key_columns
dba_apply_progress
dba_apply_parameters
dba_aq_agents
dba_aq_agent_privs
dba_db_links
dba_capture
dba_capture_parameters
dba_capture_prepared_database
dba_capture_prepared_schema
dba_capture_prepared_tables
dba_evaluation_contexts
dba_evaluation_context_tables
dba_evaluation_context_vars
dba_jobs
dba_jobs_running
dba_log_groups
dba_log_group_columns
dba_propagation
dba_queues
dba_queue_publishers
dba_queue_schedules
dba_queue_tables
aq$
dba_rules
dba_rule_sets
dba_rule_set_rules
dba_streams_global_rules
dba_streams_schema_rules
dba_streams_table_rules
dba_tables
V$DATABASE
V$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER
V$STREAMS_CAPTURE

APPLY INFORMATION
-----------------
dba_apply
dba_apply_conflict_columns
dba_apply_dml_handlers
dba_apply_error
dba_apply_instantiated_objects
dba_apply_key_columns
dba_apply_progress
dba_apply_parameters
V$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER

CAPTURE INFORMATION
-------------------
dba_capture
dba_capture_parameters
dba_capture_prepared_database
dba_capture_prepared_schema
dba_capture_prepared_tables
V$STREAMS_CAPTURE

ENQUEUE AND DEQUEUE INFORMATION
-------------------------------
aq$

QUEUE INFORMATION
-----------------
dba_queues
dba_queue_publishers

QUEUE TABLE INFORMATION
-----------------------
dba_queue_tables

MESSAGING INFORMATION
---------------------
dba_aq_agents
dba_aq_agent_privs

PROPAGATION INFORMATION
-----------------------
dba_db_links
dba_jobs
dba_jobs_running
dba_propagation
dba_queue_schedules

RULES INFORMATION
-----------------
dba_evaluation_contexts
dba_evaluation_context_tables
dba_evaluation_context_vars
dba_rules
dba_rule_sets
dba_rule_set_rules
dba_streams_global_rules
dba_streams_schema_rules
dba_streams_table_rules

SUPPLEMENTAL LOGGING INFORMATION
--------------------------------
dba_log_groups
dba_log_group_columns
V$DATABASE (columns FORCE_LOGGING SUPPLEMENTAL_LOG_DATA_*)

SET TABLESPACE INFORMATION
--------------------------
dba_tables

RELATED DOCUMENTS
-----------------
Oracle9i Database Reference Guide Release 2
Oracle9i Streams Release 2 (9.2)

ITPub博客

STRM--Streams: Quick Reference Configuration Views(zt)

最新文章