GV$THREAD
select inst_id, -- INST_ID NUMBER rtnum, -- THREAD# NUMBER decode -- STATUS VARCHAR2(6) (bitand (rtsta, 1), 1, 'OPEN', 'CLOSED'), decode -- ENABLED VARCHAR2(8) (bitand (rtsta, 6), 0, 'DISABLED', 2, 'PRIVATE', 6, 'PUBLIC', 'UNKNOWN'), rtnlf, -- GROUPS NUMBER rtsid, -- INSTANCE VARCHAR2(16) to_date -- OPEN_TIME DATE (rtots, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), rtcln, -- CURRENT_GROUP# NUMBER rtseq, -- SEQUENCE# NUMBER to_number (rtckp_scn), -- CHECKPOINT_CHANGE# NUMBER to_date -- CHECKPOINT_TIME DATE (rtckp_tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), to_number (rtenb), -- ENABLE_CHANGE# NUMBER to_date -- ENABLE_TIME DATE (rtets, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), to_number (rtdis), -- DISABLE_CHANGE# NUMBER to_date -- DISABLE_TIME DATE (rtdit, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') from x$kccrt where rtnlf!=0

home |  up  |  mailbox