As per the huge transaction of database we can assign more dbwr to write. am i correct, if yes how to configure via init.ora
In my init.ora there is no line for configure this db_writer_process, manually i have type this parameter and startup my db with this parameter. but there is no reaction. if the parameter reflect then the database should show the dbwr name is in it ??
i have given in my parameter db_writer_processes=5
1) first i shutdown the database
2) i edited the parameter in pfile(init.ora)
3) i started the database with the pfile
startup mount pfile="location of the pfile";
alter database open;
thats it,, now i wanted to know how to check is the above db started with the pfile ?
if it is stated it should show those parameters i edited , but no change in this !!!
Can u just tell me how to increase the DBWR process .
and explain me when we need this ,, in multiple CUP's or where,, please explain me clearly..