Oracle Database 11g: Performance Tuning

Exam Number:	1Z0-054
Associated Certifications:	Oracle Database 11g Performance Tuning Certified Expert OPN Certified Specialist
Exam Price:	$125 US
Exam Registration:	Register

Duration:

120 mins

Number of Questions:

Passing Score:

Passing score subject to change. View Details

Recommended Training and Preparation

Oracle Database 11g: Performance Tuning
Training Opportunities for Oracle Partner Network Members

Additional Information & Resources

Exam Retake Policy

Exam Topics

Basic Tuning Tools
[ ]	Diagnose performance issues using top wait events and the time model
[ ]	Use dynamic performance views to view statistics and wait events
[ ]	Use Enterprise Manager Monitoring
[ ]	Identify the key tuning components of the alert logs

Using Automatic Workload Repository
[ ]	Create and manage AWR snapshots
[ ]	Generate and read AWR reports, analyze Compare Periods reports

Defining Problems
[ ]	Identify performance issues & set tuning priorities
[ ]	Interpret tuning diagnostics
[ ]	Tune for life cycle phase

Using Metrics and Alerts
[ ]	Interprete metric views and alerts

Baseline
[ ]	Create and manage AWR baselines
[ ]	Create AWR baselines for future time periods
[ ]	Monitor performance and enable adaptive thresholds

Using AWR-Based Tools
[ ]	Tune automatic maintenance tasks
[ ]	Analyze ADDM reports
[ ]	Analyze Active Session History (ASH) reports

Monitoring an Application
[ ]	Configure and manage services
[ ]	Use services with client applications, Database Resource Manager and Scheduler
[ ]	Configure services aggregation, tracing, and set performance-metric thresholds

Identifying Problem SQL Statements
[ ]	Describe SQL statement processing
[ ]	View the SQL statement statistics to identify the SQL statements that perform poorly
[ ]	Describe and use methods for Viewing Execution Plans

Influencing the Optimizer
[ ]	Describe the optimizer's behavior
[ ]	Adjust parameters to influence the optimizer
[ ]	Influence the optimizer (access methods, join techniques and adjust data structures)

SQL Performance Management
[ ]	Manage optimizer statistics
[ ]	Configure automatic SQL tuning and SQL profiling
[ ]	Set up and use SQL plan baseline

Using SQL Performance Analyzer
[ ]	Describe SQL Performance Analyzer process and benefits
[ ]	Use SQL Performance Analyzer

Using Database Replay
[ ]	Identify when and how to use Database Replay
[ ]	Use Enterprise Manager to record and replay workloads

Tuning the Shared Pool
[ ]	Describe Latches and Mutexes
[ ]	Diagnose and change cursor sharing
[ ]	Diagnose and resolve shared pool fragmentation
[ ]	Manage the results cache and tune the large pool
[ ]	Tune the data dictionary cache

Tuning the Buffer Cache
[ ]	Describe the buffer cache architecture
[ ]	Explain the symptoms that indicate a buffer cache problem
[ ]	Tune the buffer cache for performance issues

Tuning PGA and Temporary Space
[ ]	Diagnose PGA memory issues and size the PGA
[ ]	Diagnose temporary space issues
[ ]	Specify temporary tablespace parameters for efficient operation

Automatic Memory Management
[ ]	Implement Automatic Shared Memory Management (ASMM)
[ ]	Implement Automatic Memory Management (AMM)

Tuning Segment Space Usage
[ ]	Tune segment space management
[ ]	Use Automatic Segment Space Management
[ ]	Diagnose row migration and chaining
[ ]	Use segment shrinking and table compression

Tuning I/O
[ ]	Diagnose database I/O issues
[ ]	Describe the Stripe and Mirror Everything (SAME) concept
[ ]	Set filesystemio_options and Choose appropriate I/O solutions
[ ]	Tune Automatic Storage Management (ASM)

Appendix B Using Statspack
[ ]	Using Statspack

Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.