After the Oracle database is started, you can view all the parameters used by the Oracle database by using the select * from V$parameter statement .
For Oracle 's parameter files, it is divided into spfile binaries and pfile text files, and now the database is generally used The SPFile binary file is used as The parameter file to start Oracle. For The difference between spfile and pfile :
1 SPFile is a binary file (which can be viewed in binary file via string Spfileorcl.ora ) and cannot be modified with a text editor, only in sqlplus The parameters are modified dynamically using the command. For pfile is a text file, can be modified directly using a text editor, after restarting the database to take effect
2 SPFile must be stored on the server side, generally under the $ORACLE _home/dbs directory, for pfile can be stored on the client, can be through the client's pfile starting the database
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 If starting the database start does not specify a parameter file (if the Sid is orcl), the $ORACLE _home/dbs directory to find the parameter file Spfileorcl.ora>initorcl.ora
5 We can specify the parameter file to start the database ( here only through the pfile file, cannot be spfile file )
Startup pfile= '/u01/app/oracle/dbs/init.ora '(using pfile file)
6 for parameters that are not specified in the parameter file, the default value of the relevant parameter is taken
ORACLE Parameter File Introduction