EXA_PARAMETERS

This system table provides the database parameters - both system-wide and session-based information is displayed. All users have access to the table.

To know the list of parameters and how to change them for the system or the current session, refer to the ALTER SESSION statement.

Column Name Description
PARAMETER_NAME Name of the parameter
SESSION_VALUE Value of the session parameter
SYSTEM_VALUE Value of the system parameter