Chapter 37
Visualizing the I/O Signature
Gary E. Sharpe
Using new visualization technology, it is now possible to observe the “I/O signature” of a production Oracle database, averaged over intervals of several hours to a week of workshifts or longer. Analysis carried out on some of the best-managed production servers in leading enterprises results in the conclusion that the logical I/O generated by users and applications is usually poorly matched to the capability of the disk storage resources on which the database and system files reside.
As a natural consequence of the relational architecture, sets of schemarelated objects become mutually active under the influence of applications and queries. Over any given work-shift interval a small number ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
