Streams: 9i Quick Reference Configuration Views

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$<queue table name>
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 table name>

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

© 2005 – 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. How To Troubleshoot the Streams Apply Process
2. DIAG: Alter System Dump Undo – Quick Reference