GV$LOGMNR_CALLBACK

select
inst_id,                 -- INST_ID NUMBER
decode                   -- STATE VARCHAR2(8)
  (state, 0, 'ENABLED', 1, 'DISABLED', 'UNKNOWN'),
decode                   -- TYPE VARCHAR2(19)
  (type, 0, 'EVERY_CHANGE_RECORD', 1, 'ON_COMMIT', 2, 'ON_DDL', 3, 'ON_SPECIAL_MARKER', 'UNKNOWN'),
decode                   -- CAPABILITY VARCHAR2(8)
  (capability, 0, 'ANYORDER', 1, 'INORDER', 'UNKNOWN') 
from
x$logmnr_callback
home |  up  |  mailbox