Print Outline in PDF format

Course Description:

The complexity and flexibility of the Oracle9i database provide a major learning challenge for the Oracle DBA. Jump start your knowledge of Oracle9i with this new course designed for working Oracle DBAs who need to quickly understand and apply the new features of Oracle9i.

Who Needs to Attend:

Database administrators who need to have a more complete understanding of Oracle9i’s new features.

Prerequisites:

Basic understanding of Oracle SQL, SQL*Plus, PL/SQL and Oracle8i architecture and operation.

Course Content:

Using iSQL Plus

New Join Syntax

• Join Operators, OUTER Join Syntax, Oracle’s New Sample Schemas

Other New SQL and PL/SQL Features

• CASE Expressions, Scalar Subqueries, MERGE Command, Multi-table Insert, Aggregate and Analytical Functions, Grouping Sets and Changes in the GROUP BY Clause, Enhancements to LOBs, Objects, and PL/SQL

Globalization Support

• Time Zones within the Database, Timestamp and Interval Datatypes, Datetime Value Expressions, Functions Using Date-based Datatypes

Initialization Parameter Management

• Server Parameter File (SPFILE), Export and Migrate to SPFILES, Share SPFILES Among Multiple Instances of RAC, Persistent Parameters

Memory Management

• SGA Allocation Units, Memory subcaches to support multiple block size tablespaces, Dynamic SGA, Automatic SQL Execution Memory Management

Oracle Managed Files (OMF)

• OMF Configurations and File Naming, Control files and OMF, Redo log files and OMF, Datafiles, Tempfiles and OMF

Tablespace Management

• Multiple Block Sizes, Default Temporary Tablespaces, Automatic Undo Management

Segment and Index Management

• Automatic Segment Free Space Management, Resumable Space
• Management, IOT and Index Changes,
• External Tables, LIST Partitioning, Unloading
• Metadata with DBMS_METADATA

Oracle Enterprise Manager Enhancements

• Changes to the Console, Launch Configurations for OEM Console, Enterprise Manager Configuration Assistant

Managing a Database Workspace

• Introduction to Workspaces, Creating and Managing a Workspace, Activities within a Workspace

Security

• Privileged Connection Options, Virtual Private Database Enhancements, Global Application Context, Oracle Policy Manager, Fine Grained Auditing, DBMS_OBFUSCATION_TOOLKIT Enhancements

Advanced Replication

• Row Level System Change Numbers, Add New Masters without Quiescing

Migration and Upgrade

• Upgrading vs. Migrating, Upgrading from Oracle8i to Oracle9I, Changes to Initialization Parameters, Changes to Data Dictionary Views

Database Resource Manager Enhancements

• Active Session Pool, Undo Pool Quota, Automatic Consumer Group Switching, Resource Manager in OEM

Performance Improvements

• Index Usage Monitoring, Cursor Sharing Enhancements, Changes to DBMS_STATS, External Cached Execution Plans, First Rows Optimization Changes, Scalable Session Management

Real Application Clusters

• Introduction to Real Application Clusters, Cache Fusion High Availability and Real Application Clusters Guard, Common Initialization Parameter File

High Availability and Fault Recovery

• Flashback Query, Instance Failure Recovery, Fast-start Time-Based Recovery, Resumable Operations, Online Operations

RMAN Enhancements

• RMAN Manageability and Reliability Enhancements

Oracle9i LogMiner Enhancements

• Data Dictionary Support, Supplemental Logging

Oracle9i Data Guard

• Data Guard Architecture, Log Transport Services, Standby Redo Log Files, Database Switchover Operations

Lab Exercises:

1. Installing the Sample Schemas and Writing JOINs using the ANSI SQL99 Syntax

2. Using CASE, NULLIF, COALESCE, scalar subqueries, and MERGE

3. Using Analytical Functions, Grouping Sets, and the WITH Clause

4. Managing Date Data with New Datatypes and Functions

5. Using and Managing an SPFILE

6. Using New Memory Management Features

7. Creating and Managing Oracle Managed Files

8. Using New Tablespace Management Feature

9. Using New Segment and Index Management Features

10. Using Oracle Enterprise Manager New Features

11. Using a Database Workspace

12. Using New Security Features

13. Implementing and Using Resource Manager

14. Performance Improvements

15. Using New Online Features

16. RMAN Enhancements

17. Using LogMiner New Features

    
    Unique Training Solutions for Unique Clients - Expanding Skills Today to Meet the Challenges of Tomorrow