19 Monitoring a Streams Environment

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

This chapter contains these topics:

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

Note:

The Streams tool in the Oracle Enterprise Manager Console is also an excellent way to monitor a Streams environment. See the online help for the Streams tool for more information.

Summary of Streams Static Data Dictionary Views

Table 19-1 lists the Streams static data dictionary views.

Table 19-1 Streams Static Data Dictionary Views

ALL_ Views	DBA_ Views	USER_ Views
`ALL_APPLY`	`DBA_APPLY`	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
`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_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
N/A	`DBA_STREAMS_DELETE_COLUMN`	N/A
`ALL_STREAMS_GLOBAL_RULES`	`DBA_STREAMS_GLOBAL_RULES`	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
`ALL_STREAMS_TABLE_RULES`	`DBA_STREAMS_TABLE_RULES`	N/A
`ALL_STREAMS_TRANSFORM_FUNCTION`	`DBA_STREAMS_TRANSFORM_FUNCTION`	N/A
N/A	`DBA_STREAMS_TRANSFORMATIONS`	N/A
`ALL_STREAMS_UNSUPPORTED`	`DBA_STREAMS_UNSUPPORTED`	N/A

Summary of Streams Dynamic Performance Views

The Streams dynamic performance views are:

Note:

When monitoring a Real Application Clusters (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.