Oracle USERENV function

Preamble

Oracle/PLSQL USERENV function is used to get information about the current Oracle session. Although this function still exists in Oracle for backward compatibility, it is recommended to use the sys_context function instead.

Oracle/PLSQL function syntax USERENV

USERENV( parameter_id )

Parameters or arguments

• parameter_id – value returned from the current Oracle session.

Possible values:

The USERENV function can be used in the following versions of Oracle/PLSQL

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Let’s consider some examples of Oracle USERENV function and learn how to use USERENV function in Oracle PLSQL.

SELECT USERENV('LANGUAGE')
FROM DUAL;

--Result: RUSSIAN_CIS.CL8MSWIN1251

SELECT USERENV('ISDBA')
FROM DUAL;

--Result: FALSE

SELECT USERENV('SESSIONID')
FROM DUAL;

--Result: 661480038

SELECT USERENV('LANG')
FROM DUAL;

--Result: RU

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​