Apply Servers:
select
'SID (streams_apply_server): ' || SID ||
chr(10) ||
'APPLY Name : ' ||
APPLY_NAME|| chr(10) ||
'Current State : ' || STATE ||
chr(10) ||
'Tot Trans Assgned : ' ||
TOTAL_ASSIGNED || chr(10) ||
'Tot Admin : ' ||
TOTAL_ADMIN || chr(10) ||
'TOT MSGs APPLIED : ' ||
TOTAL_MESSAGES_APPLIED||chr(10)||
'Time last msg applied : ' ||
to_char(APPLY_TIME,
'YYYY-MM-DD
HH24:MI') || chr(10) ||
'Last APPLIED_MSG_NUM : '
||APPLIED_MESSAGE_NUMBER ||chr(10)||
'CRTTime at SRC of Last APPL_MSG : ' ||
to_char(
APPLIED_MESSAGE_CREATE_TIME,'YYYY-MM-DD
HH24:MI') || chr(10) ||
'ELAPSED_DEQUEUE_TIME : '
||ELAPSED_DEQUEUE_TIME * 100 ||chr(10)||
'ELAPSED_APPLY_TIME : ' ||
ELAPSED_APPLY_TIME
FROM_STREAMS_APPLY_SERVER
from V$STREAMS_APPLY_SERVER
/
The following is the output:
FROM_STREAMS_APPLY_SERVER
---------------------------------------------------------------
SID (streams_apply_server): 32
APPLY Name : LN1_APPLY
