P-FILE SPFILE
1)It is called as parameter
file. 1)It is called as server parameter file.
2)location:- cd
$ORACLE_HOME/dbs 2)cd $ORACLE_HOME/dbs
3)p-file is ASCII
file. 3)spfile
is binary file.
4)we can change the parameters by opening p-file. 4)we cannot
change the parameters by opening
spfile.
oracle providing 2 options to change the parameters of spfile
1)alter
system
2)alter
session
alter system set resource_limit=true scope=_________;
1)BOTH=changes
will be applied for current instance and future instance;
2)MEMORY=changes
will be applied only for current instance;
3)SPFILE=changes
will be applied after restart the database.
How to create the spfile?
1)first check spfile exists are not?
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> create spfile from pfile;
File created.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> startup force
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2211928 bytes
Variable Size 159387560 bytes
Database Buffers 50331648 bytes
Redo Buffers 5226496 bytes
Database mounted.
Database opened.
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/11.2.0
/dbs/spfilesubbu.ora
No comments:
Post a Comment