Oracle Performance Tuning Online Training

Oracle Performance Tuning Online Training

0 STUDENTS ENROLLED

    Introduction

    Oracle Performance Tuning Training makes you an expert in Deploying New Applications, Automatic Workload Repository, PGA Memory Management, Automatic Database Diagnostic Monitor and Understanding Connection Models….etc.

    Course Content

    1.Performance Tuning Overview

    • Introduction to Performance Tuning
    • Introduction to Performance Tuning Features and Tools

    2.Designing And Developing For Performance

    • Oracle Methodology
    • Understanding Investment Options
    • Understanding Scalability
    • System Architecture
    • Application Design Principles
    • Workload Testing, Modeling, and Implementation
    • Deploying New Applications

    3.Performance Improvement Methods

    • The Oracle Performance Improvement Method
    • Emergency Performance Methods

    4.Configuring A Database For Performance

    • Performance Considerations for Initial Instance Configuration
    • Creating and Maintaining Tables for Good Performance
    • Performance Considerations for Shared Servers

    5.Automatic Performance Statistics

    • Overview of Data Gathering
    • Automatic Workload Repository

    6.Automatic Performance Diagnostics

    • Introduction to Database Diagnostic Monitoring
    • Automatic Database Diagnostic Monitor

    7.Memory Configuration And Use

    • Understanding Memory Allocation Issues
    • Configuring and Using the Buffer Cache
    • Configuring and Using the Shared Pool and Large Pool
    • Configuring and Using the Redo Log Buffer
    • PGA Memory Management

    8.I/O Configuration And Design

    • Understanding I/O
    • Basic I/O Configuration

    9.Understanding Operating System Resources

    • Understanding Operating System Performance Issues
    • Solving Operating System Problems

    10.Understanding CPU

    • Finding System CPU Utilization

    11.Instance Tuning Using Performance Views

    • Instance Tuning Steps
    • Interpreting Oracle Statistics
    • Wait Events Statistics
    • Idle Wait Events

    12.Tuning Networks

    • Understanding Connection Models
    • Detecting Network Problems
    • Solving Network Problems

    13.SQL Tuning Overview

    • Introduction to SQL Tuning
    • Goals for Tuning
    • Identifying High-Load SQL
    • Automatic SQL Tuning Features
    • Developing Efficient SQL Statements

    14.Automatic SQL Tuning

    • Automatic SQL Tuning Overview
    • SQL Tuning Advisor
    • Managing SQL Profiles with APIs
    • SQL Tuning Sets
    • SQL Tuning Information Views

    15.The Query Optimizer

    • Optimizer Operations
    • Choosing an Optimizer Goal
    • Enabling and Controlling Query Optimizer Features
    • Understanding the Query Optimizer
    • Understanding Access Paths for the Query Optimizer
    • Understanding Joins

    16.Managing Optimizer Statistics

    • Understanding Statistics
    • Automatic Statistics Gathering
    • Manual Statistics Gathering
    • System Statistics
    • Managing Statistics
    • Viewing Statistics

    17.Using Indexes And Clusters

    • Understanding Index Performance
    • Using Function-based Indexes for Performance
    • Using Partitioned Indexes for Performance
    • Using Index-Organized Tables for Performance
    • Using Bitmap Indexes for Performance
    • Using Bitmap Join Indexes for Performance
    • Using Domain Indexes for Performance
    • Using Clusters for Performance
    • Using Hash Clusters for Performance

    18.Optimizer Hints

    • Understanding Optimizer Hints
    • Using Optimizer Hints

    19.Using Plan Stability

    • Using Plan Stability to Preserve Execution Plans
    • Using Plan Stability with Query Optimizer Upgrades

    20.Using EXPLAIN PLAN

    • Understanding EXPLAIN PLAN
    • The PLAN_TABLE Output Table

    21.Running EXPLAIN PLAN

    • Displaying PLAN_TABLE Output
    • Reading EXPLAIN PLAN Output
    • Viewing Parallel Execution with EXPLAIN PLAN
    • Viewing Bitmap Indexes with EXPLAIN PLAN
    • Viewing Partitioned Objects with EXPLAIN PLAN

    22.Using Application Tracing Tools

    • End to End Application Tracing
    • Using the trcsess Utility
    • Understanding SQL Trace and TKPROF
    • Using the SQL Trace Facility and TKPROF
    • Avoiding Pitfalls in TKPROF Interpretation
    • Sample TKPROF Output

    Write a Review

    Your email address will not be published. Required fields are marked *

    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. keen Technologies also verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.

    You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.

    Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    Keen Technologies does not provide official SAP training courses or certifications and does not provide any access to SAP software. SAP and its product names, including HANA, S/4HANA, HYBRIS, and LEONARDO are trademarks or registered trademarks of SAP in Germany and other countries.

    IBM® is a registered trademark of IBM in the United States.

    Popular Courses

    Countries

    Keen Technologies offering training in cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Texas, Chicago, San Francisco, Dallas, Washington, New York, Houstan, Atlanta, Orlando, Boston, Toronto, Ottawa, Windsor, Australia, Dubai, Leeds.


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    WhatsApp us whatsapp