ORACLE DATABASE: PERFORMANCE MANAGEMENT AND TUNING

ORACLE DATABASE: PERFORMANCE MANAGEMENT AND TUNING

Summary

Location

Location

Malaysia

Duration

Duration

5 Days
Format

Format

Public Class

Public Class

Unleash Your Potential with Oracle Database: Performance Management and Tuning

Are you ready to supercharge your career in the world of technology and database management? Dive into the dynamic universe of Oracle Database with our comprehensive course on “Oracle Database: Performance Management and Tuning.”

Mastering the Art of Oracle Database

In this engaging and hands-on 5-day course, you will embark on a journey that delves deep into the heart of Oracle Database performance management. From understanding the essential Oracle Database structures to fine-tuning SQL statements and optimizing system performance, this course equips you with the skills and knowledge necessary to excel in the world of database administration.

A Game-Changer for Your Career

For administrators and database enthusiasts, this course is a game-changer. It empowers you to take charge of Oracle Database performance, making you an invaluable asset to any organization. The course covers everything from performance diagnostics and SQL optimization to real-time database monitoring. By the end, you’ll be equipped to tackle any database performance issue with confidence, paving the way for career growth and success in the ever-evolving tech landscape.

Join us on this transformative journey into the heart of Oracle Database management, and unlock a world of career opportunities and possibilities. Don’t just learn—excel with Info Trek!

Course Details

Duration: 5 Days; Instructor-led

Audience

  • Administrator
  • Database Administrator

Prerequisites

  • Oracle Database 12c: Install and Upgrade Workshop Ed 1

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

Course Objectives

In this course, you will learn to:

  • Describe Performance Management
  • Use AWR Performance Statistics
  • Use AWR Based Tools
  • Improve SQL Statement Performance
  • Influence the Optimizer.
  • Use Tuning Analysers and Advisors
  • Monitor Operations and applications
  • Manage Memory
  • Manage Database Memory
  • Use In-Memory Column Store Feature

Outlines

  • Overview
  • Practice 1-1: Preparing the databases
  • Defining the scope of performances issues objectives
  • Tuning life cycle phases
  • Practice 2-1: using enterprise manager to identify OS issues.
  • Using the time model to diagnose performance issues.
  • Practice 3-1: Viewing the top wait events and the time model.
  • Using statistics and wait events to diagnose performance issues.
  • Insurance activity and wait event statistics.
  • Practice 4-1: viewing system statistics and wait events.
  • Using log and trace files to monitor performance.
  • Practice 5-1: viewing performance information in the alert log.
  • 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
  • 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).
  • 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 and AWR report.
  • Practice 1-3: generating and viewing a compare period report.
  • Using metrics and alerts
  • Practice 2-1: setting up and viewing server-generated alerts.
  • Using Baselines
  • Managing Automated Maintenance Tasks
  • Practice 1-1: Configuring Automatic Maintenance Tasks (Part 1)
  • Practice 1-1: Configuring Automatic Maintenance Tasks (Part 2)
  • 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
  • Using Active Session History Data for First Fault System Analysis
  • Practice 3-1: Generating and Reviewing an ASH Report to Identify Performance Issues
  • Using Emergency Monitoring and Real-Time ADDM to Analyze Performance
  • Overview
  • Processing a DML Statement
  • Maintaining Indexes
  • Automatic Indexing Task
  • Practice 2-1: Coalescing an Index
  • Maintaining Tables
  • Block Space Management with Free Lists
  • Shrinking Segments: Overview
  • Advanced Index Compression
  • Practice 3-1: Analyzing the Impact of Excess Blocks
  • Introduction
  • Using Initialization Parameters to Control Optimizer Behavior
  • Understanding Execution Plans
  • SQL*Plus AUTOTRACE
  • Practice 2-1: Using AUTOTRACE and EXPLAIN PLAN
  • Viewing Execution Plans by Using SQL Trace and TKPROF
  • Practice 3-1: Using SQL TRACE and the TKPROF Utility
  • 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
  • Using Automatic SQL Tuning
  • Using the SQL Plan Management Feature
  • Practice 6-1: Using SQL Plan Management (Part 1)
  • Practice 6-1: Using SQL Plan Management (Part 2)
  • Overview of the SQL Advisors
  • Using the SQL Tuning Advisor
  • Practice 2-1: Using the SQL Tuning Advisor
  • Using the SQL Access Advisor
  • Practice 3-1: Using the SQL Access Advisor to Improve SQL Performance
  • Overview of Real Application Testing Components
  • 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
  • Using Database Replay to Test System Performance
  • Database Replay Packages
  • Practice 3-1: Configuring and Using Database Replay at the PDB Level
  • Implementing Real-Time Database Operation Monitoring
  • Practice 1-1: Monitoring a Composite Database Operation
  • Practice 1-2: Monitoring a PL/SQL Operation
  • 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
  • Practices for Lesson 1: Overview
  • 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
  • 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
  • Managing PGA and Temporary Space Performance
  • Monitoring SQL Memory Usage
  • Practice 4-1: Adjusting the Value of PGA_AGGREGATE_TARGET
  • Configuring the Large Pool
  • Using Automatic Shared Memory Management
  • Using the V$SYSTEM_PARAMETER View
  • Practice 6-1: Enabling Automatic Shared Memory Management
  • 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
  • Using In-Memory Column Store with Oracle Database Features
  • Practice 4-1: Exporting and Importing In-Memory Objects

Trainers

Reviews

Interested In

ORACLE DATABASE: PERFORMANCE MANAGEMENT AND TUNING

Starting From
RM6500
Intake Date
18-22 MAR 2024
,
10-14 JUNE 2024
,
9-13 SEPT 2024
,
2-6 DEC 2024
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: ORACLE DATABASE: PERFORMANCE MANAGEMENT AND TUNING
Duration: 5 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *