ITPub博客

首页 > Linux操作系统 > Linux操作系统 > STRM--Streams: Quick Reference Configuration Views(zt)

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

原创 Linux操作系统 作者:vongates 时间:2019-07-17 10:30:02 0 删除 编辑
最近花点时间在研究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博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51948/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    449
  • 访问量
    291741