Home / Oracle DBA / PARAMETER FILE

PARAMETER FILE

PARAMETER FILE

  1. This file contains parameters that will define the characteristics of database.
  1. It will be in the form of init<SID>.ora [SID – instance name] and resides in ORACLE_HOME/dbs (on unix) and ORACLE_HOME/database (on windows)
  1. Parameters are divided into two types
    1. Static parameters – the value for these parameters cannot be changed when the database is up and running
    2. Dynamic parameters – the value for these parameters can be changed even when DB is up and running
  1. Difference between static and dynamic parameters can be known from IS_ SESMODIFIABLE and IS_ SYSMODIFIABLE columns of v$parameter view.
Note: Instance name can be different from database name. This is to provide security
SERVER PARAMETER FILE (SPFILE)
  1. This file is binary copy of pfile which provides different scopes in changing parameter values
    1. Scope=spfile -> changes the values from next startup
    2. Scope=memory -> changes the values immediately (values will revert from next startup)
    3. Scope=both -> changes the values immediately and also made permanent in next startup
  1. Spfile will be in the form of spfile<SID>.ora and resides in ORACLE_HOME/dbs (on unix) and ORACLE_HOME/database (on windows)
  1. We can create spfile from pfile or pfile from spfile using below commands
    1. SQL> create spfile from pfile;
    2. SQL> create pfile from spfile;
  1. Order of precedence for database startup
Spfile<SID>.orainit<SID>.ora
SPFILE
Read More:
LOGICAL STRUCTURES OF DATABASE
PHASES OF SQL EXECUTION
OPERATING SYSTEM FUNCTIONALITY THEORY
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe