This course provides information on how Oracle 10g establishes alert thresholds and gathers baseline metrics. It also explains how to use tuning and diagnostic advisors, as well as the Automatic Database Diagnostic Monitor (ADDM).
Objectives:
Explain how Oracle establishes alert thresholds
Describe how Oracle gathers baseline metrics
Define how to use Oracle tuning and diagnostic advisors
Describe Oracle's automatic workload repository
Topics:
Database maintenance: alerts and thresholds
Database maintenance: advisors
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.