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 (6.3 years ago) |
| File size: | 283,876 bytes |
| MD5 checksum: | 5e828b6fe006d362d2648c949d02b505 |
| File type: | |
| Authentication: | registered — Registered guest (free registration) |
