select apply#, server_id, save_time, apply_name, state, startup_time,
xid_usn, xid_slt, xid_sqn, cscn, depxid_usn, depxid_slt, depxid_sqn,
depcscn, msg_num, total_assigned, total_admin, total_rollbacks,
total_msg, last_apply_time, last_apply_msg_num, last_apply_msg_time,
elapsed_apply_time, commit_position, dep_commit_position,
last_apply_pos, flag, nosxid, depnosxid, max_inst_scn, total_waitdeps,
total_lcrs_retried, total_txns_retried, txn_retry_iter, lcr_retry_iter,
total_txns_discarded, flags_factoring,
spare1, spare2, spare3, spare4, spare5, spare6,
spare7, spare8, spare9, spare10, spare11, spare12, spare13, spare14,
spare15, spare16, spare17, spare18, spare19, spare20
from sys.apply$_server_stats
SELECT APPLY#
, SERVER_ID
, SAVE_TIME
, APPLY_NAME
, STATE
, STARTUP_TIME
,
XID_USN
, XID_SLT
, XID_SQN
, CSCN
, DEPXID_USN
, DEPXID_SLT
, DEPXID_SQN
,
DEPCSCN
, MSG_NUM
, TOTAL_ASSIGNED
, TOTAL_ADMIN
, TOTAL_ROLLBACKS
,
TOTAL_MSG
, LAST_APPLY_TIME
, LAST_APPLY_MSG_NUM
, LAST_APPLY_MSG_TIME
,
ELAPSED_APPLY_TIME
, COMMIT_POSITION
, DEP_COMMIT_POSITION
,
LAST_APPLY_POS
, FLAG
, NOSXID
, DEPNOSXID
, MAX_INST_SCN
, TOTAL_WAITDEPS
,
TOTAL_LCRS_RETRIED
, TOTAL_TXNS_RETRIED
, TXN_RETRY_ITER
, LCR_RETRY_ITER
,
TOTAL_TXNS_DISCARDED
, FLAGS_FACTORING
,
SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
,
SPARE7
, SPARE8
, SPARE9
, SPARE10
, SPARE11
, SPARE12
, SPARE13
, SPARE14
,
SPARE15
, SPARE16
, SPARE17
, SPARE18
, SPARE19
, SPARE20
FROM SYS.APPLY$_SERVER_STATS
|
|
|