|
INSTANCE The instance identification number of the current instance.
IP_ADDRESS IP address of the machine from which the client is connected.
ISDBA TRUE if you are logged on as SYS.
LANG The ISO abbreviation for the language name, a shorter form than the existing 'LANGUAGE' parameter.
LANGUAGE The language and territory currently used by your session, along with the database character set, in the form:language_territory.characterset.
NETWORK_PROTOCOL Network protocol being used for communication, as specified in the 'PROTOCOL=protocol' portion of the connect string.
NLS_CALENDAR The current calendar of the current session.
NLS_CURRENCY The currency of the current session.
NLS_DATE_FORMAT The date format for the session.
NLS_DATE_LANGUAGE The language used for expressing dates.
NLS_SORT BINARY or the linguistic sort basis.
NLS_TERRITORY The territory of the current session.
OS_USER Operating system username of the client process that initiated the database session.
PROXY_USER Name of the database user who opened the current session on behalf of SESSION_USER.
PROXY_USERID Identifier of the database user who opened the current session on behalf of SESSION_USER.
SESSION_USER Database user name by which the current user is authenticated. This value remains the same throughout the duration of the session.
SESSION_USERID Identifier of the database user name by which the current user is authenticated.
SESSIONID The auditing session identifier. You cannot use this option in distributed SQL statements.
TERMINAL The operating system identifier for the client of the current session. In distributed SQL statements, this option returns the identifier for your local session. In a distributed environment, this is supported only for remote SELECT statements, not for remote INSERT, UPDATE, or DELETE operations. |