GV$THREAD definition in Oracle 8i / www.oracledba.ru
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