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