DBWR Question

[4iappsDBA]

Dear All,

I am back again with small Questions.

Here is my Question ?

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

no refelection..
kindly some one answer me

Regards
HAMEED

[vnktummala]

are sure database is started using the pfile you modified? How are you checking whether the specified dbwr processes are started?

Thanks,

[4iappsDBA]

Dear Brother,

very nice to meet u again,,

what i did is,,

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..

Thanks in Advance.
HAMEED

[vnktummala]

Hi Hameed,

now i wanted to know how to check is the above db started with the pfile ?

show parameter pfile

this will tell you whether database is opened with pfile or spfile

If you are on UNIX then you can check the number of dbwr processes started using the below command.

ps -ef|grep ora_dbw

If you are on Windows ..

select * from v$bgprocess where name like 'DBW%' and PSERIAL# <> 0

As par Oracle documentation, you can set value as 1 (default) or CPU_COUNT / 8 whichever is grater.

Please click here to read dbwr tuning tips from Burlison.

Thanks,

[4iappsDBA]

thank u very much,,

its useful


Regards
HAMEED