Streams Concepts and Administration
ContentsOpens a new window
Opens a new window
Page 32 of 57

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:

Note:

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

See Also:

Summary of Oracle Streams Static Data Dictionary Views

Table 22-1Opens a new window lists the Oracle Streams static data dictionary views.

Table 22-1 Oracle Streams Static Data Dictionary Views

ALL_ Views DBA_ Views USER_ Views

ALL_APPLYOpens a new window

DBA_APPLYOpens a new window

N/A

ALL_APPLY_CHANGE_HANDLERSOpens a new window

DBA_APPLY_CHANGE_HANDLERSOpens a new window

N/A

ALL_APPLY_CONFLICT_COLUMNSOpens a new window

DBA_APPLY_CONFLICT_COLUMNSOpens a new window

N/A

ALL_APPLY_DML_HANDLERSOpens a new window

DBA_APPLY_DML_HANDLERSOpens a new window

N/A

ALL_APPLY_ENQUEUEOpens a new window

DBA_APPLY_ENQUEUEOpens a new window

N/A

ALL_APPLY_ERROROpens a new window

DBA_APPLY_ERROROpens a new window

N/A

ALL_APPLY_EXECUTEOpens a new window

DBA_APPLY_EXECUTEOpens a new window

N/A

N/A

DBA_APPLY_INSTANTIATED_GLOBALOpens a new window

N/A

N/A

DBA_APPLY_INSTANTIATED_OBJECTSOpens a new window

N/A

N/A

DBA_APPLY_INSTANTIATED_SCHEMASOpens a new window

N/A

ALL_APPLY_KEY_COLUMNSOpens a new window

DBA_APPLY_KEY_COLUMNSOpens a new window

N/A

N/A

DBA_APPLY_OBJECT_DEPENDENCIESOpens a new window

N/A

ALL_APPLY_PARAMETERSOpens a new window

DBA_APPLY_PARAMETERSOpens a new window

N/A

ALL_APPLY_PROGRESSOpens a new window

DBA_APPLY_PROGRESSOpens a new window

N/A

N/A

DBA_APPLY_SPILL_TXNOpens a new window

N/A

ALL_APPLY_TABLE_COLUMNSOpens a new window

DBA_APPLY_TABLE_COLUMNSOpens a new window

N/A

N/A

DBA_APPLY_VALUE_DEPENDENCIESOpens a new window

N/A

ALL_CAPTUREOpens a new window

DBA_CAPTUREOpens a new window

N/A

ALL_CAPTURE_EXTRA_ATTRIBUTESOpens a new window

DBA_CAPTURE_EXTRA_ATTRIBUTESOpens a new window

N/A

ALL_CAPTURE_PARAMETERSOpens a new window

DBA_CAPTURE_PARAMETERSOpens a new window

N/A

ALL_CAPTURE_PREPARED_DATABASEOpens a new window

DBA_CAPTURE_PREPARED_DATABASEOpens a new window

N/A

ALL_CAPTURE_PREPARED_SCHEMASOpens a new window

DBA_CAPTURE_PREPARED_SCHEMASOpens a new window

N/A

ALL_CAPTURE_PREPARED_TABLESOpens a new window

DBA_CAPTURE_PREPARED_TABLESOpens a new window

N/A

N/A

DBA_COMPARISONOpens a new window

USER_COMPARISONOpens a new window

N/A

DBA_COMPARISON_COLUMNSOpens a new window

USER_COMPARISON_COLUMNSOpens a new window

N/A

DBA_COMPARISON_ROW_DIFOpens a new window

USER_COMPARISON_ROW_DIFOpens a new window

N/A

DBA_COMPARISON_SCANOpens a new window

USER_COMPARISON_SCANOpens a new window

N/A

DBA_COMPARISON_SCAN_VALUESOpens a new window

USER_COMPARISON_SCAN_VALUESOpens a new window

ALL_EVALUATION_CONTEXT_TABLESOpens a new window

DBA_EVALUATION_CONTEXT_TABLESOpens a new window

USER_EVALUATION_CONTEXT_TABLESOpens a new window

ALL_EVALUATION_CONTEXT_VARSOpens a new window

DBA_EVALUATION_CONTEXT_VARSOpens a new window

USER_EVALUATION_CONTEXT_VARSOpens a new window

ALL_EVALUATION_CONTEXTSOpens a new window

DBA_EVALUATION_CONTEXTSOpens a new window

USER_EVALUATION_CONTEXTSOpens a new window

ALL_FILE_GROUP_EXPORT_INFOOpens a new window

DBA_FILE_GROUP_EXPORT_INFOOpens a new window

USER_FILE_GROUP_EXPORT_INFOOpens a new window

ALL_FILE_GROUP_FILESOpens a new window

DBA_FILE_GROUP_FILESOpens a new window

USER_FILE_GROUP_FILESOpens a new window

ALL_FILE_GROUP_TABLESOpens a new window

DBA_FILE_GROUP_TABLESOpens a new window

USER_FILE_GROUP_TABLESOpens a new window

ALL_FILE_GROUP_TABLESPACESOpens a new window

DBA_FILE_GROUP_TABLESPACESOpens a new window

