Oracle Database 11g for Experienced 9i Database Administrators — A 5-Day Course

 Open Public Course Closed In-House Course

Synopsis

This course is aimed at database administrators of small sized databases who need to carry out basic administration tasks on an Oracle 11g database. The focus is on using Enterprise Manager to teach delegates how to manage the database.

Delegates will be able to utilise the knowledge and skills gained to maintain successful and efficient day-to-day operations of Oracle Database 11g. The course will give experienced Oracle 9i database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g. Database administrators will gain a practical understanding of the new features of Oracle Database 11g and how these can be implemented in their current Oracle installations.

Objectives

The delegate will practise:

• Installing Oracle Database 11g Software
• Creating an Oracle Database Using New Features
• Upgrading a Database to 11g Release 1
• Using the New Enterprise Manager
• Proactively Monitoring with Database Advisors
• Using New Memory Management Features
• Using New Data Storage Features
• Using Automatic Storage Management
• Using New Space Management Features
• Using New Optimizer and Index Features
• Using New SQL and PL/SQL Features
• Using the Data Pump Utility
• Using New Backup and Recovery Features
• Using New Availability Features
• Using New Security Features
• Automating Tasks with the New Scheduler
• Using Real Application Testing
• Using Database Replay to Capture, Process and Replay Workloads
• Using the Data Recovery Advisor and Flashback
• Managing Transactions using Flashback and LogMiner
• Using Performance Tuning New Features
• Implementing New Schema Management Functionality

Suitable For

This course is intended for:

• Database administrators who need to update their current Oracle 9i skills to create, administer, monitor, backup and support Oracle Database 11g.

Prerequisites

Delegates should have a good understanding of Oracle 9i Database Administration.

Publicly scheduled dates, locations, and prices

Outline Course Contents

New Management Features

• Log File Changes
• Parameter File Management Changes
• New Memory Management Features
• Memory Advisor Views
• New Management Parameters

Installing Oracle Database 11g

• System Hardware requirements
• Installing Oracle Database 11g
• The Database Configuration Assistant
• Database Templates
• Hot Patching

Upgrading to Oracle Database 11g

• Upgrading to Oracle Database 11g
• Oracle Parameter Changes
• Altered Parameter Behaviour
• Online Dictionary View Changes

Administer a Database

• Administrative Tools Available to a DBA
• Use Oracle Enterprise Manager to Manage a Database
• Stop and Start the EM Database Console
• Access Oracle Enterprise Manager
• Grant EM Administrative Privileges

New Database Storage Features

• Default Permanent Tablespace
• Rename a Tablespace
• The SYSAUX Tablespace
• Copy Files Using the Database Server
• Drop an Empty Datafile
• Tablespace Monitoring
• Segment Management Enhancements
• Segment Advisor
• Segment Resource Estimation
• On Line Segment Shrink
• Proactive Tablespace Management
• Automatic Undo Retention

Security Enhancements

• Connect Role Change
• Default Passwords
• Case Sensitive Passwords
• Profiles and the Password Verify Function
• Virtual Private Database Enhancements
• Auditing Enhancements
• OS Audit in XML Format
• Uniform Audit Trail
• Default Auditing in Oracle Database 11g
• DBMS_CRYPTO
• Transparent Data Encryption
• Transparent Tablespace Encryption
• Data Masking
• Security and OEM

Automatic Database Management

• Automatic Workload Repository
• AWR 11g New Features
• Automatic Database Diagnostic Monitor
• ADDM 11g New Features
• ADDM Reports
• DBMS_ADVISOR Reports
• DBMS_ADVISOR Views
• Alerts

Automating Tasks with the Scheduler

• Scheduler Overview
• DBMS_SCHEDULER
• Scheduler Related Parameters
• Access Rights
• Create a Program
• Enable a Program
• Drop a Program
• Create a Schedule
• Create a Job
• Job Classes
• Resource Windows
• Window Group
• Events and Chains
• Chains
• Monitoring and Logging
• AutoTask

