DBA Data[Home] [Help]
Skip to content

VIEW: SYS.ALL_APPLY_SPILL_TXN

Source

View Text - Preformatted

select ast."APPLY_NAME",ast."XIDUSN",ast."XIDSLT",ast."XIDSQN",ast."FIRST_SCN",ast."MESSAGE_COUNT",ast."FIRST_MESSAGE_CREATE_TIME",ast."SPILL_CREATION_TIME",ast."FIRST_POSITION",ast."TRANSACTION_ID"
  from DBA_APPLY_SPILL_TXN ast, ALL_APPLY aa
  where aa.apply_name = ast.apply_name
View Text - HTML Formatted

SELECT AST."APPLY_NAME"
, AST."XIDUSN"
, AST."XIDSLT"
, AST."XIDSQN"
, AST."FIRST_SCN"
, AST."MESSAGE_COUNT"
, AST."FIRST_MESSAGE_CREATE_TIME"
, AST."SPILL_CREATION_TIME"
, AST."FIRST_POSITION"
, AST."TRANSACTION_ID"
FROM DBA_APPLY_SPILL_TXN AST
, ALL_APPLY AA
WHERE AA.APPLY_NAME = AST.APPLY_NAME