V$HS_AGENT definition in Oracle Database 11.2
V$HS_AGENT

select
  unique AGENT_ID,                         -- AGENT_ID NUMBER
  MACHINE,                                 -- MACHINE VARCHAR2(64)
  PROCESS,                                 -- PROCESS VARCHAR2(9)
  PROGRAM,                                 -- PROGRAM VARCHAR2(48)
  OSUSER,                                  -- OSUSER VARCHAR2(30)
  STARTTIME,                               -- STARTTIME DATE
  AGENT_TYPE,                              -- AGENT_TYPE NUMBER
  FDS_CLASS_ID,                            -- FDS_CLASS_ID NUMBER
  FDS_INST_ID                              -- FDS_INST_ID NUMBER
from
  GV$HS_AGENT
where
  INST_ID = USERENV('Instance')

home |  up