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