Characteristics of an Optimally Tuned Oracle System
An optimally tuned Oracle system has several characteristics:
Waiting on I/O should be minimal because this indicates that the CPU has work to do while there are outstanding I/Os.
Most CPU usage should be allocated to shadow processes and threads, not to background processes and threads.
Response time should be fast. Quick system response is dependent on several components of which application and network tuning play a major role.
The system should be CPU bound. The performance of CPU-bound systems can be improved by adding more processors. The following guidelines can be used to ensure that the system isn't I/O bound:
Isolate sequential I/Os to their own controller volumes. Components such as redo ...
Get e-Commerce Applications Using Oracle8i and Java from Scratch 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.
