 |
|
|
Oracle Time Model Tuning This chapter covered the basic concepts of the new time model tuning method and how to use timing statistics to quickly identify high resource consuming sessions and components.
The time model approach is a very powerful tool for finding and resolving performance issues, especially when a system is CPU-bound. Furthermore, the time model statistics allow the DBA to build sophisticated monitoring and analysis solutions based on real time data and history stored in the AWR.
The main points of this chapter include: § The automatic Active Session History (ASH) data collection makes it easy to see recent database sessions and a breakdown of the response time waits for each session. § The dba_hist_sys_time_model table provides valuable aggregate information on total database time spent in different phases of database processing. This is very helpful for implementing instance-wide features and adjusting initialization parameters. § The session ID can be specified when querying dba_hist_sys_time_model to see specific details about individual session processing patterns. The next chapter is one of the most important chapters in this text as it presents information on reading the AWR report. Despite the tools and tricks shared in this book, the DBA must still be able to understand the raw data, and reading an AWR report is an indispensable skill for any Oracle DBA.
|
|
|
