This is the affordable solution with the information you need to complete your self-study for 1Z0-117. The study guides in the Oracle Certification Prep series were developed to provide Oracle certification candidates a means to rapidly polish their skills for the exam. The information presented is clear and to the point.The 1Z0-117 guide covers all of the key exam topics:
- Introduction to SQL Tuning
- Interpreting Execution Plans
- Application Tracing
- Optimizer Operations, Statistics and Hints
- Star Transformation
- Using Bind Variables
- SQL Tuning Advisor
- Using SQL Access Advisor
- Automating SQL Tuning
- SQL Plan Management
- Parallel Processing Concepts
- Basics of Parallel Execution
- Manual DOP Management
- Simplified Auto DOP
- Statement Queuing
- In-Memory Parallel execution
- Manual DOP Management
- Simplified Auto DOP: Understand the new parameters of Auto DOP
- In-Memory Parallel Execution
- Implement parallel processing and partitioning strategies
- Materialized Views
Matthew Morris has worked with the Oracle database since 1996 when he worked in the RDBMS support team for Oracle Support Services. Employed by Oracle for over eleven years in support and development positions, Matthew was an early adopter of the Oracle Certified Professional program. He was one of the first one hundred Oracle Certified Database Administrators (version 7.3) and was also in the first hundred to become an Oracle Certified Forms Developer. In the years since, he has upgraded his Database Administrator certification for releases 8i, 9i, 10G and 11G, become an Advanced PL/SQL Developer Certified Professional, and added the Expert certifications for Application Express, SQL, and SQL Tuning. Outside of Oracle, he has CompTIA certifications in Linux+ and Security+. Matthew is an experienced Database Administrator and PL/SQL developer and has been creating Web applications with Oracle Application Express since the early days of its release. He is currently employed as a Database Engineer with Computer Sciences Corporation developing enterprise applications.