You must specify SPFILE when changing the value of a static parameter that is described as not modifiable in Oracle Database Reference.īOTH indicates that the change is made in memory and in the server parameter file. The new setting takes effect when the database is next shut down and started up again. SPFILE indicates that the change is made in the server parameter file. If you started up the database using a parameter file (pfile), then this is the only scope you can specify. MEMORY MEMORY indicates that the change is made in memory, takes effect immediately, and persists until the database is shut down. If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify. If a server parameter file was used to start up the database, then BOTH is the default. The SCOPE of a parameter Scope depends on whether you started up the database using a client-side parameter file (pfile) or server parameter file (spfile). Oracle Database - Optimizer Goal (CBO/RBO).Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora).Oracle Database - WORK_AREA_SIZE_POLICY.Oracle Database - Environment Variables / Registry Values.Oracle Database - System Global Area - SGA (Shared Memory).Oracle Database - (Degree|Degree of Parallelism (DOP)).Changeable online and immediately reflected in all sessions.Changeable online, but only for future sessions.Oracle Database - (Initialization|System) Parameters
ORACLE EXPORT PARAMETER FILE TABLE LIST HOW TO
Oradb Example How To Detect Read From Temp.Methodology For Designing And Building The Materialized Views.Methodology For Defining The Analytic Workspace.
0 kommentar(er)
