|
-
Allen,
Pick the script from following location and see whats the hit/miss ratio for dc_* entries and modify parms that control those entries. We had the issue with too many extents/segments which causing too many misses, when we dropped all the unwanted tables dictionary hit ratio got better.
http://www.dbasupport.com/oracle/scr...ailed/26.shtml
Reddy,Sam
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
|