V$HS_AGENT displays the set of HS agents currently running on a given host. There is one row per agent process.
| Column | Datatype | Description |
|---|---|---|
AGENT_ID |
NUMBER |
Oracle Net session identifier used for connections to the agent (the identifier used in the LISTENER.ORA file) |
MACHINE |
VARCHAR2(64) |
Operating system machine name |
PROCESS |
VARCHAR2(9) |
Operating system process identifier of the agent |
PROGRAM |
VARCHAR2(48) |
Program name of the agent |
OSUSER |
VARCHAR2(30) |
Operating system user |
STARTTIME |
DATE |
Starting time |
AGENT_TYPE |
NUMBER |
Type of the agent |
FDS_CLASS_ID |
NUMBER |
ID of the Foreign Data Store class |
FDS_INST_ID |
NUMBER |
Instance name of the Foreign Data Store |