-
DBWR Question
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
-
are sure database is started using the pfile you modified? How are you checking whether the specified dbwr processes are started?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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
-
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.
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,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
thank u very much,,
its useful
Regards
HAMEED
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|