Among the specific subjects discussed within this textbook are:
• How database performance tuning, SQL statement and application tuning, and the overall systems infrastructure configuration contribute to the performance of database installations.
• Contrast online transaction processing applications with data warehouse activity.
• Consider the systems components that interact with a database installation within multi-tiered systems architectures commonly in use today.
• Review the top 10-database configuration mistakes which contribute towards poor performance.
• Review the top 3 host system performance issues found on database servers.
• Host system components that influence database performance, such as operating systems like Linux, processor capabilities and input/output devices.
• Understanding system read and write internals, such as the difference between small reads and writes versus large reads and writes, asynchronous input/output versus synchronous input/output.
• Review the database performance assessment and performance tuning facilities built into the Oracle database server.
• Understanding the benefit of database performance statistics, metrics, alerts, thresholds and baselines.
• Using the Enterprise Manager real-time performance monitors to immediately assess current database performance.
• Interpreting database operational statistics, wait events and time model statistics to assess database performance and identify processing bottlenecks and constraints.
The second volume of this textbook set then provides tuning techniques and remedies that can be applied to address specific problems commonly found, such as the performance bottlenecks demonstrated in this textbook.
PDF outline here!