DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: db_block_buffer??

  1. #1
    Join Date
    Nov 2006
    Posts
    23

    db_block_buffer??

    Hi my shared pool size 55000000
    db_block_buffer is 3200
    log_buffer 1024000
    db_block_size 2048
    RAM 512MB

    I want to increase db_block_buffer. How much should I increase so that I can get a good optimization or is there any way to calculate.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    totally dependant on your application

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    It also depends on how much free ram you have. But your db_block_buffer is at 6.4 megs. i.e. 2048*3200. Without doing the work you could easily size it to 25600, which would be 50 megs. A total SGA size of a little over 110 megs. You might also change shared pool to 80000000, which would change you SGA to a little over 125 megs

    I premise this on you having a small OLTP application running on Oracle 7.3.4. with a Windows NT 4.0 server.
    Of course I could be completely wrong.
    this space intentionally left blank

  4. #4
    Join Date
    Nov 2006
    Posts
    23
    Yes thats true but is there any way that how much should I increase db_block_buffer size and from there I should start the performance study for the applications how they are working.

  5. #5
    Join Date
    Nov 2006
    Posts
    23
    Yes its small OLTP application running on 7.3.4.4 with a windows NT server.Thanks a lot and I will try to do as you said and will let you know what happens..

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by alpesh
    Yes its small OLTP application running on 7.3.4.4 with a windows NT server.Thanks a lot and I will try to do as you said and will let you know what happens..
    Wow, am I good!!!!
    this space intentionally left blank

  7. #7
    Join Date
    Nov 2006
    Posts
    23
    You are!!

  8. #8
    Join Date
    Nov 2006
    Posts
    23
    I tried putting db_block_buffer size 25600, and sga size 80000000 but there was no chance in performance. Can anyone help me in this

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to track down what the cause it, do you have statspack? traced queries?

    why did you think increasing the sga would make it better

  10. #10
    Join Date
    Nov 2006
    Posts
    23
    I dont know about increasing SGA but increasing db_block_buffer would help me but I dont know how much to increase and start catching performance. In 7.3.4 there is not stats pack

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