Parameters in the USERENV namespace.

Parameter	Description
AUDITED_CURSORID	Returns the cursor ID of the SQL that triggered the auditing.
AUTHENTICATION_DATA	Returns the data used to authenticate a login user.
AUTHENTICATION_TYPE	Returns the method used to authenticate a user. The return value can be DATABASE for database-authenticated accounts, OS for externally identified accounts, NETWORK for globally identified accounts, PROXY for OCI proxy authentication.
BG_JOB_ID	Returns the job ID if the session was created by a background process. Returns NULL if the session is a foreground session.
CLIENT_IDENTIFIER	Returns the client session identifier in the global context. It can be set with the DBMS_SESSION built-in package.
CLIENT_INFO	Returns the 64 bytes of user session information stored by DBMS_APPLICATION_INFO.
CURRENT_SCHEMA	Returns the current schema as set by ALTER SESSION SET CURRENT_SCHEMA or, by default the login schema /ID.
CURRENT_SCHEMAID	Returns the numeric ID for CURRENT_SCHEMA.
CURRENT_SQL	Returns the SQL that triggered Fine-Grained Auditing (use only within scope inside the event handler for Fine-Grained Auditing).
CURRENT_USER	Returns the current user name. This is the same functionality as the USER function.
CURRENT_USERID	Returns the numeric current user ID. This is the same functionality as the UID function.
DB_DOMAIN	Returns the contents of the DB_DOMAIN init.ora parameter.
DB_NAME	Returns the contents of the DB_NAME init.ora parameter.
ENTRYID	Returns the auditing entry identifier (only available if the init.ora parameter AUDIT_TRAIL is set to TRUE).
EXTERNAL_NAME	Returns the operating system name of the database user for local connection.
FG_JOB_ID	Returns the job ID of the current session if a foreground process created it. Returns NULL if the session is a background session.
GLOBAL_CONTEXT_MEMORY	Returns the number in the SGA by the globally access context.
HOST	Returns the hostname of the machine where the client connected from. This is not the same terminal in V$SESSION.
INSTANCE	Returns the instance number for the instance the session is connected to. This is always 1, unless you are running Oracle Parallel Server.
IP_ADDRESS	Return the IP address of the machine where the client connected from. If the session is not established vie TCP/IP and Net8, it return NULL.
ISDBA	Returns TRUE if the user connected as SYSDBA.
LANG	Returns the ISO abbreviation for the language name.
LANGUAGE	Returns a string containing the language and territory used by the session and the database character set in the form language_territory.character_set.
NETWORK_PROTOCOL	Returns the network protocol being used as specified in the PROTOCOL= section of the connect string or tnsnames.ora definition.
NLS_CALENDAR	Returns the calendar for the current session.
NLS_CURRENCY	Returns the currency for the current session.
NLS_DATE_FORMAT	Returns the date format for the current session.
NLS_SORT	Returns the binary or linguistic sort basis.
NLS_TERRITORY	Returns the territory for the current session.
OS_USER	Returns the operating system username for the current session.
PROXY_USER	Returns the name of the database user who opened the current session for the session user.
PROXY_USERID	Returns the numeric ID for the database user who opened the current session for the session user.
SESSION_USER	Returns the database username for the current session.
SESSION_USERID	Returns the numeric database user ID for the current session.
SESSIONID	Returns the auditing session identifier AUDSID. This parameter is out of scope for distributed queries.
TERMINAL	Returns the terminal identifier for the current session. This is the same as the terminal in V$SESSION.