In UNIX they are stored in the location $ORACLE_HOME/dbs and ORACLE_HOME/database for Windows directory.
Oracle by default starts with SPFILE located in $ORACLE_HOME/dbs.
If you want to start the database with particular file, we can append it at the startup command as
SQL > startup PFILE = ‘full path of parameter file ‘;
You can create PFILE from SPFILE'
SQL>create PFILE from SPFILE;
update parameter in PFILE then run the following command
SQL>Create SFILE from PFILE;
- DBWn process records modified buffers in Database Buffer Cache to data files so that user process can always find free buffers.
- To efficiently release the buffer cache to make it available to user processes, you can use multiple DBWn processes.
- We can configure new processes (DBW1 through DBW9 and DBWa through DBWj) to improve write performance if our system modifies data heavily.
- The initialization parameter DB_WRITER_PROCESSES specifies the number of DBWn processes up to a maximum number of 20.
- If the Unix system being used is fitted of asynchronous input/output processing, then only one DBWn process is enough if not the case the whole DBWn processes required will be twice the number of disks used by oracle, and this can be set with DB_WRITER_PROCESSES initialization parameter.
- Set up disk and make sure you have Installation file (run Installer) in your folder.
- Check the swap and TEMP space.
- Export the following environment variables
- Set up the kernel parameters and file maximum descriptors.
- Set up limt.conf parameters.
- Source the Environment file to the respective bash profile and now run Oracle Universal Installer.
This section covers Oracle DBA 11g interview questions and answers For Freshers. It helps job seekers who are about to attend Oracle DBA interview round.
This section covers Oracle DBA 11g interview questions and answers For Experienced. It helps job seekers who are about to attend Oracle DBA interview round.
Oracle 12C DBA Interview Questions and Answers