Managed SPFILE in Oracle

Managed SPFILE parameters in Oracle

SPFILE stands for Server Parameter file. It is in binary format.
You cannot modified this SPFILE with normal editor.
You can edit through commands ALTER or Create new file from pfile.

Default location of SPFILE:

UNIX or LINUX : $ORACLE_HOME/dbs
WINDOWS : %ORACLE_HOME%\database

Check the location of SPFILE

show parameter spfile

Check the parameter value which is able to modified

SELECT issys_modifiable from v$parameter;

Note:
DEFERRED: it is also dynamic but changes only affect at new session, already connected old session remains same
FALSE: its means parameter cannot change its value in lifetime of instance.
IMMEDIATE: It is dynamic and set to be change active instance as well as DB restart.

Change parameter of SPfile

ALTER SYSTEM SET = SCOPE= DEFERRED SID=;

Create SPFILE from PFILE

CREATE SPFILE FROM PFILE;
CREATE SPFILE= FROM PFILE=;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.