This course provides information on general database maintenance and how to effectively manage database performance.
Objectives:
Use and manage Optimizer Statistics
Use and manage Automatic Workload Repository (AWR)
Use Advisory Framework
Manage Alerts and Thresholds
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects
Topics:
Maintaining the Database
Managing Performance
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
