Diff between pfile and spfile dispatchers

By default, if you do not specify pfile in your startup command, oracle will use server parameter file spfile. Then recreate the server parameter file using the create spfile statement. It is also possible that a different set of shared servers are utilized for a given user session. A pfile is a static, client side text file that must be updated with a standard text editor like notepad or vi. To enable a shared server configuration, set the dispatchers parameter. An spfile cannot be edited directly, but one can be configured via the pfile init.

Understand what options you have for oracle instances parameter file. Pfile and spfile posted by itsiti december 23, 2010 in oracle leave a reply pfile is a static, clientside text file that must be updated with a standard text editor like notepad or vi. Pfile is a text file, which can be modified and spfile is a binary file which cannot be modified using a text editor. As a dba the main thing you need to worry about with the spfile and pfiles are backing them up. By default, the preconfigured database uses a parameter file spfile named spfilesid. If the query returns any value with a filenamewith its path then spfile is used by current running instance. Parameter file is a text or binary to store the database initialization parameters. Spfile permits dynamic changes without requiring you to restart that instance. An spfile uses the same formatting for its file name as the pfile, except the word spfile replaces init. This is because the communication protocols between oracle and the.

In the past the cpu load would spike and log file sync commit waits would. Managing initialization parameters using a server parameter file. This is achieved with the help of a dispatcher process, which places each process in a single request. Sql show parameter spfile if the query returns no rows pfile is used. The oracle instance reads the parameter file during startup which are then used. Spfile is a binary file that contains the same information as the. Create pfile from spfile, create pfile from spfile. Spfile is a binary file and modications to that can only be done through alter system set command. Oracle database initializationserver parameter file init. The dispatchers act as the coordinating agents between the user sessions. You can configure some parameters to have different values for one or more instances. Difference between pfileand spfile in oracle 10g11g.

Some entries found in a collection of spfiles from different applications and clients. Hi folks, greetings i am professional part time oracle dba trainer and having good experience in oracle database administration. Java project tutorial make login and register form step by step using netbeans and mysql database duration. A spfile doesnot need a local copy of the pfile to start oracle from a remote machine. What is the difference between spfile and pfile in oracle. The oracle instance reads the parameter file during startup which are then used to control the behavior of database instance and many other aspects as well. Spfile is a binary file that contains the same information as the old pfile. Oracle dba interview questions and answers oracle admin. It is a text file which contains all the main parameters for the database startup. This file normally reside on the server, however, you need a local copy if you want to start oracle from a remote machine. In oracle9i, a new feature called spfile server parameter file was introduced. What is difference between pfile and spfile answers. Parameter management in real application clusters environments.