Determine the Open Heterogeneous Services Sessions: V$HS_SESSION View

The V$HS_SESSION view shows the sessions for each agent and specifies the database link that is used. Table 4-3 shows the most relevant columns. For a description of all the columns in the view, see Oracle Database Reference.

Table 4-3 Important Columns in the V$HS_SESSION View

Column	Description
`HS_SESSION_ID`	Unique Heterogeneous Services session identifier
`AGENT_ID`	Oracle Net session identifier used for connections to agent (`listener.ora SID`)
`DB_LINK`	Server database link name used to access the agent `NULL` means that no database link is used (for example, when using external procedures)
`DB_LINK_OWNER`	Owner of the database link in `DB_LINK`