Oracle 19c Database Tuning

Trivera Technologies LLC
Training overview
Professional Course
5 days

Course description

Oracle 19c Database Tuning

Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.

Course Objectives

Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore:

  • Overview Oracle Database Architecture
  • Query Optimizer
  • Tuning Container Databases and Pluggable Databases
  • Oracle 12c Tuning features
  • Evaluating Execution Plans
  • Oracle Tuning Tools
  • Using Automatic Workload Repository
  • Join Types
  • AWR Using Baselines
  • Additional AWR performance tools
  • Optimizer Statistics
  • Monitoring a Service
  • Bind Variables and database parameters
  • Oracle's Real Application Testing (RAT)
  • SQL Tuning Advisor
  • Automatic Sql Tuning
  • Sql Plan Management
  • Shared Pool Tuning
  • Tuning the database buffer cache
  • Tuning the PGA (Program Global Area)
  • Automatic Memory Management (AMM)
  • Tuning Segment Space Utilization (ASSM)
  • Automatic Storage Management

Trivera offers hundreds of end-to-end skills-focused courses that provide participants with the job-ready skills they require to be truly productive in a modern IT business enterprise. Our courses are available for individuals, their teams, or across their organization, for students of all skill levels and roles.  We offer an extensive online Public Course Schedule, deep catalog for Private Courses, flex-hour Mini-Camp short courses, self-paced QuickSkills courses, free webinars and more.  Trivera’s unique EveryCourse Extras and AfterCourse Extras programs, included with every course, ensure our students can put their newly-learned skills right to work, while providing them with a solid platform for continued skills-development, support and long-term growth.   For more information about our dedicated training services, public course offerings, collaborative coaching services, new hire or enterprise upskilling programs, or to see our complete list of course offerings and special offers please call us toll free at 844-475-4559. Our pricing and services are always satisfaction guaranteed.

Want to find out more?

Who should attend?

This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher.

