This course introduces tools you can use to diagnose problems in a database, and then detect and resolve performance issues.
Objectives:
Set up Automatic Diagnostic Repository
Use Support Workbench
Perform block media recovery
Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Recognize Database Replay
Topics:
Diagnosing the Database and 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.
