After completing this lesson, you should be able to do the following: • Use Enterprise Manager to monitor performance • Tune SQL by using the SQL Tuning Advisor • Tune SQL by using the SQL Access Advisor • Use Automatic Shared Memory Management (ASSM) • Use the Memory Advisor to size memory buffers • View performance-related dynamic views • Troubleshoot invalid and unusable objects | Performance Management Oracle Database 10g: Administration Workshop I 13- Objectives After completing this lesson, you should be able to do the following: Use Enterprise Manager to monitor performance Tune SQL by using the SQL Tuning Advisor Tune SQL by using the SQL Access Advisor Use Automatic Shared Memory Management (ASSM) Use the Memory Advisor to size memory buffers View performance-related dynamic views Troubleshoot invalid and unusable objects Oracle Database 10g: Administration Workshop I 13- Performance Monitoring Memory allocation issues Input/output device contention Application code problems Resource contention Network bottlenecks ? DBA > Perf Mon Tuning Adv Access Adv Memory Stats Invalid Obj Performance Monitoring To administer Oracle Database 10g and keep it running smoothly, the database administrator (DBA) must regularly monitor its performance to locate bottlenecks and correct problem areas. There are hundreds of performance measurements the DBA can look at, | Performance Management Oracle Database 10g: Administration Workshop I 13- Objectives After completing this lesson, you should be able to do the following: Use Enterprise Manager to monitor performance Tune SQL by using the SQL Tuning Advisor Tune SQL by using the SQL Access Advisor Use Automatic Shared Memory Management (ASSM) Use the Memory Advisor to size memory buffers View performance-related dynamic views Troubleshoot invalid and unusable objects Oracle Database 10g: Administration Workshop I 13- Performance Monitoring Memory allocation issues Input/output device contention Application code problems Resource contention Network bottlenecks ? DBA > Perf Mon Tuning Adv Access Adv Memory Stats Invalid Obj Performance Monitoring To administer Oracle Database 10g and keep it running smoothly, the database administrator (DBA) must regularly monitor its performance to locate bottlenecks and correct problem areas. There are hundreds of performance measurements the DBA can look at, covering everything from network performance and disk input/output (I/O) speed to the time spent working on individual application operations. These performance measurements are commonly referred to as database metrics. Note: For more information about Oracle database performance, see the Oracle Database 10g: SQL Tuning Workshop course. Oracle Database 10g: Administration Workshop I 13- Performance Monitoring Performance Monitoring (continued) The Performance tabbed page in Enterprise Manager is the portal to a powerful set of performance monitoring and tuning tools. The first screen on this page summarizes processes and active session activity. The Average Active Sessions graph shows the level of CPU usage and what resources are causing the most wait events. In the screen in the slide, you see that there was a recent increase in CPU usage and waits for User I/O, System I/O, and Concurrency. You can click any one of these categories to see more details about the waits. The I/O .
