July 2017
Intermediate to advanced
896 pages
23h 12m
English
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 ...
Read now
Unlock full access