Oracle Database Performance and Tuning Essentials 2015

Oracle Database Performance and Tuning Essentials 2015

The Oracle Database Performance and Tuning Essentials 2015 Exam (1Z0-417) is designed for individuals that are proficient in implementing Oracle Databases, Applications using Oracle Databases, or Oracle Database technology solutions or services. Oracle Database Performance and Tuning automates monitoring and collection of data, performance troubleshooting and analyzing it to find the source of problems, provide recommendations for corrective action and tuning that can be reviewed and executed. Topics covered in this certification: Solution Overview; Positioning/Confirming appropriate Solution to Implement; Product Area Features and Functions for Technical Individuals; Architecture; Solution Implementation: Installation, Configuration; Performance Diagnostics and Monitoring, Best Practices; Performance Tuning, Best Practices; Use Cases, Scenarios. This certification differentiates candidates in the marketplace by providing a competitive edge through proven knowledge and expertise. Up-to-date training and field experience are recommended.

This certification is available to all candidates but is geared toward members of the Oracle PartnerNetwork. OPN members earning this certification will be recognized as OPN Certified Specialists. This certification qualifies as competency criteria for the Oracle Database Performance and Tuning specialization.

Exam Number:
1Z0-417
Duration:
120 minutes
Associated Certifications:
Oracle Database Performance and Tuning 2015 Certified Implementation Specialist
OPN Certified Specialist
Number of
Questions:
82
Exam Price:
US$ 245

More on exam pricing
Passing
Score:
75%

Passing score subject to change. View Details
Click Here to Register:
Register online or by phone. Registration will be available once the exam is on beta.

 

Recommended Training and Preparation Additional Training Additional Information & Resources Exam Topics
Fraudulent Activity Policy            

Recommended Training

OPN Guided Learning Path
Exam Study Guide (PDF)
Oracle Database Performance and Tuning 2015 Certified Implementation Specialist



Additional Training Available

 

Additional Information & Resources
Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)

 

Exam Topics

Solution Overview

  • Oracle's strategy and solution for database performance & tuning
  • History & future public road map
  • Oracle product technology differentiation for database performance within the Oracle portfolio, competitive marketplace and capability available to partners
    • Choice of manual and automated performance and tuning from Oracle
  • What is required to get started with an Oracle Database Performance and Tuning solution

Positioning the Solution

  • Articulate probing questions that help position and match Oracle technology to database performance needs
  • Articulate Oracle product technology that addresses the market trends and business dynamics, driving the customer requirements
  • Articulate key positioning statements for an Oracle Database Performance solution
  • Articulate the value proposition for an Oracle Database solution, describe how the solution benefits and impacts a customer's financial position (i.e. top-line and bottom-line)

Product Area Features and Functions for Technical Individuals

  • Provide a technical definition of Oracle Database Performance
  • Provide high level overview of key hardware and/or software product components for an Oracle Database Performance solution
  • Articulate key functionality, terminology unique to Oracle's solution including:
    • Oracle Performance Tuning Method, DB Time Model
    • Oracle Database performance diagnostic product technology capabilities
    • Database Express
    • Additional Database Performance capability gained by using Oracle Enterprise Manager Cloud Control
  • Articulate and map features, capabilities, and benefits to customer business needs and requirements

Architecture

  • Describe type of hardware on which product/solution runs
  • Outline system requirements to build the solution. Reference sources of architecture and best practices
    • single tenant, multitenant, non-CDB
  • Understand Oracle architecture that could be used for an Oracle Database Performance and Tuning solution including:
    • AWR, ADDM, ASH
    • Database Express
    • Real Application Testing
    • Real User Experience Insight
    • Oracle Application Testing
    • Oracle Enterprise Manager Cloud Control integration
  • Articulate integration options and abilities available for an Oracle Database Performance solution

Solution Implementation – Installation, Configuration

  • Outline requirements, plan environment readiness for implementation of an Oracle Database and Performance and Tuning solution
  • Implement Oracle Performance and Tuning product technology
    • Installation
    • Configuration
    • Test, validate installation and configuration was successful

Performance Diagnostics and Monitoring, Best Practices

  • Articulate, use, apply database performance troubleshooting techniques using an Oracle Database Performance and Tuning solution
    • Application, database, middleware, network, system, storage
    • AWR, ADDM, ASH
    • Database Express Performance Hub
    • Real User Experience Monitoring
  • View, modify parameters used to configure Oracle database performance using an Oracle Database Performance and Tuning solution
  • Define, setup, run, automate, database performance reporting using an Oracle Database Performance and Tuning solution

Performance, Tuning, Best Practices

  • Articulate, analyze, apply database performance tuning using an Oracle Database Performance and Tuning solution
    • SQL Tuning Advisor, SQL Access Advisor, Segment Advisor
    • View, modify SQL to tune database performance using an Oracle Database Performance and Tuning solution
    • Define, setup, run, automate, SQL tuning using an Oracle Database Performance and Tuning solution

Performance Testing, Best Practices

  • Articulate testing of database performance using an Oracle Database Performance and Tuning solution
    • SQL Performance Analyzer
    • Database Replay
    • Synthetic User Monitoring
  • View, test, validate Oracle database performance using an Oracle Database Performance and Tuning solution
  • Define, setup, run, automate database performance testing using an Oracle Database Performance and Tuning solution

Use Cases, Scenarios

  • Describe common Oracle Database Performance and Tuning use cases:
    • Monitoring performance
    • Perform database performance health checks
    • Maintaining database availability
    • Database Diagnostics & Troubleshooting
  • Identify applicable Oracle Database Performance product technology for use case(s)
  • Describe implementation scenarios/options for an Oracle Database Performance and Tuning solution

 

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.

View (PDF) the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.


 
 E-mail this page  Printer View