3 arrows

Popular Mirantis On Demand Training Courses Now 50% Off

closeClose

Oracle Database 19c: Performance Management and Tuning

  • Tuition USD $5,000
  • Reviews star_rate star_rate star_rate star_rate star_half 2923 Ratings
  • Course Code 19cDB-PMT
  • Duration 5 days
  • Available Formats Classroom, Virtual

Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance components.

Skills Gained

  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database

Course Details

Course Outline

  • Defining the Scope of Performance Issues
  • Using the Time Model to Diagnose Performance Issues
  • Using Statistics and Wait Events to Diagnose Performance Issues
  • Using Log and Trace Files to Monitor Performance
  • Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
  • Using Statspack to View Performance Data
  • Using Automatic Workload Repository
  • Using Metrics and Alerts
  • Using Baselines
  • Managing Automated Maintenance Tasks
  • Using ADDM to Analyze Performance
  • Using Active Session History Data for First Fault System Analysis
  • Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
  • Overview of SQL Statement Processing
  • Maintaining Indexes
  • Maintaining Tables
  • Introduction to Query Optimizer
  • Understanding Execution Plans
  • Viewing Execution Plans by Using SQL Trace and TKPROF
  • Managing Optimizer Statistics
  • Using Automatic SQL Tuning
  • Using the SQL Plan Management Feature
  • Using the SQL Tuning Advisor
  • Using the SQL Access Advisor
  • Overview of Real Application Testing Components
  • Using SQL Performance Analyzer to Determine the Impact of Changes
  • Using Database Replay to Test System Performance
  • Implementing Real-Time Database Operation Monitoring
  • Using Services to Monitor Applications
  • Overview of Memory Structures
  • Managing Shared Pool Performance
  • Managing Buffer Cache Performance
  • Managing PGA and Temporary Space Performance
  • Configuring the Large Pool
  • Using Automatic Shared Memory Management
  • Configuring the In-Memory Column Store Feature
  • Using the In-Memory Column Store Feature to Improve SQL Performance
  • Using In-Memory Column Store with Oracle Database Features

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great class and love the interactions with fellow classmates and instructor.

The lady at the front really nice. Everthing was always stocked up: Helpful

Fantastic and great training. Tons of hands-on labs to really make you understand the material being thought.

Very Helpful when trying to get me answers to questions and get access to classes. Very prompt and helpful. Thank you.

Well planned presentations. Live Demo. Excellent labs to ensure comprehension.

4 options available

undo
  • May 24, 2021 May 28, 2021 (5 days)
    Location
    iMVP
    Language
    English
    Time
    12:00PM 8:00PM EDT
    Enroll
    Enroll
  • Jun 7, 2021 Jun 11, 2021 (5 days)
    Location
    iMVP
    Language
    English
    Time
    9:00AM 5:00PM EDT
    Enroll
    Enroll
  • Aug 16, 2021 Aug 20, 2021 (5 days)
    Location
    iMVP
    Language
    English
    Time
    11:00AM 7:00PM EDT
    Enroll
    Enroll
  • Sep 27, 2021 Oct 1, 2021 (5 days)
    Location
    iMVP
    Language
    English
    Time
    9:00AM 5:00PM EDT
    Enroll
    Enroll
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward