+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    Oracle DBA Training

    • Home
    • All courses
    • Oracle DBA Training
    • Oracle Database Performance Tuning Workshop

    Oracle Database Performance Tuning Workshop
    Duration: 4 Days

    John Watson
    Oracle DBA Training

     4.9/5 (6)
    $3,200.00
    • Description
    • Topic Summary
    • Instructors
    • Reviews
    This course covers techniques for diagnosing and fixing performance issues within the instance and the database. These include Standard Edition facilities, also facilities available only with Enterprise Edition license and with EE options. Some aspects of SQL tuning are discussed, but generally speaking SQL tuning is dealt with elsewhere in the curriculum. There are three concluding topics: Real Application Testing, Partitioning, and parallel operations. These are optional topics, some or all of which may be covered depending on time, interest, and requisite background knowledge. As with all SkillBuilders courses, this class (if conducted at your company facilities) is highly customizable to your specific training requirements.

    The course is run against the current release of the database. Much of the content is applicable to earlier releases, and will be “back-ported” as necessary.


    Oracle Certified Master
    John Watson
  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

  • Price Qty
    03/29/21 - 04/02/21show details +hide details - $3,200.00 (USD)  

    Details

    Price
    Name Description Amount
    03/29/21 - 04/02/21 $3,200.00 (USD)
    Total $3,200.00 (USD)

    Sale Dates
    Goes On Sale: January 19, 2021   8:00 am
    Sales End: March 29, 2021   8:00 am

    Access
    - This option allows access to the following dates and times.
    Date Time
    03/29/21 - 04/02/21
    March 29, 2021 to April 1, 2021
    9:00 am to 5:00 pm ET


    • Share:
    The tuning methodology
    • What can be tuned?
    • The concept of DB Time
    • The response time tuning method
      Server architecture and SQL statement processing: review
    • Memory structures: SGA and PGA
    • Background processes
    • Session architecture
    • Multithreaded and multiprocess models
    • The SQL parse / bind / execute / fetch cycle
      Diagnostic tools and wait events
    • Use the wait event interface
    • Enable session tracing
    • Interrogate the Active Session History
      Frequently encountered wait events
    • Disc I/O events
    • Buffer cache related events
    • Shared pool events
    • Redo generation events
    • Contention events
    • Enqueue waits
    • Latch and mutex events
      Using Statspack and AWR reports
    • Understand the automatic snapshot mechanism
    • Use the DBMS_WORKLOAD_REPOSITORY package
    • Create snapshots
    • Create baselines
    • Modify settings
    • Generate and interpret AWR reports
    • Generate AWR SQL reports
    • Install and use Statspack
      Tuning memory structures
    • Investigate the SGA memory structures
    • Diagnose and fix issues with sizing of the SGA components
    • Use automatic shared memory management (ASMM)
    • Manage the aggregate PGA 
    • Understand the need for PGA memory
    • Correctly size the aggregate PGA
    • Work with temporary tablespaces
    • Enable automatic memory management (AMM)
      Database physical structures
    • Understand when and why RAID and/or ASM is needed
    • Give Oracle information about disk performance
    • Investigate the space allocation algorithms
    • Contrast smallfile and bigfile tablespaces
    • Describe and evaluate the use of Automatic Storage Management
      Metrics, alerts, and autotasks: the “self-managing” database
    • Define statistics and metrics
    • Use the server generated alert system
    • Set up alerts on baselines
    • Investigate the capabilities of the Autotask system
      Indexes
    • Understand the purpose of indexes
    • Describe the types of index
    • B-tree indexes
    • Function based indexes
    • Reverse key indexes
    • Bitmap and bitmap join indexes
    • Create and maintain indexes
    • The Oracle Text domain index type
      Tables
    • Heap Tables
    • Partitioned Tables
    • Index-Organized Tables (IOT)
    • Clustered tables
    • Temporary Tables
    • Datatype selection for SQL performance
    • Constraints vs. Triggers
    • Table Compression
    • Multiple Blocksize Support
    • The NOLOGGING Option
    • Re-organizing and shrinking tables
      Statistics
    • Understand the importance of statistics
    • Object statistics
    • System statistics
    • Dictionary and fixed objects statistics
    • Build histograms
    • Type and purpose of histograms
    • Extended (or “column group”) statistics
    • Use dynamic sampling
    • Manage SQL directives
      SQL execution plan stability
    • Learn how to stabilize execution plans
    • Explain the adaptive reoptimization processes
    • Statistics feedback
    • Adaptive execution plans
    • Contrast SQL Directives with SQL Profiles
    • Understand the importance of bind variables
    • Impact of bind variables on parsing and the library cache
    • Use of adaptive cursor sharing
      The Advisors
    • Review the Management Packs and the AWR
    • The Automatic Database Diagnostic Monitor
    • SQL Tuning Advisor
    • The SQL Access Advisor
    • The Autotask tuning advice functionaility
    • SQL Profiles
      Real Application Testing
    • The issues of realistic testing
    • The SQL Performance Analyzer
    • Database Replay
    • Scenarios for using Real Application Testing
      Partitioning
    • Why to use partition: performance, manageability, scalability
    • Impact on memory and disc IO
    • Partitioning strategies: range, hash, list
    • Single level and composite partitioning
    • Partition tables, indexes, or both
    • Performance tuning aspects: partition pruning, partition-wise joins
      Parallel operations
    • When parallel execution is helpful
    • When and how to use parallel query
    • Parallel automatic tuning features
    • Parallel DML and parallel DDL
    • Parallel execution plans
      Common performance issues
    • What actually matters? Response time.
    • The tuning methodology
    • Oracle's top ten performance issues list
    John Watson
    https://skillbuilders.com/our_team/john-watson/
     4.9/5



    Gary Belke
    January 5, 2021
     4.8/5
    Vijay Raj Dasoju Ekambaram
    December 19, 2016
     5/5
    Terry Moutray
    June 9, 2014
     4.9/5

    John Watson really knows his stuff and is very enthusiastic.
    Jon Heller
    January 6, 2014
     5/5

    John is a wonderful instructor with very practical, real-world knowledge which he is able to relate to the course concepts. I previously attended his webinar on instance recovery and was so impressed that I enrolled for this as soon as I could.

    gototraining was very stable. It was a good experience. The amazon cloud machine were a little underpowered for the labs so that would have to be addressed
    ryan henderson
    December 9, 2013
     4.8/5

    The course Helped us to understand more about wait events and performance tune the database by understanding the popular wait events. The Instructor was very good, experienced and full of knowledge.
    Srikanth Balaga
    December 10, 2008
    • Description
    • Topic Summary
    • Instructors
    • Reviews
    $3,200.00
    loading...

    You May Like

    Oracle Database Administration Workshop Level 1 Read More
    John Watson

    Oracle Database Administration Workshop Level 1

    $3,200.00
    Oracle Database: Managing Multitenant Architecture Read More
    John Watson

    Oracle Database: Managing Multitenant Architecture

    $2,100.00
    Oracle RAC and Grid Infrastructure Administration Fast Track Training Read More
    John Watson

    Oracle RAC and Grid Infrastructure Administration Fast Track Training

    $5,000.00

    Featured Courses

    Backup and Recovery with Oracle RMAN

    January 25, 2021
    $2,700.00

    Oracle PL/SQL Programming Workshop

    January 25, 2021
    $2,700.00

    Intermediate Oracle Application Express (APEX) Training

    January 25, 2021
    $2,700.00

    Oracle Database: Managing Multitenant Architecture

    February 1, 2021
    $2,100.00

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.

    Register for this Class
    • Please enter a number from 2 to 5000.