Schema Management New Features

• DDL Wait Option
• Add Columns with a Default Value
• Virtual Columns
• Invisible Indexes
• Improved Online Index Creation and Rebuild
• Read Only Tables

Application Development New Features

• Append, Create and Replace Extensions to Spool/Save
• SQL*Plus Errorlog Table
• Lock Table Parameter
• SQL Query Result Cache
• Client Side Result Cache
• PL/SQL Function Cache

Utilities for Troubleshooting Data Corruption

• Automatic Block Corruption Reporting
• Automatic Quarantine of Corrupt Undo Segments
• Protection from Data Corruptions
• Improvements to ANALYZE ... VALIDATE STRUCTURE
• Proactive Monitoring with the Health Monitor

Backup and Recovery New Features

• Recovery Through Reset Logs
• Changes to ALTER DATABASE ARCHIVELOG
• Recovery Manager Enhancements

Data Recovery Advisor

• Overview of Data Recovery Advisor
• Use the Data Recovery Advisor through the RMAN Command Line
• Run Pro-Active Health Checks with the Validate Command
• Use the Data Recovery Advisor through EM
• Data Recovery Advisor Dictionary Views

Automatic Storage Management

• Overview of ASM
• ASM Instance Creation
• SYSASM Role
• Administer ASM Disk Groups
• ASM Files
• ASM Startup and Shutdown
• ASM Disk Failure
• ASM Data Dictionary Tables
• Migrate a Database to ASM Using RMAN
• The ASM Command Line Tool

Database Replay

• Overview of Database Replay
• The Database Replay Pro
• Capture a Workload
• Pre-process the Captured Workload
• Replay the Workload
• Database Replay Usage
• The DBMS_WORKLOAD Package

Data Pump

• The exp Utility Deprecated
• Introduction to Data Pump Import and Export
• Data Pump Architecture
• Data Pump Export
• Data Pump Import

Data Guard New Features

• Apply Redo in Real Time
• Redo Transmission Enhancements
• New Standby Database Parameters
• ARCH Process Writes to Standby Redo Logs
• Changes to Standby Database Startups
• Logical Standby Database Enhancements
• Fast Start Failover Enhancements
• Archive Redo Log Compression
• Lost Write Detection
• Real Time Query Capable Physical Standby Database
• Rolling Upgrades to Physical Standby
• SQL Apply Logical Standby
• RMAN and Data Guard
• Snapshot Standby Databases
• Clone a Running Database

Oracle Database Advisors

• Repair Advisors and Fault Diagnostics
• The SQL Repair Advisor
• The SQL Access Advisor
• The Streams Performance Advisor
• The Advisor Views

Flashback

• Flashback Query
• Flashback Version Query
• Flashback Table
• Flashback Transaction Query
• Flashback Drop
• Flashback Database
• Flashback Restore Points
• Flashback Transaction Backout
• Flashback Data Archive

Diagnostics New Features

• Oracle Database 11g Fault Diagnostic Automation
• Automatic Diagnostic Workflow
• Problems and Incidents
• Incident Packaging Service
• EM Support Workbench Overview

Performance Tuning New Features

• Rule Based Optimizer Obsolescence
• Automatic Statistics Collection
• Improved Statistics Gathering
• Direct SGA Access
• Application and SQL Tuning
• SQL Tuning Advisor
• SQL Access Advisor
• Real-Time SQL Monitoring Report
• SQL Performance Analyzer
• Intelligent Cursor Sharing
• SQL Plan Management
• Temporary Tablespace Shrink
• Test Case Builder
• New Hints
• Data Warehouse and BI New Features
• Partitioning Enhancements
• Materialized View and Query Rewrite Enhancements
• The PIVOT and UNPIVOT Clauses
• Data Compression

Data Warehouse and BI New Features

• Partitioning Enhancements
• Materialized View and Query Rewrite Enhancements
• The PIVOT and UNPIVOT Clauses
• Data Compression