This white paper describes the chronic problem of performing excessive logical I/O and its impact on system performance. It describes the pain that applications can inflict on the system, in the form of contention for the cache buffers lru chain latch and the cache buffers chains latch, when repeatedly performing large amounts of logical I/O, across many user sessions. The author also provides data that suggests that the performance difference between logical I/O and physical I/O is one order of magnitude at best and not three orders of magnitude. Oracle tuning efforts need to be based on isolating and pinpointing bottlenecks not cache-hit ratios. The mission of this paper is to dispel any misconceptions that correlate Oracle database performance with cache-hit ratios. It also provides a methodology that guarantees repeated success in unearthing the actual source of performance problems.
Did you find this white paper useful?
3 out of 6 users found this white paper useful
Related white papers
Green IT: Reducing your Carbon Footprint with Citrix
Going green has become an imperative, not an option, for companies facing the new reality of balancing business objectives with dwindling environmental resources. Limited energy supply and skyrocketing costs are...
Protecting virtual macchines: the "best of Vmworld" approach
By enabling IT managers to move virtual machines (and the applications they host) between physical servers, server virtualization gives them a powerful method for reducing planned downtime and speeding recovery....
Security Beyond Corporate Boundaries: Using Citrix Application Delivery to Protect Corporate Information Anywhere Business Happens
Ironclad security has become the Holy Grail for companies looking to protect corporate and customer information at large in the modern enterprise. The move toward greater data distribution -- thanks...
The End of Application Deployment: Virtualised Applications Streamline, Secure and Manage Your Business
Hundreds, even thousands, of applications serve as the life blood of each of today's distributed global enterprises - at use in more places and in more ways than ever before....
Accelerating Microsoft Windows Vista Migrations with Citrix XenApp
For many organisations, migration to Microsoft Windows Vista is not a question of "if" but "when." This inevitability is causing companies to start asking the difficult questions. This white paper...
IBM Information Server Change Data Capture
In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily,...
Live Webcast: Dell EqualLogic PS Series Demonstration for SQL Server Protection and Rapid Recovery
Join Dell EqualLogic for a demonstration of the PS Series with Smart Copy functionality, designed to deliver comprehensive SQL Server database protection, rapid recovery and high availability. Choose from these upcoming...
