V$HS_PARAMETER

This view describes the initialization parameters in use by the server and agent.

Column	Datatype	Description
HS_SESSION_ID	NUMBER	Unique HS session identifier. This column maps to the HS_SESSION_ID column of V$HS_SESSION.
PARAMETER	VARCHAR2(30)	Name of the parameter
VALUE	VARCHAR2(64)	Value of the parameter
SOURCE	VARCHAR2(1)	Whether the parameter was defined in the agent (A) or server (S)
ENV	VARCHAR2(1)	Whether the parameter was also set as an environment variable in the agent or elsewhere (T | F)