Oracle 10g/11g Database Administration II Part 2

View Your Course Transcript

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

Your Price: $695

Video Title	Minutes
00: Course Introduction	6
01: Oracle Advanced Memory Management	15
02: Automatic Memory Tuning	13
03: Program Global Area (PGA)	17
04: Database Tuning	23
05: Automatic Tuning Optimizer	13
06: Physical SQL Tuning	19
07: Database Impact Advisors	18
08: Memory Advisors	18
09: Oracle and Resumable Space	19
10: Reclaiming Space	21
11: Resource Management	11
12: Advanced Resource Management	19
13: Database Diagnostics	16
14: Database Health Checkers	15
15: Database Recovery Advisors	15
16: Oracle Job Scheduler	14
17: Oracle Job Scheduling Options	12
18: Oracle Jobs	17
19: Oracle Job Definitions	14
20: Oracle Globalization Support	15
21: Time Zone Support	11
22: Course Summary	5
Total:	5 hours 46 minutes

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

Your Price: $695

Course Materials

Want to be able to access these helpful materials? Contact Us!

• Student Guide
• Exercise Guide

Related Links

• Course Survey
• Oracle Certification Requirements
• Exam Pricing and Locations

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

List Price: $995 Your Price: $695

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.

Objectives

As a result of taking this Oracle online training, you will be able 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

Related Training

• Course: Oracle 10g/11g Database Administration I Part 1
• Course: Oracle 10g/11g Database Administration II Part 2
• Course: Oracle 10g/11g Database Administration II Part 1

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

List Price: $995 Your Price: $695

Oracle 10g/11g Database Administration II Part 2 Outline

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

Module 01: Oracle Advanced Memory Management
• Oracles memory structure
• Initialization parameters

Module 02: Automatic Memory Tuning
• Automatic Shared Memory Management (ASMM)
• Memory_Target
• SGA_TARGET
• Auto-tuned memory parameters

Module 03: Program Global Area (PGA)
• Understanding the PGA
• Configuring automatic tuning for the PGA

Module 04: Database Tuning
• Understand the advisor framework
• Define the contents of the automatic database advisors
• Lab: Advisor framework

Module 05: Automatic Tuning Optimizer
• SQL tuning advisor
• SQL tuning sets
• SQL tuning tasks

Module 06: Physical SQL Tuning
• SQL access advisor
• AWR
• ADDM
• SQL workloads

Module 07: Database Impact Advisors
• SQL performance analyzer
• Database replay process

Module 08: Memory Advisors
• Database memory advisors
• Mean time to recover advisors
• Undo management advisors

Module 09: Oracle and Resumable Space
• Understanding resumable space
• Configuring the database for resumable space allocation

Module 10: Reclaiming Space
• Reclaiming wasted spaced in tables
• Reclaiming wasted space in indexes
• Using the automatic segment advisor

Module 11: Resource Management
• Understand the resource management architecture
• Determine allocation methods

Module 12: Advanced Resource Management
• Understand the resource plans
• Create a resource plan
• Lab: Creating a resource group and plan

Module 13: Database Diagnostics
• Understand the Automatic Diagnostic Repository(ADR)
• Create the ADR
• ADR contents
• ADR tools

Module 14: Database Health Checkers
• Oracle support workbench
• Oracle health monitor
• Identify and correct block corruption

Module 15: Database Recovery Advisors
• Benefits of using the Database Recovery Advisor (DRA)
• DRA features
• Using DRA

Module 16: Oracle Job Scheduler
• Understand the job scheduler framework
• Program
• Job
• Schedule
• Window
• Lab: Creating a default schedule

Module 17: Oracle Job Scheduling Options
• Time based jobs
• Event driven jobs

Module 18: Oracle Jobs
• Oracle pre-defined jobs
• Oracle pre-defined windows
• Oracle maintenance tasks

Module 19: Oracle Job Definitions
• Understanding job chains
• Dependant jobs
• Define and create job classes
• Define and create windows
• Job priorities

Module 20: Oracle Globalization Support
• Define Oracle globalization support
• Creating a database that uses globalization support
• Database character sets

Module 21: Time Zone Support
• Define time zone support
• Use Oracle locale builder
• Support for databases in different time zones

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

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

List Price: $995 Your Price: $695

Prerequisites

You need to have equivalent experience and have taken Oracle 10g/11g Database Administrtion II Part 1 or have taken the following GogoTraining 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

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

List Price: $995 Your Price: $695

System Requirements

Hardware:

• Windows XP or above
• 32-bit or 64-bit Processor
• 2 GB RAM minimum, 4 GB RAM preferred
• 10 GB free disk space

or

• Linux: Red Hat Linux, Oracle Linux, SUSE, or Ubuntu
• 32-bit or 64-bit Processor
• 2 GB RAM minimum, 4 GB RAM preferred
• 10 GB free disk space

Software:

Detailed set up will be provided with the course.

• Oracle Database Enterprise Edition
• Oracle 11g Release 2 for the appropriate operating system
• Oracle 11g Release 2 Grid infrastructure for appropriate operating system (Grid infrastructure software is not available for a Windows based system) 

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

List Price: $995 Your Price: $695

Certification

Oracle 10g/11g Database Administration II Part 2 is part of a two-course online training series that helps you to prepare for Oracle's exam 1Z0-053. This course maps to Oracle's course, Oracle Database 11g: Administration II. When you pass exam 1Z0-053, you have completed a portion of the requirements towards the Oracle Database 11g Administrator Certified Associate certification.

For more information about Oracle certification, pricing and locations for exams, select the link in the related link section.

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration II Part 2 Today!

List Price: $995 Your Price: $695

When you purchase a course from GogoTraining, you can submit comments or questions to our expert instructors.