Heterogeneous Services Dynamic Performance Views
You can use dynamic performance views to access information in the Oracle database server.
- Determining Which Agents Are Running on a Host: V$HS_AGENT View
TheV$HS_AGENT
view identifies the set of Heterogeneous Services agents currently operating on a specified host. - Determining the Open Heterogeneous Services Sessions: V$HS_SESSION View
TheV$HS_SESSION
view shows the sessions for each agent and specifies the database link that is used. - Determining the Heterogeneous Services Parameters: V$HS_PARAMETER View
TheV$HS_PARAMETER
view lists the Heterogeneous Services parameters and their values that are registered in the Oracle database server.
Parent topic: Using Heterogeneous Services Agents
Determining 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-5 shows the most relevant columns.
Table 4-5 Important Columns in the V$HS_AGENT View
Column | Description |
---|---|
|
Oracle Net session identifier used for connections to agent ( |
|
Operating system machine name |
|
Program name of agent |
|
Type of agent |
|
The ID of the foreign data store class |
|
The instance name of the foreign data store |
See Also:
Oracle Database Reference for a description of all the columns in the view.
Parent topic: Heterogeneous Services Dynamic Performance Views
Determining 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-6 shows the most relevant columns.
Table 4-6 Important Columns in the V$HS_SESSION View
Column | Description |
---|---|
|
Unique Heterogeneous Services session identifier |
|
Oracle Net session identifier used for connections to agent ( |
|
Server database link name used to access the agent |
|
Owner of the database link in |
See Also:
Oracle Database Reference for a description of all the columns in the view.
Parent topic: Heterogeneous Services Dynamic Performance Views
Determining the Heterogeneous Services Parameters: V$HS_PARAMETER View
The V$HS_PARAMETER
view lists the Heterogeneous Services parameters and their values that are registered in the Oracle database server.
Table 4-7 shows the most relevant columns.
Table 4-7 Important Columns in the V$HS_PARAMETER View
Column | Description |
---|---|
|
Unique Heterogeneous Services session identifier |
|
The name of the Heterogeneous Services parameter |
|
The value of the Heterogeneous Services parameter |
Information about the database link that was used for establishing the distributed connection, the startup time, and the set of initialization parameters used for the session is also available. All of the runtime information is derived from dynamically updated tables.
See Also:
Oracle Database Reference for a description of all the columns in the view.
Parent topic: Heterogeneous Services Dynamic Performance Views