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?
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.
Click Here to Expand Forum to Full Width