Oracle 1Z0-054 Certification Exam Syllabus

1Z0-054 Syllabus, 1Z0-054 Dumps PDF, Oracle OCE Dumps, 1Z0-054 Dumps Free Download PDF, Oracle Database OCE Dumps, 1Z0-054 Latest Dumps Free DownloadYou can use this exam guide to collect all the information about Oracle Database 11g - Performance Tuning (1Z0-054) certification. The Oracle 1Z0-054 certification is mainly targeted to those candidates who has some experience or exposure of Oracle Database and want to flourish their career with Oracle Database 11g Performance Tuning Certified Expert (OCE) credential. The Oracle Database 11g - Performance Tuning certification exam validates your understanding of the Oracle Database technology and sets the stage for your future progression. Your preparation plan for Oracle 1Z0-054 Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following Certification Exam Topics table.

Oracle 1Z0-054 Certification Details:

Exam Name Oracle Database 11g - Performance Tuning
Exam Code 1Z0-054
Exam Product Version
Oracle Database 11g
Exam Price USD $245 (Pricing may vary by country or by localized currency)
Duration 135 minutes
Number of Questions 80
Passing Score 70%
Validated Against The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0.
Format Multiple Choice
Recommended Training Oracle Database 11g: Performance Tuning
Schedule Exam Pearson VUE - Oracle
Recommended Practice 1Z0-054 Online Practice Exam

Oracle 1Z0-054 Certification 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

The Oracle 1Z0-054 Certification Program certifies candidates on skills and knowledge related to Oracle Database products and technologies. The Oracle Database 11g Performance Tuning Certified Expert is granted based on a combination of passing exams, training and performance-based assignments, depending on the level of certification. Oracle 1Z0-054 certification is tangible benchmark of experience and expertise that help you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exam and hands-on experience to prepare for your Oracle Database 11g - Performance Tuning certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.

Rating: 5 / 5 (35 votes)