v$current_bucket in 8i for adding buffers?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: v$current_bucket in 8i for adding buffers?

Hybrid View

  1. #1
    Join Date
    Nov 2001

    I am wondering if there is any view in 8i similar to
    v$current_bucket in 8 that I can use to check the impact for adding or remove buffers?



  2. #2
    Join Date
    Feb 2001
    Since the LRU alogrithim for buffers in 8i has changed , this view no longer exists and the
    init.ora parameters (something lru_extended_statistics etc) are no longer valid.
    Instead you have

    _db_percent_hot_default = 50
    _db_percent_hot_keep = 0
    _db_percent_hot_recycle = 0
    _db_aging_hot_criteria = 2
    _db_aging_stay_count = 0
    _db_aging_cool_count = 1
    _db_aging_touch_time = 3
    _db_aging_freeze_cr = FALSE

    And depedning upon the query results of x$bh , u decide the objects good for recycle,and keep buffer pool.

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