ABSTRACT

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.