Hi,
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?
Thanks
James
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
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks