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')