GV$HS_PARAMETER definition in Oracle Database 11.2
GV$HS_PARAMETER

select
  A.INST_ID,                               -- INST_ID NUMBER
  HS_SESSION_ID,                           -- HS_SESSION_ID NUMBER
  PARAMETER,                               -- PARAMETER VARCHAR2(30)
  VALUE,                                   -- VALUE VARCHAR2(64)
  SOURCE,                                  -- SOURCE VARCHAR2(1)
  ENV                                      -- ENV VARCHAR2(1)
from
  X$HS_SESSION A,
  X$HOFP B
WHERE
  A.FDS_INST_ID = B.FDS_INST_ID

home |  up