Oracle 10g/11g Database Administration II Part 2

Course Description

This Oracle online training course explains advanced Oracle database topics. Oracle 10g/11g Database Administration II Part 2 provides an in-depth look into Oracle’s advanced memory architecture, database advisors, and job scheduler. This training is designed for the experienced Oracle database administrator.

In order to take this course you need to have taken Oracle 10g/11g Database Administration I Part1 and Part 2, Oracle 10g/11g: Introduction to SQL, Oracle 10/11g: Advanced SQL, Oracle 11g PL/SQL Programming Part 1 and Part 2 or equivalent experience.

In This Course You Will Learn How To:

• Utilize the advance memory parameters of the Oracle database

• Use and understand the Database tuning advisors

• Use the Automatic Diagnostic Repository

• Use the Oracle job scheduler

• Configure the database for globalization support

Prerequisites

You need to have equivalent experience and have taken Oracle 10g/11g Database Administration II Part 1 or have taken the following courses:

• Oracle 10g/11g: Introduction to SQL

• Oracle 10g/11g: Advanced SQL

• Oracle 11g PL/SQL Programming Part 1

• Oracle 11g PL/SQL Programming Part 2

• Oracle 10g/11g Database Administration I Part 1

• Oracle 10g/11g Database Administration I Part 2

• Oracle 10g/11g Database Administration II Part 1

Outline

00: Oracle 10g/11g Database Administration II Part 2 Online Training - Course Introduction

 

01: Oracle Advanced Memory Management

• Oracles memory structure

• Initialization parameters

 

02: Automatic Memory Tuning

• Automatic Shared Memory Management (ASMM)

• Memory_Target

• SGA_TARGET

• Auto-tuned memory parameters

 

03: Program Global Area (PGA)

• Understanding the PGA

• Configuring automatic tuning for the PGA

 

04: Database Tuning

• Understand the advisor framework

• Define the contents of the automatic database advisors

• Lab: Advisor framework

 

05: Automatic Tuning Optimizer

• SQL tuning advisor

• SQL tuning sets

• SQL tuning tasks

 

06: Physical SQL Tuning

• SQL access advisor

• AWR

• ADDM

• SQL workloads

 

07: Database Impact Advisors

• SQL performance analyzer

• Database replay process

 

08: Memory Advisors

• Database memory advisors

• Mean time to recover advisors

• Undo management advisors

 

09: Oracle and Resumable Space

• Understanding resumable space

• Configuring the database for resumable space allocation

 

10: Reclaiming Space

• Reclaiming wasted spaced in tables

• Reclaiming wasted space in indexes

• Using the automatic segment advisor

 

11: Resource Management

• Understand the resource management architecture

• Determine allocation methods

 

12: Advanced Resource Management

• Understand the resource plans

• Create a resource plan

• Lab: Creating a resource group and plan

 

13: Database Diagnostics

• Understand the Automatic Diagnostic Repository(ADR)

• Create the ADR

• ADR contents

• ADR tools

 

14: Database Health Checkers

• Oracle support workbench

• Oracle health monitor

• Identify and correct block corruption

 

15: Database Recovery Advisors

• Benefits of using the Database Recovery Advisor (DRA)

• DRA features

• Using DRA

 

16: Oracle Job Scheduler

• Understand the job scheduler framework

• Program

• Job

• Schedule

• Window

• Lab: Creating a default schedule

 

17: Oracle Job Scheduling Options

• Time based jobs

• Event driven jobs

 

18: Oracle Jobs

• Oracle pre-defined jobs

• Oracle pre-defined windows

• Oracle maintenance tasks

 

19: Oracle Job Definitions

• Understanding job chains

• Dependant jobs

• Define and create job classes

• Define and create windows

• Job priorities

 

20: Oracle Globalization Support

• Define Oracle globalization support

• Creating a database that uses globalization support

• Database character sets

 

21: Time Zone Support

• Define time zone support

• Use Oracle locale builder

• Support for databases in different time zones

 

22: Oracle 10g/11g Database Administration II Part 2 Online Training - Course Summary