Hotsos Home Page

Document Properties

Title: Oracle Operational Timing Data
Author: Cary Millsap
Get File:
Abstract: The most important statistics for the Oracle performance analyst are the Oracle kernel's timing statistics. Yet, an amazing number of misunderstandings about Oracle timing statistics prevail in the market today. As a result, analysts can fail to see potential performance improvements that are right under their noses!
This paper explains how the Oracle kernel measures and reports its own timings. It explores some of the ironies of digital clocks that might have diminished your confidence in Oracle's timings. It explains how to get past these ironies to prove more assertions about Oracle performance than you can today. Finally, it discusses why the V$ data that you probably trust today can easily lead you down a rat-hole. The result is an ability to improve system performance beyond the levels at which you might be stuck today.
Document type: article
Updated: Wed 15 Oct 2003 (12.0 years ago)
File size: 276,870 bytes
MD5 checksum: 8c4b64eb1c68edf201c9e4a2f30162f2
File type: .pdf
Authentication: registered — Registered guest (free registration)