Transcription
Oracle Database 11g: Performance Tuning – Exam StudyGuideThe Oracle Database 11g: Performance Tuning Exam Study Guide is designed to provide studentswith the information that can help them learn more to pass the Oracle Database 11g Performance Tuning(1Z0-054) Exam.The exam audience is represented by database administrators, support engineers, and technicalconsultants who can demonstrate their knowledge and skills using Oracle Database 11g automatic tuningfeatures, including SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository andAutomatic Database Diagnostic Monitor.For each exam topic there have been identified alternative training options that are available at Oracle.Please note that some of the training recommended can cover multiple exam topics.The exam covers 19 topics.Topic 1: Basic Tuning ToolsObjectivesDiagnose performance issues using top wait events and the time modelUse dynamic performance views to view statistics and wait eventsUse Enterprise Manager MonitoringIdentify the key tuning components of the alert logsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 2: Using Automatic Workload RepositoryObjectivesCreate and manage AWR snapshotsGenerate and read AWR reports, analyze Compare Periods reportsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 3: Defining ProblemsObjectivesIdentify performance issues & set tuning priorities1
Interpret tuning diagnosticsTune for life cycle phaseTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 4: Using Metrics and AlertsObjectivesInterpret metric views and alertsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 5: BaselineObjectivesCreate and manage AWR baselinesCreate AWR baselines for future time periodsMonitor performance and enable adaptive thresholdsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 6: Using AWR-Based ToolsObjectivesTune automatic maintenance tasksAnalyze ADDM reportsAnalyze Active Session History (ASH) reportsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 7: Monitoring an ApplicationObjectivesConfigure and manage servicesUse services with client applications, Database Resource Manager and Scheduler2
Configure services aggregation, tracing, and set performance-metric thresholdsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 8: Identifying Problem SQL StatementsObjectivesDescribe SQL statement processingView the SQL statement statistics to identify the SQL statements that performpoorlyDescribe and use methods for Viewing Execution PlansTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 9: Influencing the OptimizerObjectivesDescribe the optimizer's behaviorAdjust parameters to influence the optimizerInfluence the optimizer (access methods, join techniques and adjust datastructures)Training OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 10: SQL Performance ManagementObjectivesManage optimizer statisticsConfigure automatic SQL tuning and SQL profilingSet up and use SQL plan baselineTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 11: Using SQL Performance Analyzer3
ObjectivesDescribe SQL Performance Analyzer process and benefitsUse SQL Performance AnalyzerTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 12: Using Database ReplayObjectivesIdentify when and how to use Database ReplayUse Enterprise Manager to record and replay workloadsTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 13: Tuning the Shared PoolObjectivesDescribe Latches and MutexesDiagnose and change cursor sharingDiagnose and resolve shared pool fragmentationManage the results cache and tune the large poolTune the data dictionary cacheTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 14: Tuning the Buffer CacheObjectivesDescribe the buffer cache architectureExplain the symptoms that indicate a buffer cache problemTune the buffer cache for performance issuesTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 15: Tuning PGA and Temporary Space4
ObjectivesDiagnose PGA memory issues and size the PGADiagnose temporary space issuesSpecify temporary tablespace parameters for efficient operationTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 16: Automatic Memory ManagementObjectivesImplement Automatic Shared Memory Management (ASMM)Implement Automatic Memory Management (AMM)Training OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 17: Tuning Segment Space UsageObjectivesTune segment space managementUse Automatic Segment Space ManagementDiagnose row migration and chainingUse segment shrinking and table compressionTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningTopic 18: Tuning I/OObjectivesDiagnose database I/O issuesDescribe the Stripe and Mirror Everything (SAME) conceptSet filesystemio options and choose appropriate I/O solutionsTune Automatic Storage Management (ASM)Training OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance Tuning5
Topic 19: Appendix B Using StatspackObjectivesUsing StatspackTraining OptionsoInstructor Led Training (delivered by Oracle University) Oracle Database 11g: Performance TuningCopyright 2011, Oracle and/or its affiliates. All rights reserved.This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any otherwarranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaimany liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in anyform or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. 01096
The Oracle Database 11g: Performance Tuning Exam Study Guide is designed to provide students with the information that can help them learn more to pass the Oracle Database 11g Performance Tuning (1Z0-054) Exam. The exam audience is represented by database administrators, support engineers, and technical .
