Oracle Database Paramater file

 

Oracle Database Paramater file

 

 

Paramter file :- Parameter file is the file which contains the intialiazation parameters and value associated with each parameter

 

Oracle has  two types of parameter files:

 

Initialization Parameter Files:-this parameter file is in text format which contains the initialization parameters of database.

 

Which contains entries like

                        sessions

                        processes

                        user_dump_dest location

background_dump_dest location

core_dump_dest location

db_cache_size

java_pool_size

control_files  (which contains the control file location)

etc.

 

Server Parameter File :- this is also a parametr file but this is in binary format which is unreadable .the main advantage of using this file for database startup is

                                    when you change any parameter of database then that paramter new value directly applicable to server parameter file while database running.

 

Note:

1. if you want to know which type of parameter file is currently in used for startup then you issue

 

SQL> Show  parameter spfile;

 

If value is present under VALUE column that means spfile (server parameter file is used in starting the database.if VALUE cloumn show no value then initalization parameter file is used.

 

2.      if spfile is currently in used and you want to create the initparameter file then issue

 

SQL> Create pfile from spfile;

OR

SQL> Create pfile=ADDRESS_OF_FILE From spfile;