V$HS_SESSION definition in Oracle Database 11.2
V$HS_SESSION

select
  HS_SESSION_ID,                           -- HS_SESSION_ID NUMBER
  AGENT_ID,                                -- AGENT_ID NUMBER
  SID,                                     -- SID NUMBER
  DB_LINK,                                 -- DB_LINK VARCHAR2(128)
  DB_LINK_OWNER,                           -- DB_LINK_OWNER NUMBER
  STARTTIME                                -- STARTTIME DATE
from
  GV$HS_SESSION
where
  INST_ID = USERENV('Instance')

home |  up