DBA Data[Home] [Help]

VIEW: SYS.CDB_HIST_STREAMS_APPLY_SUM

Source

View Text - Preformatted

SELECT "SNAP_ID","DBID","INSTANCE_NUMBER","APPLY_NAME","STARTUP_TIME","READER_TOTAL_MESSAGES_DEQUEUED","READER_LAG","COORD_TOTAL_RECEIVED","COORD_TOTAL_APPLIED","COORD_TOTAL_ROLLBACKS","COORD_TOTAL_WAIT_DEPS","COORD_TOTAL_WAIT_CMTS","COORD_LWM_LAG","SERVER_TOTAL_MESSAGES_APPLIED","SERVER_ELAPSED_DEQUEUE_TIME","SERVER_ELAPSED_APPLY_TIME","CON_DBID","CON_ID" FROM CONTAINERS("SYS"."DBA_HIST_STREAMS_APPLY_SUM")
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "APPLY_NAME"
, "STARTUP_TIME"
, "READER_TOTAL_MESSAGES_DEQUEUED"
, "READER_LAG"
, "COORD_TOTAL_RECEIVED"
, "COORD_TOTAL_APPLIED"
, "COORD_TOTAL_ROLLBACKS"
, "COORD_TOTAL_WAIT_DEPS"
, "COORD_TOTAL_WAIT_CMTS"
, "COORD_LWM_LAG"
, "SERVER_TOTAL_MESSAGES_APPLIED"
, "SERVER_ELAPSED_DEQUEUE_TIME"
, "SERVER_ELAPSED_APPLY_TIME"
, "CON_DBID"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_HIST_STREAMS_APPLY_SUM")