GV$STREAMS_APPLY_COORDINATOR
select inst_id, -- INST_ID NUMBER sid_knst, -- SID NUMBER serial_knst, -- SERIAL# NUMBER applynum_knstacr, -- APPLY# NUMBER applyname_knstacr, -- APPLY_NAME VARCHAR2(30) decode -- STATE VARCHAR2(21) (state_knstacr, 0, 'INITIALIZING', 1, 'APPLYING', 2, 'SHUTTING DOWN CLEANLY', 3, 'ABORTING', 4, 'IDLE'), total_applied_knstacr, -- TOTAL_APPLIED NUMBER total_waitdeps_knstacr, -- TOTAL_WAIT_DEPS NUMBER total_waitcommits_knstacr, -- TOTAL_WAIT_COMMITS NUMBER total_admin_knstacr, -- TOTAL_ADMIN NUMBER total_assigned_knstacr, -- TOTAL_ASSIGNED NUMBER total_received_knstacr, -- TOTAL_RECEIVED NUMBER total_ignored_knstacr, -- TOTAL_IGNORED NUMBER total_rollbacks_knstacr, -- TOTAL_ROLLBACKS NUMBER total_errors_knstacr, -- TOTAL_ERRORS NUMBER lwm_time_knstacr, -- LWM_TIME DATE lwm_msg_num_knstacr, -- LWM_MESSAGE_NUMBER NUMBER lwm_msg_time_knstacr, -- LWM_MESSAGE_CREATE_TIME DATE hwm_time_knstacr, -- HWM_TIME DATE hwm_msg_num_knstacr, -- HWM_MESSAGE_NUMBER NUMBER hwm_msg_time_knstacr, -- HWM_MESSAGE_CREATE_TIME DATE startup_time_knstacr, -- STARTUP_TIME DATE elapsed_schedule_time_knstacr, -- ELAPSED_SCHEDULE_TIME NUMBER elapsed_idle_time_knstacr -- ELAPSED_IDLE_TIME NUMBER from x$knstacr x where type_knst=1 and exists ( select 1 from v$session s where s.sid=x.sid_knst and s.serial#=x.serial_knst)

home |  up  |  mailbox