select apply#, save_time, apply_name, state, total_applied, total_waitdeps,
total_waitcommits, total_admin, total_assigned, total_received,
total_ignored, total_rollbacks, total_errors, unassigned_eager,
unassigned_complete, auto_txnbufsize, startup_time, lwm_time,
lwm_msg_num, lwm_msg_time, hwm_time, hwm_msg_num, hwm_msg_time,
elapsed_schedule_time, elapsed_idle_time, lwm_position, hwm_position,
processed_msg_num, flag, flags_factoring, replname,
spare1, spare2, spare3, spare4, spare5, spare6,
spare7, spare8, spare9, spare10, spare11, spare12, spare13, spare14,
spare15, spare16, spare17, spare18, spare19, spare20
from sys.apply$_coordinator_stats
SELECT APPLY#
, SAVE_TIME
, APPLY_NAME
, STATE
, TOTAL_APPLIED
, TOTAL_WAITDEPS
,
TOTAL_WAITCOMMITS
, TOTAL_ADMIN
, TOTAL_ASSIGNED
, TOTAL_RECEIVED
,
TOTAL_IGNORED
, TOTAL_ROLLBACKS
, TOTAL_ERRORS
, UNASSIGNED_EAGER
,
UNASSIGNED_COMPLETE
, AUTO_TXNBUFSIZE
, STARTUP_TIME
, LWM_TIME
,
LWM_MSG_NUM
, LWM_MSG_TIME
, HWM_TIME
, HWM_MSG_NUM
, HWM_MSG_TIME
,
ELAPSED_SCHEDULE_TIME
, ELAPSED_IDLE_TIME
, LWM_POSITION
, HWM_POSITION
,
PROCESSED_MSG_NUM
, FLAG
, FLAGS_FACTORING
, REPLNAME
,
SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
,
SPARE7
, SPARE8
, SPARE9
, SPARE10
, SPARE11
, SPARE12
, SPARE13
, SPARE14
,
SPARE15
, SPARE16
, SPARE17
, SPARE18
, SPARE19
, SPARE20
FROM SYS.APPLY$_COORDINATOR_STATS
|
|
|