Description of ORACLE Reference file

After the ORACLE database is started. This statement enables you to see all the parameters used by the Oracle database using the SELECT * from V$parameter .

For Oracle 's parameter files, it is divided into spfile binaries and pfile text files. Today's databases generally use the spfile binary as The reference file to start Oracle. For The difference between spfile and pfile :

1 SPFile is a binary file (capable of binary file viewing via string Spfileorcl.ora) and cannot be changed with a text editor. You can only use commands to dynamically change the parameters in Sqlplus. For pfile is a text file. Ability to change directly with a text editor and take effect after restarting the database

2 SPFile must be stored on the server side, usually below the $ORACLE _home/dbs folder, and for pfile is able to be stored in the client. Ability to start the database through the pfile of the client

3 SPFile and pfile can be dynamically converted under SQL commands (whether or not a DB instance is nearly started)

creating SPFile Create pfile='/u01/app/oracle/dbs/spfileorcl.ora ' from pfile= '/u01/app/through pfile Oracle/dbs/initorcl.ora ' ( or use create SPFile from Pfile)

4 assume that starting the database start does not specify a parameter file (assuming the Sid is orcl), the $ORACLE _home/dbs folder, look for the parameter file Spfileorcl.ora>initorcl.ora

5 We can specify the parameter file to start the database ( only through the pfile file, not spfile file )

Startup pfile= '/u01/app/oracle/dbs/init.ora '(using pfile file)

6 The number of parameters that are not specified in the reference file is the default value of the relevant parameters.

Description of ORACLE Reference file