select apply_name, xidusn, xidslt, xidsqn, first_scn, message_count,
first_message_create_time, spill_creation_time, first_position,
transaction_id
from "_DBA_APPLY_SPILL_TXN"
where bitand(spill_flags, 4) = 0
SELECT APPLY_NAME
, XIDUSN
, XIDSLT
, XIDSQN
, FIRST_SCN
, MESSAGE_COUNT
,
FIRST_MESSAGE_CREATE_TIME
, SPILL_CREATION_TIME
, FIRST_POSITION
,
TRANSACTION_ID
FROM "_DBA_APPLY_SPILL_TXN"
WHERE BITAND(SPILL_FLAGS
, 4) = 0
|
|
|