On-line training course catalogue

Oracle 10g Database: New Features for Administrators

Type of course: Classroom

Course details

Fee	£2100
Days	5
Course code	OR10GNFA

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

This course is now run on Release 2

• Click here for dates and details

Overview

Please note that Oracle courses running at London training centres are subject to a 5% surcharge.

This course introduces students to the new features in Oracle Database 10g – the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.

Outline

Introduction

How DBAs Spend Their Time

Oracle Database 10g Manageability Goals

Oracle Database 10g Solution: Self-Managing Database

Grid Computing

Oracle Database 10g: The Database for the Grid

Installation

Installation Performance Enhancements

Installation New Feature Support

Automatic pre & post install validations

CD pack contents

Server Configuration

Database Features Usage Tracking

Automatic Enterprise Manager Configuration

Simplified Initialization Parameters

Simplified Database Install

Load and Unload Data

Cross-platform Transportable Tablespaces

External Tables Unload

DataPump Export and Import Utilities

Automatic Management

Automatic Checkpoint Tuning

Automatic Database Diagnostic Monitor

Automatic Shared Memory Tuning

Automatic Optimizer Statistics Collection

Automatic Undo Retention

Manageability Infrastructure

Advisory Framework

Automatic Routine Administration Tasks

Server-generated Alerts / Threshold-based Alerts

Automatic Workload Repository

Application Management and Availability

SQL Access Advisor

SQL Tuning Advisor

New performance overview charts in EM

Rule-based optimization (RBO) obsolescence

SQL Support for Analytical Applications

MERGE Command Enhancements

Partitioned Outer Join

Integrating Interrow Calculations in SQL

Summary Management Enhancements

System Resource Management

Setting Idle Timeouts

Switching Back to the Initial Consumer Group at End of Call

Database Resource Manager – Adaptive Consumer Group Mapping

Monitoring the Resource Manager

The Scheduler

Core Scheduler Features

Privileges for Scheduler Components

Calendaring Expressions

Advanced Scheduler Concepts

Space Management

Segment Advisor

New Segment Resource Estimation

Online Segment Shrink

Proactive Tablespace Management

Undo Advisor

Sorted Hash Clusters

Improved VLDB Support

Bigfile Tablespace

Enhanced Partition Management in Enterprise Manager

Global Partitioned Indexes – Hash Partitioning

Local Partitioned Indexes Manageability Improvements

Temporary tablespace groups

RMAN Enhancements

Flash Backup and Recovery

Backup Compression

Drop Database

Automatic Channel Failover for Backup & Restore

Incrementally Updated Backups

Simplified Recovery Through Resetlogs

Flashback Any Error

Flashback Database

Flashback Table

Flashback Versions Query

Flashback Transaction Query

Flashback Drop

General Storage Management

Rename Tablespace

Redo Logfile Sizing Advisor

SYSAUX Tablespace

Copying Files using the Database Server

Automatic Storage Management

Data mirroring with ASM

ASM Dynamic Rebalancing

ASM Striping

ASM General Architecture

ASM Disk Groups

Failure Groups

Maintain Software

Oracle Database 10g Upgrade Paths

Easy Upgrade (key DBUA features / one script upgrade)

Upgrade Information Tools (pre/post)

Security Enhancements

VPD Static and Dynamic Policies

Column-level VPD

Uniform Audit Trail

Miscellaneous New Features

Transaction Monitoring

End-to-End Tracing

Logminer Enhancements

Resumable Space Allocation Enhancements

Regular Expression functions