|Title:||Oracle Operational Timing Data|
|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.
|Updated:||Wed 15 Oct 2003 (11.5 years ago)|
|File size:||276,870 bytes|
|Authentication:||registered — Registered guest (free registration)|