Determine Which Agents Are Running on a Host: V$HS_AGENT View

The V$HS_AGENT view identifies the set of Heterogeneous Services agents currently operating on a specified host. Table 4-2 shows the most relevant columns. For a description of all the columns in the view, see Oracle Database Reference.

Table 4-2 Important Columns in the V$HS_AGENT View

Column	Description
`AGENT_ID`	Oracle Net session identifier used for connections to agent (`listener.ora SID`)
`MACHINE`	Operating system machine name
`PROGRAM`	Program name of agent
`AGENT_TYPE`	Type of agent
`FDS_CLASS_ID`	The ID of the foreign data store class
`FDS_INST_ID`	The instance name of the foreign data store