Wednesday , July 26 2017
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

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

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