Oracle Database 11g: Performance Tuning Methodology and Tools

• identify the steps in both the general and Oracle tuning methodologies
• identify the characteristics of effective tuning goals
• recognize the three types of performance data gathered by diagnostic tools
• recognize the factors to consider when tuning DB time
• recognize how to use the time model to diagnose performance issues
• recognize how to view diagnostic information in Enterprise Manager
• recognize how you can use dynamic performance to view statistics
• recognize how to use dynamic performance views to display wait events
• recognize how to use Alert Logs to perform tuning
• identify ways to generate user trace files
• view diagnostic information in a given scenario

Oracle Database 11g: Using AWR and Defining Problems

• identify the features of the AWR
• recognize how to create and manage AWR snapshots
• recognize how to run an AWR report
• recognize how to generate a Compare Periods report
• generate an AWR report in a given scenario
• generate a Compare Periods report in a given scenario
• recognize how to define problems
• recognize how to set tuning priorities
• identify factors to consider when tuning for different application life cycle phases
• identify the seven steps for implementing migration, upgrade, and environment changes
• recognize how business requirements affect performance
• identify how to file a performance service request
• recognize how to install Statspack
• recognize how to capture and manage Statspack snapshots
• recognize how to read Statspack performance reports

Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services

• identify the features of metrics, alerts, and baselines
• recognize how to view metric history information, metric details, and histogram views
• recognize how to receive an alert when a specified threshold is exceeded
• identify the features of AWR baselines
• recognize how to create AWR baselines
• recognize how to manage AWR baselines
• recognize how to manage thresholds
• create and manage AWR baselines and thresholds
• recognize how to tune automatic maintenance tasks
• recognize how to generate and read ADDM reports
• identify the features of the Active Session History
• recognize how to generate ASH reports
• recognize how to configure and manage services
• recognize how to use services with client applications, the Database Resource Manager, and the
• Scheduler
• recognize how to set performance-metric thresholds on services
• recognize how to configure services aggregation and tracing

Oracle Database 11g: Problem SQL Statements and Oracle Optimizer

• match each phase in SQL statement processing with its features
• identify the steps in DML processing
• identify the operations performed by the Oracle optimizer
• recognize the features of execution plans
• recognize how to generate and view execution plans
• recognize how to use the SQL*Plus AUTOTRACE command options to view execution plans and
• statistics
• identify the steps involved in using the SQL Trace facility
• identify the functions of the query optimizer
• recognize how to influence and control the optimizer's behavior
• identify the scan types for retrieving data from the database
• recognize how to work with bitmap and B*Tree indexes
• identify when to use different join methods
• identify common sort operations
• recognize how to manage and maintain indexes
• recognize how to reorganize tables
• use AUTOTRACE to analyze statistics and execution plans in a given scenario

Oracle Database 11g: SQL Performance Management and Database Replay

• recognize the steps in the SQL Performance Analyzer process
• recognize how to use the SQL Performance Analyzer with PL/SQL
• recognize how to manage changes to optimizer statistics to maintain SQL performance
• recognize how to use Automatic SQL Tuning to automate the SQL tuning process
• recognize how to set up SQL plan management
• seed SQL plan baselines from SQL Performance Analyzer in a given scenario
• recognize the steps in using Database Replay to test the impact of a system change
• recognize how to use the Enterprise Manager to capture workloads
• recognize how to replay workloads using the Enterprise Manager
• recognize how to use PL/SQL to capture and replay workloads

Oracle Database 11g: Shared Pool and Buffer Cache Tuning

• recognize the features of the shared pool
• identify the role of AWR and Statspack reports indicators when diagnosing problems
• recognize how to avoid hard parses
• recognize how to avoid soft parses
• recognize how to reserve space in the shared pool
• recognize how to manage the results cache
• recognize the features of the buffer cache architecture
• identify the symptoms that indicate a buffer cache problem
• identify methods to resolve common performance issues related to the buffer cache
• recognize how to properly size the buffer cache
• manage the buffer cache in given scenarios

Oracle Database 11g: Tuning PGA, Temporary Space, and AMM

• identify how to diagnose PGA memory issues
• recognize how to size the PGA memory
• recognize how to manage temporary tablespaces
• identify the components of Automatic Shared Memory Management
• recognize how to configure Automatic Shared Memory Management (ASMM)
• recognize how to configure Automatic Memory Management
• configure memory in a given scenario
• tune PGA memory in a given scenario
• create a temporary tablespace group in a given scenario

Oracle Database 11g: Segment Space, I/O, and Performance Tuning

• identify the characteristics of extents
• identify the characteristics of blocks
• identify the characteristics of Automatic Segment Space Management (ASSM)
• recognize how to manage row migration and chaining
• recognize how to shrink segments using SQL or the Enterprise Manager
• recognize how to use table compression
• identify the characteristics of I/O
• recognize how to tune I/O effectively
• identify the characteristics of RAID
• recognize how to manage and monitor ASM
• recognize best practices for performance tuning
• tune I/O in a given scenario
• view I/O statistics in a given scenario