13 Performance Management

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