Hotsos Home Page

Document Properties

Title: Why You Should Focus on LIOs Instead of PIOs
Author: Cary Millsap
Get File:
Abstract: Many Oracle educators teach that reducing the number of PIO calls should be the top priority of SQL optimization. However, in our field work, we commonly eliminate 50% or more of the response time from slow Oracle applications, even after they’ve been tuned to execute no PIO calls. The secret is that Oracle LIO calls are more expensive than many people understand.
Document type: article
Updated: Wed 15 Oct 2003 (12.0 years ago)
File size: 283,876 bytes
MD5 checksum: 5e828b6fe006d362d2648c949d02b505
File type: .pdf
Authentication: registered — Registered guest (free registration)