USER_FILE_GROUP_TABLESPACESOpens a new window

ALL_FILE_GROUP_VERSIONSOpens a new window

DBA_FILE_GROUP_VERSIONSOpens a new window

USER_FILE_GROUP_VERSIONSOpens a new window

ALL_FILE_GROUPSOpens a new window

DBA_FILE_GROUPSOpens a new window

USER_FILE_GROUPSOpens a new window

N/A

DBA_HIST_STREAMS_APPLY_SUMOpens a new window

N/A

N/A

DBA_HIST_STREAMS_CAPTUREOpens a new window

N/A

N/A

DBA_HIST_STREAMS_POOL_ADVICEOpens a new window

N/A

ALL_PROPAGATIONOpens a new window

DBA_PROPAGATIONOpens a new window

N/A

N/A

DBA_RECOVERABLE_SCRIPTOpens a new window

N/A

N/A

DBA_RECOVERABLE_SCRIPT_BLOCKSOpens a new window

N/A

N/A

DBA_RECOVERABLE_SCRIPT_ERRORSOpens a new window

N/A

N/A

DBA_RECOVERABLE_SCRIPT_HISTOpens a new window

N/A

N/A

DBA_RECOVERABLE_SCRIPT_PARAMOpens a new window

N/A

N/A

DBA_REGISTERED_ARCHIVED_LOGOpens a new window

N/A

ALL_RULE_SET_RULESOpens a new window

DBA_RULE_SET_RULESOpens a new window

USER_RULE_SET_RULESOpens a new window

ALL_RULE_SETSOpens a new window

DBA_RULE_SETSOpens a new window

USER_RULE_SETSOpens a new window

ALL_RULESOpens a new window

DBA_RULESOpens a new window

USER_RULESOpens a new window

N/A

DBA_STREAMS_ADD_COLUMNOpens a new window

N/A

N/A

DBA_STREAMS_ADMINISTRATOROpens a new window

N/A

ALL_STREAMS_COLUMNSOpens a new window

DBA_STREAMS_COLUMNSOpens a new window

N/A

N/A

DBA_STREAMS_DELETE_COLUMNOpens a new window

N/A

ALL_STREAMS_GLOBAL_RULESOpens a new window

DBA_STREAMS_GLOBAL_RULESOpens a new window

N/A

N/A

DBA_STREAMS_KEEP_COLUMNSOpens a new window

N/A

ALL_STREAMS_MESSAGE_CONSUMERSOpens a new window

DBA_STREAMS_MESSAGE_CONSUMERSOpens a new window

N/A

ALL_STREAMS_MESSAGE_RULESOpens a new window

DBA_STREAMS_MESSAGE_RULESOpens a new window

N/A

ALL_STREAMS_NEWLY_SUPPORTEDOpens a new window

DBA_STREAMS_NEWLY_SUPPORTEDOpens a new window

N/A

N/A

DBA_STREAMS_RENAME_COLUMNOpens a new window

N/A

N/A

DBA_STREAMS_RENAME_SCHEMAOpens a new window

N/A

N/A

DBA_STREAMS_RENAME_TABLEOpens a new window

N/A

ALL_STREAMS_RULESOpens a new window

DBA_STREAMS_RULESOpens a new window

N/A

ALL_STREAMS_SCHEMA_RULESOpens a new window

DBA_STREAMS_SCHEMA_RULESOpens a new window

N/A

N/A

DBA_STREAMS_SPLIT_MERGEOpens a new window

N/A

N/A

DBA_STREAMS_SPLIT_MERGE_HISTOpens a new window

N/A

N/A

DBA_STREAMS_STMT_HANDLERSOpens a new window

N/A

N/A

DBA_STREAMS_STMTSOpens a new window

N/A

ALL_STREAMS_TABLE_RULESOpens a new window

DBA_STREAMS_TABLE_RULESOpens a new window

N/A

N/A

DBA_STREAMS_TRANSFORMATIONSOpens a new window

N/A

ALL_STREAMS_TRANSFORM_FUNCTIONOpens a new window

DBA_STREAMS_TRANSFORM_FUNCTIONOpens a new window

N/A

N/A

DBA_STREAMS_TP_COMPONENTOpens a new window

N/A

N/A

DBA_STREAMS_TP_COMPONENT_LINKOpens a new window

N/A

N/A

DBA_STREAMS_TP_COMPONENT_STATOpens a new window

N/A

N/A

DBA_STREAMS_TP_DATABASEOpens a new window

N/A

N/A

DBA_STREAMS_TP_PATH_BOTTLENECKOpens a new window

N/A

N/A

DBA_STREAMS_TP_PATH_STATOpens a new window

N/A

ALL_STREAMS_UNSUPPORTEDOpens a new window

DBA_STREAMS_UNSUPPORTEDOpens a new window

N/A

ALL_SYNC_CAPTUREOpens a new window

DBA_SYNC_CAPTUREOpens a new window

N/A

ALL_SYNC_CAPTURE_PREPARED_TABSOpens a new window

DBA_SYNC_CAPTURE_PREPARED_TABSOpens a new window

N/A

N/A

DBA_SYNC_CAPTURE_TABLESOpens a new window

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.