22 Monitoring an Oracle Streams Environment

This chapter lists the static data dictionary views and dynamic performance views related to Oracle Streams. You can use these views to monitor your Oracle Streams environment.

The following sections contain data dictionary views for monitoring an Oracle Streams environment:

Summary of Oracle Streams Static Data Dictionary Views
Summary of Oracle Streams Dynamic Performance Views

Note:

The Oracle Streams tool in Oracle Enterprise Manager is also an excellent way to monitor an Oracle Streams environment. See Oracle Database 2 Day + Data Replication and Integration Guide and the online Help for the Oracle Streams tool for more information.

Summary of Oracle Streams Static Data Dictionary Views

Table 22-1 lists the Oracle Streams static data dictionary views.

Table 22-1 Oracle Streams Static Data Dictionary Views

ALL_ Views	DBA_ Views	USER_ Views
`ALL_APPLY`	`DBA_APPLY`	N/A
`ALL_APPLY_CHANGE_HANDLERS`	`DBA_APPLY_CHANGE_HANDLERS`	N/A
`ALL_APPLY_CONFLICT_COLUMNS`	`DBA_APPLY_CONFLICT_COLUMNS`	N/A
`ALL_APPLY_DML_HANDLERS`	`DBA_APPLY_DML_HANDLERS`	N/A
`ALL_APPLY_ENQUEUE`	`DBA_APPLY_ENQUEUE`	N/A
`ALL_APPLY_ERROR`	`DBA_APPLY_ERROR`	N/A
`ALL_APPLY_EXECUTE`	`DBA_APPLY_EXECUTE`	N/A
N/A	`DBA_APPLY_INSTANTIATED_GLOBAL`	N/A
N/A	`DBA_APPLY_INSTANTIATED_OBJECTS`	N/A
N/A	`DBA_APPLY_INSTANTIATED_SCHEMAS`	N/A
`ALL_APPLY_KEY_COLUMNS`	`DBA_APPLY_KEY_COLUMNS`	N/A
N/A	`DBA_APPLY_OBJECT_DEPENDENCIES`	N/A
`ALL_APPLY_PARAMETERS`	`DBA_APPLY_PARAMETERS`	N/A
`ALL_APPLY_PROGRESS`	`DBA_APPLY_PROGRESS`	N/A
N/A	`DBA_APPLY_SPILL_TXN`	N/A
`ALL_APPLY_TABLE_COLUMNS`	`DBA_APPLY_TABLE_COLUMNS`	N/A
N/A	`DBA_APPLY_VALUE_DEPENDENCIES`	N/A
`ALL_CAPTURE`	`DBA_CAPTURE`	N/A
`ALL_CAPTURE_EXTRA_ATTRIBUTES`	`DBA_CAPTURE_EXTRA_ATTRIBUTES`	N/A
`ALL_CAPTURE_PARAMETERS`	`DBA_CAPTURE_PARAMETERS`	N/A
`ALL_CAPTURE_PREPARED_DATABASE`	`DBA_CAPTURE_PREPARED_DATABASE`	N/A
`ALL_CAPTURE_PREPARED_SCHEMAS`	`DBA_CAPTURE_PREPARED_SCHEMAS`	N/A
`ALL_CAPTURE_PREPARED_TABLES`	`DBA_CAPTURE_PREPARED_TABLES`	N/A
N/A	`DBA_COMPARISON`	`USER_COMPARISON`
N/A	`DBA_COMPARISON_COLUMNS`	`USER_COMPARISON_COLUMNS`
N/A	`DBA_COMPARISON_ROW_DIF`	`USER_COMPARISON_ROW_DIF`
N/A	`DBA_COMPARISON_SCAN`	`USER_COMPARISON_SCAN`
N/A	`DBA_COMPARISON_SCAN_VALUES`	`USER_COMPARISON_SCAN_VALUES`
`ALL_EVALUATION_CONTEXT_TABLES`	`DBA_EVALUATION_CONTEXT_TABLES`	`USER_EVALUATION_CONTEXT_TABLES`
`ALL_EVALUATION_CONTEXT_VARS`	`DBA_EVALUATION_CONTEXT_VARS`	`USER_EVALUATION_CONTEXT_VARS`
`ALL_EVALUATION_CONTEXTS`	`DBA_EVALUATION_CONTEXTS`	`USER_EVALUATION_CONTEXTS`
`ALL_FILE_GROUP_EXPORT_INFO`	`DBA_FILE_GROUP_EXPORT_INFO`	`USER_FILE_GROUP_EXPORT_INFO`
`ALL_FILE_GROUP_FILES`	`DBA_FILE_GROUP_FILES`	`USER_FILE_GROUP_FILES`
`ALL_FILE_GROUP_TABLES`	`DBA_FILE_GROUP_TABLES`	`USER_FILE_GROUP_TABLES`
`ALL_FILE_GROUP_TABLESPACES`	`DBA_FILE_GROUP_TABLESPACES`	`USER_FILE_GROUP_TABLESPACES`
`ALL_FILE_GROUP_VERSIONS`	`DBA_FILE_GROUP_VERSIONS`	`USER_FILE_GROUP_VERSIONS`
`ALL_FILE_GROUPS`	`DBA_FILE_GROUPS`	`USER_FILE_GROUPS`
N/A	`DBA_HIST_STREAMS_APPLY_SUM`	N/A
N/A	`DBA_HIST_STREAMS_CAPTURE`	N/A
N/A	`DBA_HIST_STREAMS_POOL_ADVICE`	N/A
`ALL_PROPAGATION`	`DBA_PROPAGATION`	N/A
N/A	`DBA_RECOVERABLE_SCRIPT`	N/A
N/A	`DBA_RECOVERABLE_SCRIPT_BLOCKS`	N/A
N/A	`DBA_RECOVERABLE_SCRIPT_ERRORS`	N/A
N/A	`DBA_RECOVERABLE_SCRIPT_HIST`	N/A
N/A	`DBA_RECOVERABLE_SCRIPT_PARAM`	N/A
N/A	`DBA_REGISTERED_ARCHIVED_LOG`	N/A
`ALL_RULE_SET_RULES`	`DBA_RULE_SET_RULES`	`USER_RULE_SET_RULES`
`ALL_RULE_SETS`	`DBA_RULE_SETS`	`USER_RULE_SETS`
`ALL_RULES`	`DBA_RULES`	`USER_RULES`
N/A	`DBA_STREAMS_ADD_COLUMN`	N/A
N/A	`DBA_STREAMS_ADMINISTRATOR`	N/A
`ALL_STREAMS_COLUMNS`	`DBA_STREAMS_COLUMNS`	N/A
N/A	`DBA_STREAMS_DELETE_COLUMN`	N/A
`ALL_STREAMS_GLOBAL_RULES`	`DBA_STREAMS_GLOBAL_RULES`	N/A
N/A	`DBA_STREAMS_KEEP_COLUMNS`	N/A
`ALL_STREAMS_MESSAGE_CONSUMERS`	`DBA_STREAMS_MESSAGE_CONSUMERS`	N/A
`ALL_STREAMS_MESSAGE_RULES`	`DBA_STREAMS_MESSAGE_RULES`	N/A
`ALL_STREAMS_NEWLY_SUPPORTED`	`DBA_STREAMS_NEWLY_SUPPORTED`	N/A
N/A	`DBA_STREAMS_RENAME_COLUMN`	N/A
N/A	`DBA_STREAMS_RENAME_SCHEMA`	N/A
N/A	`DBA_STREAMS_RENAME_TABLE`	N/A
`ALL_STREAMS_RULES`	`DBA_STREAMS_RULES`	N/A
`ALL_STREAMS_SCHEMA_RULES`	`DBA_STREAMS_SCHEMA_RULES`	N/A
N/A	`DBA_STREAMS_SPLIT_MERGE`	N/A
N/A	`DBA_STREAMS_SPLIT_MERGE_HIST`	N/A
N/A	`DBA_STREAMS_STMT_HANDLERS`	N/A
N/A	`DBA_STREAMS_STMTS`	N/A
`ALL_STREAMS_TABLE_RULES`	`DBA_STREAMS_TABLE_RULES`	N/A
N/A	`DBA_STREAMS_TRANSFORMATIONS`	N/A
`ALL_STREAMS_TRANSFORM_FUNCTION`	`DBA_STREAMS_TRANSFORM_FUNCTION`	N/A
N/A	`DBA_STREAMS_TP_COMPONENT`	N/A
N/A	`DBA_STREAMS_TP_COMPONENT_LINK`	N/A
N/A	`DBA_STREAMS_TP_COMPONENT_STAT`	N/A
N/A	`DBA_STREAMS_TP_DATABASE`	N/A
N/A	`DBA_STREAMS_TP_PATH_BOTTLENECK`	N/A
N/A	`DBA_STREAMS_TP_PATH_STAT`	N/A
`ALL_STREAMS_UNSUPPORTED`	`DBA_STREAMS_UNSUPPORTED`	N/A
`ALL_SYNC_CAPTURE`	`DBA_SYNC_CAPTURE`	N/A
`ALL_SYNC_CAPTURE_PREPARED_TABS`	`DBA_SYNC_CAPTURE_PREPARED_TABS`	N/A
N/A	`DBA_SYNC_CAPTURE_TABLES`	N/A

Summary of Oracle Streams Dynamic Performance Views

The Oracle Streams dynamic performance views are:

Note:

When monitoring an Oracle Real Application Clusters (Oracle RAC) database, use the GV$ versions of the dynamic performance views.
To collect elapsed time statistics in these dynamic performance views, set the TIMED_STATISTICS initialization parameter to TRUE.