Name: Oracle 19c Database Tuning (TTOR21519)
Availability: InStock
Rating: 4.6 (5878 reviews)

Duration:

40.00 hours

32.5 CPD hours

Overview:

Dive into the world of database optimization with our hands-on Oracle 19c Database Tuning course. Aimed at entry-level learners, this course is designed to provide an in-depth understanding of data management and manipulation techniques. With an understanding of Oracle Database Tuning, you can contribute significantly to the efficiency of your organization's data infrastructure and the successful execution of data-driven strategies.

Description:

Dive into the world of database optimization with our hands-on Oracle 19c Database Tuning course. Aimed at entry-level learners, this course is designed to provide an in-depth understanding of data management and manipulation techniques. With an understanding of Oracle Database Tuning, you can contribute significantly to the efficiency of your organization's data infrastructure and the successful execution of data-driven strategies.
Our five-day course, led by an Oracle Certified instructor, combines interactive lectures, engaging discussions, and practical lab activities. Topics covered include Oracle Database Architecture, Query Optimizer, Oracle's Tuning Features, Container and Pluggable Databases, and Oracle's Real Application Testing (RAT) among others. About half of the course time is devoted to hands-on lab exercises, where you'll apply your newly learned skills in real-life scenarios. The labs provide you with the opportunity to perform tasks like optimizing queries, setting up and tuning databases, and using tools like the SQL Tuning Advisor and Automatic Workload Repository.
Upon completion of this course, you'll be equipped to optimize queries, manage databases efficiently, utilize Oracle's Heat Map, monitor a service, and use the Automatic Workload Repository (AWR). These critical skills enable you to maintain high-performing databases that are crucial to your organization's operations.

Course Outline:

Overview Oracle Database Architecture
Instance Definition
Define SGA
Define Background Processes
Datafile Definition
Query Optimizer
SQL Parsing
Optimizing Terms
Optimizing Methods
Query Plan Generation
Query Plan Control
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
Oracle Tuning features
Identifying and Using Oracle's Heat Map
19c Compression Levels and Types
Evaluating Execution Plans
Defining SQL execution plans
Automatic Workload Repository
Reading execution plans
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
Using Automatic Workload Repository
Defining AWR
AWR Settings
Creating AWR Baselines
Metrics, Alerts, and Thresholds
Defining Metrics
Setting Alerts
Setting Corrective Action
User Defined Metrics
Metric Dynamic Views
Join Types
Nested Loops Join
Sort Merge join
Hash Join and Cartesian Join
Equijoins and Nonequijoins
Outer Joins
Semijoins
AWR Using Baselines
Creating AWR baselines
Creating AWR Repeating baselines
Moving Window Baseline
Additional AWR performance tools
Automatic Maintenance Tasks
Segment Advisor
Statistics Gathering
Automatic Tuning Optimizer
Automatic Database Diagnostic Monitor
Active Session History (ASH)
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
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
Bind Variables and database parameters
Bind variable definition
Cursor_sharing parameter
Adaptive Cursor Sharing
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
SQL Tuning Advisor
SQL Tuning Advisor: Overview
SQL Tuning Advisor Limited Mode
Sql Tuning Advisor Comprehensive mode
Sql Tuning Profiles
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
Automatic Sql Tuning
Automatic Sql Tuning Maintenance Task
Automatic Tuning Optimization implementation(ATO)
Automatic Tuning Optimization Results
Enable/Disable Automatic Tuning Optimization
Sql Plan Management
Sql plan Management and baseline overview
Enable sql plan management
Loading Sql Plan baselines into the SGA
Adaptive plan management
Shared Pool Tuning
Shared pool architecture
Shared pool parameters
Library Cache
Dictionary cache
Large pool considerations and contents
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
Tuning the PGA (Program Global Area)
PGA Overview
PGA Database Parameters
Temporary Segments
Temporary Tablespace
Sizing the PGA
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
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
Automatic Storage Management
Overview of ASM
Definition of Grid Infrastructure
ASM Instance
ASM Diskgroups
ASM Diskgroup parameters and templates
ASMCMD

Available Delivery Options for Oracle 19c Database Tuning (TTOR21519)

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does Oracle 19c Database Tuning (TTOR21519) provide?

The 5 day Oracle 19c Database Tuning (TTOR21519) course gives you up to 32.5 CPD hours/structured learning hours.

Who is the correct audience for Oracle 19c Database Tuning (TTOR21519)?

This course is geared for professionals seeking a solid foundation in database management and optimization. The training is perfect for experiences database administrators / DBAs, data analysts, and software developers who are involved in data-intensive operations or wish to enhance their skills in database tuning.

Do you provide training for Oracle 19c Database Tuning (TTOR21519)?

Yes, we provide corporate training, dedicated training and closed classes for Oracle 19c Database Tuning (TTOR21519). This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Oracle 19c Database Tuning (TTOR21519)?

The Oracle 19c Database Tuning (TTOR21519) training takes place over 5 day(s), with each day lasting approximately 40.00 hours including breaks.

What other terms do people search for?

Popular related searches include: Oracle DBA; Database; Tuning

Why are Nexus Human the best provider for Oracle 19c Database Tuning (TTOR21519)?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for Oracle 19c Database Tuning (TTOR21519)?

Yes, the discount code PENPAL5 is currently available for Oracle 19c Database Tuning (TTOR21519) training. Only one discount code can be used per booking.

Oracle 19c Database Tuning (TTOR21519)