Centralino: 0571 997787

Numero attivo in orario lavorativo

Oracle Autorized Education Center

ORACLE DATABASE 19C: PERFORMANCE MANAGEMENT AND TUNING

Durata

5 Giorni

Ruolo

Administrator, Database Administrator, Solution Architect, System Administrator

Tecnologie

Cloud, Database, Networking

Vendor

Oracle

Al momento non sono disponibili edizioni del corso

2,885.00

Dettagli

OBIETTIVI

  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database

PREREQUISITI

Suggested Prerequisites

  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts

 

Required Prerequisites

  • Oracle Database Administration
  • Basic knowledge of Linux operating system
  • A working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

CONTENUTI:

1: Overview

  • Overview
  • Practice 1-1: Preparing the Databases

 

2: Defining the Scope of Performance Issues

  • Defining the Scope of Performance Issues Objectives
  • Tuning Life Cycle Phases
  • Practice 2-1: Using Enterprise Manager to Identify OS Issues

 

3: Using the Time Model to Diagnose Performance Issues

  • Using the Time Model to Diagnose Performance Issues
  • Practice 3-1: Viewing the Top Wait Events and the Time Model

 

4: Using Statistics and Wait Events to Diagnose Performance Issues

  • Using Statistics and Wait Events to Diagnose Performance Issues
  • Instance Activity and Wait Event Statistics
  • Practice 4-1: Viewing System Statistics and Wait Events

 

5: Using Log and Trace Files to Monitor Performance

  • Using Log and Trace Files to Monitor Performance
  • Practice 5-1: Viewing Performance Information in the Alert Log

 

6: Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance

  • Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
  • Practice 6-1: Using Enterprise Manager to Monitor Performance
  • Practice 6-2: Using SQL Developer to Monitor Performance Part 1
  • Practice 6-2: Using SQL Developer to Monitor Performance Part 2

 

7: Using Statspack to View Performance Data

  • Using Statspack to View Performance Data
  • Practice 7-1: Installing Statspack
  • Practice 7-2: Creating Snapshots
  • Practice 7-3: Generating Statspack Reports
  • Practice 7-4: Using Statspack to Examine Segment Statistics (Optional)

 

8: Using Automatic Workload Repository

  • Using Automatic Workload Repository
  • Managing AWR Data in a Multitenant Environment
  • Practice 1-1: Creating and Managing AWR Snapshots
  • Practice 1-2: Generating and Viewing an AWR Report
  • Practice 1-3: Generating and Viewing a Compare Periods Report

 

9: Using Metrics and Alerts

  • Using Metrics and Alerts
  • Practice 2-1: Setting Up and Viewing Server-Generated Alerts

 

10: Using Baselines

  • Using Baselines

 

11: Managing Automated Maintenance Tasks

  • Managing Automated Maintenance Tasks
  • Practice 1-1: Configuring Automatic Maintenance Tasks (Part 1)
  • Practice 1-1: Configuring Automatic Maintenance Tasks (Part 2)

 

12: Using ADDM to Analyze Performance

  • Using ADDM to Analyze Performance
  • Compare Periods ADDM: Analysis
  • Practice 2-1: Using AWR-Based Tools to Identify Performance Issues
  • Practice 2-2: Performing an ADDM Analysis of a PDB

 

13: Using Active Session History Data for First Fault System Analysis

  • Using Active Session History Data for First Fault System Analysis
  • Practice 3-1: Generating and Reviewing an ASH Report to Identify Performance Issues

 

14: Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues

  • Using Emergency Monitoring and Real-Time ADDM to Analyze Performance

 

15: Overview of SQL Statement Processing

  • Overview
  • Processing a DML Statement

 

16: Maintaining Indexes

  • Maintaining Indexes
  • Automatic Indexing Task
  • Practice 2-1: Coalescing an Index

 

17: Maintaining Tables

  • Maintaining Tables
  • Block Space Management with Free Lists
  • Shrinking Segments: Overview
  • Advanced Index Compression
  • Practice 3-1: Analyzing the Impact of Excess Blocks

 

18: Introduction to Query Optimizer

  • Introduction
  • Using Initialization Parameters to Control Optimizer Behavior

 

19: Understanding Execution Plans

  • Understanding Execution Plans
  • SQL*Plus AUTOTRACE
  • Practice 2-1: Using AUTOTRACE and EXPLAIN PLAN

 

20: Viewing Execution Plans by Using SQL Trace and TKPROF

  • Viewing Execution Plans by Using SQL Trace and TKPROF
  • Practice 3-1: Using SQL TRACE and the TKPROF Utility

 

