SELECT
  INDX,                                    -- INDX NUMBER
  PG_NAME,                                 -- PG_NAME VARCHAR2(30)
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  PID                                      -- PID NUMBER
FROM
  gv$detached_session
WHERE
  INST_ID = USERENV('INSTANCE')