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 |