-
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
|