Training content


  1. Overview Oracle Database Architecture
    • Instance Definition
    • Define SGA
    • Define Background Processes
    • Datafile Definition
  2. Query Optimizer
    • SQL Parsing
    • Optimizing Terms
    • Optimizing Methods
    • Query Plan Generation
    • Query Plan Control
  3. Tuning Container Databases and Pluggable Databases
    • Pluggable tuning parameters
    • Define Container tuning structure
    • Using PDB$SEED
    • Create a new PDB
    • Plug and unplug a PDB
  4. Oracle 12c Tuning features
    • Identifying and Using Oracle's Heat Map
    • 12c Compression Levels and Types
  5. Evaluating Execution Plans
    • Defining SQL execution plans
    • Automatic Workload Repository
    • Reading execution plans
  6. Oracle Tuning Tools
    • Monitoring tools overview
    • Enterprise Manager
    • Dynamic Performance Views
    • Automatic Workload Repository
    • Automatic Database Diagnostic Monitor
    • Sql Tuning Advisor
    • SQL Access Advisor
    • Sql Access Advisor
    • DB operation Tuning
    • DB operation Active Reporting
  7. Using Automatic Workload Repository
    • Defining AWR
    • AWR Settings
    • Creating AWR Baselines
  8. Metrics, Alerts, and Thresholds
    • Defining Metrics
    • Setting Alerts
    • Setting Corrective Actions
    • User Defined Metrics
    • Metric Dynamic Views
  9. Join Types
    • Nested Loops Join
    • Sort Merge join
    • Hash Join and Cartesian Join
    • Equijoins and Nonequijoins
    • Outer Joins
    • Semijoins
  10. AWR Using Baselines
    • Creating AWR baselines
    • Creating AWR Repeating baselines
    • Moving Window Baseline
  11. Additional AWR performance tools
    • Automatic Maintenance Tasks
    • Segment Advisor
    • Statistics Gathering
    • Automatic Tuning Optimizer
    • Automatic Database Diagnostic Monitor
    • Active Session History (ASH)
  12. Optimizer Statistics
    • Optimizer Statistics Overview
    • Table and Index Statistics
    • Statistic Preferences
    • Statistics Gathering
    • e) Locking Statistics, Export/Import Statistics
    • Pending and published statistics
    • Optimizer Hints
    • Optimizer Paths
    • Cost Base Optimization
  13. Monitoring a Service
    • Overview of what is an Oracle Service
    • Creating an Oracle Service for Single instance and RAC
    • Monitoring a Service
    • Resource Management and a Service
    • Enterprise Manager and a Service
  14. Bind Variables and database parameters
    • Bind variable definition
    • Cursor_sharing parameter
    • Adaptive Cursor Sharing
  15. Oracle's Real Application Testing (RAT)
    • Sql Performance Analyzer overview
    • Sql Performance Analyzer Options
    • Database Parameter changes
    • Database version changes
    • Creating SQL Tuning Sets
    • Database Replay Overview
    • Database Replay Configuration
    • Database Replay Options
  16. SQL Tuning Advisor
    • SQL Tuning Advisor: Overview
    • SQL Tuning Advisor Limited Mode
    • Sql Tuning Advisor Comprehensive mode
    • Sql Tuning Profiles
  17. SQL Access Advisor
    • SQL Access Advisor: Overview
    • Sql Access Advisor options
    • SQL Access Advisor and Sql Tuning Sets
    • Sql Access Advisor and AWR
    • Results and Implementation
  18. Automatic Sql Tuning
    • Automatic Sql Tuning Maintenance Task
    • Automatic Tuning Optimization implementation(ATO)
    • Automatic Tuning Optimization Results
    • Enable/Disable Automatic Tuning Optimization
  19. Sql Plan Management
    • Sql plan Management and baseline overview
    • Enable sql plan management
    • Loading Sql Plan baselines into the SGA
    • Adaptive plan management
  20. Shared Pool Tuning
    • Shared pool architecture
    • Shared pool parameters
    • Library Cache
    • Dictionary cache
    • Large pool considerations and contents
  21. Tuning the database buffer cache
    • Database buffer cache overview
    • Database buffer cache parameters
    • Oracle and Dirty reads and writes
    • Automatic Shared Memory Management (ASMM)
    • Buffer Cache goals and responsibility
    • Buffer Cache pools
  22. Tuning the PGA (Program Global Area)
    • PGA Overview
    • PGA Database Parameters
    • Temporary Segments
    • Temporary Tablespace
    • Sizing the PGA
  23. Automatic Memory Management (AMM)
    • Oracle's Automatic Memory Management Overview
    • Database Auto-tuned Parameters
    • Database Non Auto-tuned Parameters
    • Automatic Memory Management Hints and Sizing suggestions
    • AMM versus ASMM
  24. Tuning Segment Space Utilization (ASSM)
    • Overview of Automatic Segment Space Management
    • Defining the DB_BLOCK_SIZE
    • Defining DB_nk_CACHE_SIZE parameter
    • The DB_BLOCK_SIZE Parameter
    • Overview of table compression, block chaining, and block migration
  25. Automatic Storage Management
    • Overview of ASM
    • Definition of Grid Infrastructure
    • ASM Instance
    • ASM Diskgroups
    • ASM Diskgroup parameters and templates
    • ASMCMD

Course delivery details

Student Materials: Each participant will receive a Student Guide with course notes, code samples, software tutorials, step-by-step written lab instructions, diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Setup Made Simple. All course labs and solutions, data sets, Oracle software (limited version, for course use only), detailed courseware, lab guides and resources (as applicable) are provided for attendees in our easy access, no installation required, remote lab environment for the duration of the course. Our tech team will help set up, test and verify lab access for each attendee prior to the course start date, ensuring a smooth start to class and successful hands-on course experience for all participants.

Costs

  • Price: 2,795.00
  • Discounted Price: 1,816.75

Why choose Trivera Technologies LLC?

Over 25 years of technology training expertise.

Robust portfolio of over 1,000 leading edge technology courses.

Guaranteed to run courses and flexible learning options.

About Trivera Technologies LLC

Trivera Technologies

Trivera Technologies is a IT education services & courseware firm that offers a range of wide professional technical education services including: end to end IT training development and delivery, skills-based mentoring programs,new hire training and re-skilling services, courseware licensing and...


Read more and show all training delivered by this supplier

Contact this provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

Country *

Contact info

Trivera Technologies LLC

7862 West Irlo Bronson Highway
STE 626
Kissimmee FL 34747

 Show phone number
www.triveratech.com

Learn more!

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available