Some Qns on Tuning - Urgent
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: Some Qns on Tuning - Urgent

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    I have a question regards to some Tuning.
    Basically we have sun 450 server with 2 processes.
    We want to do some appln/system tuning
    how do i increase db_writer_processes from 1 to 2(what is the max)
    how do i increase the log_writer processes (aswell) what is the parameter.. i could not find in show parameters log.
    similarly what are all the views involved for this kind of query or situation.

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You can change the number of db writers by changing the db_writer_processes parameter. Keep in mind, you must also change the db_block_lru_latches at the same time.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    how do you change the same. Alter session, system ?? How ??

    secondly, how about log_writer_process ??

    as well could you also give me what are the views available for the same??

    Thanks for the reply Marist89

  4. #4
    Join Date
    Oct 2000
    Posts
    449
    also should we bounce the database.. after we do this..

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The range for the db_writer_processes = 1-10

    You have to set the number of processes that you want to be started, in the init<SID>.ora file that could be found under the $ORACLE_BASE/admin/<sid>/pfile

    I'm not aware of whether there is a way to increase the log_writer processes. I beleive that it was an dynamic parameter whose number gets decided by oracle. If your system is in the archive mode then, you could set a max limit on the archiver processes.

    V$sgastat
    V$bgprocess
    v$process
    v$thread

    and there are others which are inter-dependent on others.

    Sam

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes you have to bounce after the changes.
    Sam

  7. #7
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking rember


    you need to add these changes in your init.ora file, if you change them dynamically (alter session/system) and then bounce the DB you will not have your changes there. Once you change your init.ora parameter file, then bounce the DB and yer all set.

    - Magnus

  8. #8
    Join Date
    Oct 2000
    Posts
    449
    Thanks for all the replies guys. But looks like everyone ignored the command for the changes..

  9. #9
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    what command do you need.

    To perform the changes go to the initSID.ora file add the

    db_writer_process = 2

    save that file

    come to the prompt,

    $> svrmgrl

    SVRMGRL> connect internal <----- make sure that
    your ORACLE_SID=
    is set in your enviromnet


    SVRMGRL> shutdown immediate
    SVRMGRL> startup

    _______________________________________________

    This should put the changes in place.

    Sam


  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There is no command to make these changes on-the-fly.

    You must change your init.ora parameter and then bounce the database (shutdown/startup) in order for the changes to take effect.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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