How to View and Set Database Parameters both Dynamic and Static
(Doc ID 1480291.1)
Last updated on DECEMBER 25, 2019
Applies to:Oracle Database - Standard Edition - Version 22.214.171.124 to 126.96.36.199 [Release 9.2 to 12.1]
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 9.2 to 12.1]
Oracle Database - Personal Edition - Version 220.127.116.11 to 18.104.22.168 [Release 9.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jul-2017***
There are two kinds of initialization parameters:
· Dynamic initialization parameters can be changed for the current Oracle Database instance. The changes take effect immediately.
· Static initialization parameters cannot be changed for the current instance. You must change these parameters in the text initialization file or server parameter file and then restart the database before changes take effect.
There are also two varieties of parameters:
1. Underscore parameters which are not documented in the oracle documentation set. These should not be changed unless directed to do so by oracle or unless suggested in an approved oracle publication.
2. Documented parameters which are listed in the Oracle References Manual. These may be used to tune different aspects of database configuration or performance.
This document will focus only on the published parameters.
Please refer to
This document is being written to provide concise information to database administrators and other interested database users on how to view current database parameter values, determine if a parameter is dynamic or static, set new values for database parameters and unset changes to database parameters.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|TO VIEW CURRENT PARAMETER SETTINGS:|
|TO DETERMINE IF THE PARAMETER IS DYNAMIC OR STATIC:|
|TO CHANGE A DATABASE PARAMETER:|