Where is pfile located

This is because it has a header and footer that contains binary values. Also see this spfile example. This means you only have to change the parameter value in one place, and that you can forget having to change it in the PFILE of the database.

One of the most important benefits of the SPFILE is that Oracle has introduced many automatic tuning features into the core of the database. However, you can fully-qualify the path name is the? Warning - After an spfile is created, when you bounce the database you may encounter an error. The addition of the spfile has changed the search path for the Oracle startup deck. Oracle now uses the following path:. Remember that a PFILE is simply a text based file, which means you can copy it to another directory without affecting the Oracle instance.

You can do this with the following syntax. Or you can go to the pfile location and either cat or view the file. To change the pfile parameters you can directly edit the pfile using vi from the command line.

Some parameters you can save to memory, for use just within the current session; some you can save within the spfile; and some must be set at both. Parameters saved within the spfile can only be initiated following a database restart. If you want to startup a database using either a different spfile or using a pfile you first need to shut it down.

Then you should issue the following:. Katherine makes beautiful handmade greetings cards. Learn more. Asked 6 years, 8 months ago. Active 5 years, 3 months ago. Viewed 31k times. In what section is it stored? If separately, then where is it actually stored on the database?

Improve this question. Lalit Kumar B It's on disk. Add a comment. Active Oldest Votes. Improve this answer.