SELECT
  sid,                                     -- SID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  state,                                   -- STATE VARCHAR2(9)
  crmode,                                  -- CRMODE VARCHAR2(7)
  scope,                                   -- SCOPE VARCHAR2(7)
  nc_component,                            -- NC_COMPONENT VARCHAR2(40)
  nc_reason,                               -- NC_REASON NUMBER
  options,                                 -- OPTIONS NUMBER
  timeout                                  -- TIMEOUT NUMBER
FROM
  gv$sscr_sessions
WHERE
  inst_id = USERENV('Instance')