VIEW: SYS.GV_$SSCR_SESSIONS

Source

View Text - Preformatted

select "INST_ID","SID","SERIAL#","STATE","CRMODE","SCOPE","NC_COMPONENT","NC_REASON","OPTIONS","TIMEOUT","CON_ID" from gv$sscr_sessions

View Text - HTML Formatted

SELECT "INST_ID"
, "SID"
, "SERIAL#"
, "STATE"
, "CRMODE"
, "SCOPE"
, "NC_COMPONENT"
, "NC_REASON"
, "OPTIONS"
, "TIMEOUT"
, "CON_ID"
FROM GV$SSCR_SESSIONS