Oracle 19c Database Tuning (TTOR21519)

Instance Definition

Define SGA

Define Background Processes

Datafile Definition

SQL Parsing

Optimizing Terms

Optimizing Methods

Query Plan Generation

Query Plan Control

Pluggable tuning parameters

Define Container tuning structure

Using PDB$SEED

Create a new PDB

Plug and unplug a PDB

Identifying and Using Oracle's Heat Map

12c Compression Levels and Types

Defining SQL execution plans

Automatic Workload Repository

Reading execution plans

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

Defining AWR

AWR Settings

Creating AWR Baselines

Defining Metrics

Setting Alerts

Setting Corrective Actions

User Defined Metrics

Metric Dynamic Views

Nested Loops Join

Sort Merge join

Hash Join and Cartesian Join

Equijoins and Nonequijoins

Outer Joins

Semijoins

Creating AWR baselines

Creating AWR Repeating baselines

Moving Window Baseline

Automatic Maintenance Tasks

Segment Advisor

Statistics Gathering

Automatic Tuning Optimizer

Automatic Database Diagnostic Monitor

Active Session History (ASH)

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

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 variable definition

Cursor_sharing parameter

Adaptive Cursor Sharing

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: Overview

SQL Tuning Advisor Limited Mode

Sql Tuning Advisor Comprehensive mode

Sql Tuning Profiles

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 Maintenance Task

Automatic Tuning Optimization implementation(ATO)

Automatic Tuning Optimization Results

Enable/Disable Automatic Tuning Optimization

Sql plan Management and baseline overview

Enable sql plan management

Loading Sql Plan baselines into the SGA

Adaptive plan management

Shared pool architecture

Shared pool parameters

Library Cache

Dictionary cache

Large pool considerations and contents

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

PGA Overview

PGA Database Parameters

Temporary Segments

Temporary Tablespace

Sizing the PGA

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

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

Overview of ASM

Definition of Grid Infrastructure

ASM Instance

ASM Diskgroups

ASM Diskgroup parameters and templates

ASMCMD