Oracle 9i New Features for Administrators

Global Knowledge (UK) Inc.
Dublin,Maidenhead, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course introduces students to the new features in Oracle9i that impact database administration. Students learn how to use Oracle9i capabilities to increase database availability, to simplify database performance monitoring and tuning, and to improve database manageability. The course also covers security and development platform changes that students need to understand if applications running in databases they support use the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.

Learn How To
At the end of this course, students will be able to understand the use of improvements in the following areas:

Utilise enhanced security options to protect Oracle9i database contents
Increase database availability by using Oracle9i features that reduce database down-time and data loss
Implement Oracle9i capabilities to improve database performance
Simplify database management tasks using Oracle9i tools and features that reduce the work required to keep your database running
Assist developers using Oracle9i features in their applications

What You’ll Learn
Course Outline
Oracle Server Security

Connecting as the DBA
Global Application Context
Fine Grain Access Control Enhancements
Encryption Enhancements
Oracle Label Security
Enterprise User Security Enhancements

General High Availability Technology

Two pass instance or crash Recovery
New FAST_START_MTTR_TARGET Parameter
Changes to v$INSTANCE_RECOVERY
Oracle Flashback
Resumable Space Allocation
Export/Import

Oracle 9i LogMiner Enhancements

DDL Statement Support
Dictionary information in redo logs
Skipping past log Corruptions
LogMiner Restrictions

Backup and Recovery

RMAN Manageability Enhancements
RMAN Reliability Enhancements
New Reporting Capabilities
RMAN catalog maintenance
Crosscheck Autolocate

Oracle 9i Data Guard

Oracle 9i Data Guard Architecture
Oracle 9i Data Guard Broker
Oracle 9i Data Guard Manager
Redo Log Reception Option
Finishing Managed Recovery
Automatic Recovery of Log Gaps
Standby File Management
Background Managed Recovery
Parallel Recovery

Database Resource Manager Enhancements

Active Session Pool Parameters
Automatic Consumer Group Switching
Undo Quota
Modified Data Dictionary Views
Oracle Supplied Plans

Online Operations

Online index Rebuild Enhancements
IOT High Availability Enhancements
Quiescing the Database
Creating an SPFILE
Working with Parameters for SPFILES
Exporting and Migrating an SPFILE

Segment Management (Part1)

Maintaining Global Indexes During DDL
List Partitioning
Metadata API in Oracle 9i
Pipelined Data Transformation in Oracle 9i
Overview of External Tables

Segment Management (Part II)

Automatic Space Management Segments
Modifications to the DBMS_SPACE Package
DBMS_REPAIR Package Support
Bitmap Join Indexes
Enabling and Disabling Index Usage Monitoring
Cursor Sharing Enhancements
Cached Execution Plans
New First Rows optimisation
New Gathering Statistic Information
Optimiser Cost Model Enhancements

Scalable Session State Management

Oracle Shared Server improvements
External Procedure Agent Enhancements
Multithreaded HS Agent Architecture
OCI Connection Pooling Features and Usage Model

Real Application Clusters

Real Application Clusters Overview
Benefits of Real Application Clusters
Global Cache Service
Block Transfers
Benefits of Cache Fusion
High Availability Enhancements
Shared Parameter Files
New and Modified SRVCTL commands
Real Application Clusters and Oracle Enterprise Manager

File Management

Oracle Managed Files(OMF)
Default Temporary Tablespace

Tablespace Management

Automatic Undo Management Concepts
Dynamic Extents Transfer
Managing Undo Tablespaces
Multiple Block Size
Standard and Non-Standard Block Sizes

Memory Management

Automated SQL Execution Memory Management
Dynamic SGA

Enterprise Manager Enhancements

Launching Enterprise Manager Console
Enterprise Manager Support for Oracle 9i Database Features

SQL Enhancements

SQL 1999Enhancements Overview
SQL 1999 Joins
CASE Expression Enhancements
Long to LOB migration
Common SQL Parser
Native PL/SQL execution

Globalisation Support Formerly National Language Support

New Time and Interval Data Types
Unicode Support
New or Modified Globalisation Settings

Database Workspaces

What is a Database Workspace
Workspace Manager
Creating and assigning a Workspace
Rolling back, Refreshing, and Merging Workspaces
Enterprise Manager Interface

Advanced Replication

Adding New Master Site without Quiescing
Constraint SCNSs
Materialised View Refresh
Support for User defined Types and Objects
Monitoring and Managing Replication Environments
Changes for Related 9i Features
Installation and Upgrade






Who Needs to Attend
Database administrators, Technical support professional and System administrators.




Suggested Prerequisites



Required Prerequisites

Oracle 8i New Features for Administrators or Enterprise DBA Part 1(DBA1)
Enterprise DBA Performance Tuning (DBA2)

Suggested Prerequisites

Enterprise DBA Network Administration (DBA3)
Oracle 8i SQL statement Tuning (TSS)
Distributed Database Administration
Distributed Systems - Replication
Parallel Server Knowledge
As in all new feature classes we cover the full range of DBA knowledge. Delegates without the pre-requisite courses or skills may experience some difficulty with the exercises. ...''

Phone:+00 353 (0) 1 613 0340 /+44 (0) 1628 594 700

School Address:

Global Knowledge Training Centre Dublin
27 Lower Mount Street
Dublin 2
Phone: +00 353 (0) 1 613 0340
Fax: +00 353 (0) 1 613 0341
Email: salesdesk.ie@globalknowledge.ie

Global Knowledge Training Centre Maidenhead
Cincom House
1 Grenfell Road
Maidenhead
SL6 1HN Berkshire
Phone: 0845 304 0044
Phone: +44 (0) 1628 594 700
Fax: +44 (0)1628 776 600
Email: salesdesk.uk@globalknowledge.co.uk

Jobs & Resumes: Dublin, Maidenhead
Houses & Roommates: Dublin, Maidenhead

Advanced Novell Network Management: Netware 6
ZENworks for Desktop 4
GroupWise 6.5 Administration
Novell Enterprise Linux Services
Upgrading to NetWare 6.5
NetWare 5.1 Advanced Administration
eDirectory Design and Implementation v3.0
Oracle 9i DBA Fundamental I
Oracle 9i DBA Fundamental II
Oracle 9i Forms Developer: Build Internet Applications
Oracle 9i: Real Application Clusters
Oracle 9i for Advanced PL/SQL
Enterprise DBA Part 2: Performance Tuning Workshop
Develop PL/SQL Program Units
Oracle IDS Designer: First Class
Oracle 9i: Java Programming
Oracle 9iPerformance Tuning
Oracle 9i:Programme with PL/SQL
Introduction to Oracle SQL & PL/SQL

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.