tag:blogger.com,1999:blog-7401441800772359451.post6115845930080662067..comments2024-03-09T15:44:46.452+05:30Comments on Oracle help at your desk....:-): Checking Session Statistics Part -IIIVishwanath Sharmahttp://www.blogger.com/profile/16557631012523243477noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7401441800772359451.post-74308496277279260872011-08-25T00:16:26.135+05:302011-08-25T00:16:26.135+05:30Sometimes Oracle recommendations are old, outdated...Sometimes Oracle recommendations are old, outdated or wrong. This is one that has been shown to be meaningless or worse (leading people to do unnecessary work trying to fix a problem that isn't there). <br /><br />So, if someone uses this to adjust the buffer cache (as some older texts recommend), they are doing it wrong. The basic problem is, putting this into a ratio obscures all the information that would be useful to make such a decision. An additional problem is all the new features and changes to the way the buffering works, combined with concurrency issues, just wipes out any possible usefulness of this ratio.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7401441800772359451.post-66172006816639935682011-08-18T13:07:14.952+05:302011-08-18T13:07:14.952+05:30This is oracle recommendation actually.This is oracle recommendation actually.Vishwanath Sharmahttps://www.blogger.com/profile/16557631012523243477noreply@blogger.comtag:blogger.com,1999:blog-7401441800772359451.post-51950378360973732372011-08-18T05:38:34.247+05:302011-08-18T05:38:34.247+05:30Could you please explain where 90% came from, and ...Could you please explain where 90% came from, and how you've used this metric to fix something?Anonymousnoreply@blogger.com