IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
Oracle 9i New Features

Duration: 2 days

Course Overview
This course is designed to update experienced ORACLE Database Administrators’ knowledge of the Oracle database by introducing the new features associated with ORACLE9i. The course offers detailed descriptions of the new features together with workshops to enhance the attendees understanding.

Target Audience


It is expected that attendees will be technically involved with database administration or developers, designers or system managers who will benefit from knowledge of the new features of ORACLE9i.

Course Objectives


On completion of this course the attendee will appreciate the new features in ORACLE9i enabling the Developer/DBA to know what is required when administering an ORACLE9i database.

Prerequisites


ORACLE8i DBA’s who need to know about the new capabilities of the ORACLE9i database. Attendees should have experience of ORACLE8i databases. DBA’s moving from an earlier database are advised to attend the ORACLE8i New Features course first.

Course Content


Memory Management
Automated SQL Execution Memory Management
Tuning PGA Memory
V$SYSSTAT and V$SESSTAT
Dynamic SGA

DBA and Management Features
Oracle Managed Files
Configuring OMF
OMF Tablespaces
Automated UNDO Management
UNDO Tablespaces
Multiple Database Block Size Support
Configuring Memory Subcaches
Resumable Space Management

Architecture Changes
IOT Indexing Options
IOTs, parallel DML and Overflow Segments
Skipping Index Scanning
Object Metadata
Online Operations
Automated Segment Free Space Management
Shared Server Changes
Cursor Sharing

Backup and Recovery New
Features
Flashback Query
Using Flashback with Export
LogMiner Enhancements
New Instance Failure Recovery Features
Fast Start Time-Based Recovery
RMAN Enhancements
New and Changed Backup Features
New SHOW Command
Setting up defaults
Backup File Optimisation
Block Media Recovery
Data Guard

DataWarehousing
Partitioning Enhancements
View Constraints
New Extraction Transformation Loading features
Table Functions
Multi-Table Insert Statement
Pivoting Insert Statement
First Insert Statement
Conditional/Unconditional Insert Statement
Merge Statements

SQL and PL/SQL
Cross Joins
Natural Joins
Equi-joins and the Using Clause
Join predicates and the ON clause
Different Outer Joins
CASE Expressions
Grouping Sets
Bulk Bind Improvements
New Optimiser and Statistics-Gathering Options

Real Application Clusters
Parallel Server
Cache Fusion
Architectural Concepts

Enter your email address to register for our newsletter: