DBWR Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: DBWR Question

Hybrid View

  1. #1
    Join Date
    Mar 2010
    Posts
    35

    Red face 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

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Mar 2010
    Posts
    35
    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

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Mar 2010
    Posts
    35

    Post

    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
  •  


Click Here to Expand Forum to Full Width