21: Managing Optimizer Statistics

  • Managing Optimizer Statistics
  • Extended Statistics
  • Practice 4-1: Capturing Extended Statistics
  • Practice 4-2: Determining the Impact of Stale Statistics
  • Practice 4-3: Using the Optimizer Statistics Advisor to Improve Statistics Collection Quality

 

22: Using Automatic SQL Tuning

  • Using Automatic SQL Tuning

 

23: Using the SQL Plan Management Feature

  • Using the SQL Plan Management Feature
  • Practice 6-1: Using SQL Plan Management (Part 1)
  • Practice 6-1: Using SQL Plan Management (Part 2)

 

24: Overview of the SQL Advisors

  • Overview of the SQL Advisors

 

25: Using the SQL Tuning Advisor

  • Using the SQL Tuning Advisor
  • Practice 2-1: Using the SQL Tuning Advisor

 

26: Using the SQL Access Advisor

  • Using the SQL Access Advisor
  • Practice 3-1: Using the SQL Access Advisor to Improve SQL Performance

 

27: Overview of Real Application Testing Components

  • Overview of Real Application Testing Components

 

28: Using SQL Performance Analyzer to Determine the Impact of Changes

  • Using SQL Performance Analyzer to Determine the Impact of Changes
  • Practice 2-1: Using SQL Performance Analyzer (Part 1)
  • Practice 2-1: Using SQL Performance Analyzer (Part 2)
  • Practice 2-2: Seeding SQL Plan Baselines from SQL Performance Analyzer

 

29: Using Database Replay to Test System Performance

  • Using Database Replay to Test System Performance
  • Database Replay Packages
  • Practice 3-1: Configuring and Using Database Replay at the PDB Level

 

30: Implementing Real-Time Database Operation Monitoring

  • Implementing Real-Time Database Operation Monitoring
  • Practice 1-1: Monitoring a Composite Database Operation
  • Practice 1-2: Monitoring a PL/SQL Operation

 

31: Using Services to Monitor Applications

  • Using Services to Monitor Applications
  • Creating Services
  • Service Aggregation Configuration
  • Practice 2-1: Using Services in a Single-Instance Oracle Database (Part 1)
  • Practice 2-1: Using Services in a Single-Instance Oracle Database (Part 2)
  • Practice 2-2: Tracing Services in a Single-Instance Environment

 

32: Overview of Memory Structures

  • Overview
  • Practices for Lesson 1: Overview

 

33: Managing Shared Pool Performance

  • Managing Shared Pool Performance
  • Avoid Hard Parses
  • Sizing the Shared Pool
  • Practice 2-1: Sizing the Shared Pool
  • Practice 2-2: Tuning a Hard-Parse Workload
  • Practice 2-3: Tuning a Soft-Parse Workload
  • Practice 2-4: Keeping Objects in the Shared Pool

 

34: Managing Buffer Cache Performance

  • Managing Buffer Cache Performance
  • Buffer Cache Hit Ratio
  • Caching Tables
  • Multiple Block Sizes
  • Practice 3-1: Sizing the Buffer Cache
  • Practice 3-2: Using the Keep Pool
  • Practice 3-3: Using Force Full Database Caching

 

35: Managing PGA and Temporary Space Performance

  • Managing PGA and Temporary Space Performance
  • Monitoring SQL Memory Usage
  • Practice 4-1: Adjusting the Value of PGA_AGGREGATE_TARGET

 

36: Configuring the Large Pool

  • Configuring the Large Pool

 

37: Using Automatic Shared Memory Management

  • Using Automatic Shared Memory Management
  • Using the V$SYSTEM_PARAMETER View
  • Practice 6-1: Enabling Automatic Shared Memory Management

 

38: Introduction to In-Memory Column Store

  • Introduction

 

39: Configuring the In-Memory Column Store Feature

  • Configuring the In-Memory Column Store Feature
  • Practice 2-1: Configuring In-Memory Column Store
  • Practice 2-2: Configuring In-Memory Objects
  • Practice 2-3: Querying In-Memory Objects and Viewing Execution Plans

 

40: Using In-Memory Column Store with Oracle Database Features

  • Using In-Memory Column Store with Oracle Database Features
  • Practice 4-1: Exporting and Importing In-Memory Objects

EDU.Labs by Computer Gross
Via del Pino 1 - 50053 Empoli (FI) - Italia - P. I. 04801490485 - C.F. 02500250168
info@educationlabs.it | 0571 997787