DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sga

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    when decide the size of buffer_pool_keep, do i need to consider the grow of table? otherwise if some table grow beyond the size of buffer_pool_keep, i must restart the database. right?

    and how do i know how many space in buffer_pool_keep is already occupied?

    what happen is buffer_pool_keep is not big enough?

    [Edited by bxr556 on 05-18-2001 at 02:29 PM]

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Normally, you should try to store the samll tables in the buffer_pool_keep area. The size of your buffer_pool_keep would matter when you would want to do the query. You would end up with high miss rate if you ever try to use the buffer pool keep of which it cannot accomodate.

    Yes if you are to change the parameter you have to bounce your instance. But be aware that you would be scavenging part of the buffer_cache for this and you wouldn't be allocating entirely new set. As a result when you bump this parameter, you would also have to bump the db_buffers also to accomotade the amount that you are about to scavenge for buffer_pool_keep.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    BTW, you can use the v$buffer_pool_statistics to view the performance.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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