Oracle 10g New Features for Administrators

Length: 3 Days
Audience: Managers and Database Administrators responsible for administration of an Oracle DBMS.
Prerequisites: Administration experience of an Oracle database
Overview: This course presents an overview of new features and enhancements introduced to the Oracle DBMS in Oracle 10g. Attendees should already be familiar with the general features available in earlier releases of Oracle, including features introduced in Oracle9i.
Because this course is intended for database administrators, technical topics are covered in greater detail than in the general Oracle 10g New Features course.
The course can be presented entirely as lectures and demonstrations or attendees could interact with the system to evaluate the new features.
Topics discussed include:
  • Application Development (SQL & PL/SQL Enhancements)
    • Data Type Changes
    • Object-Oriented Concepts
    • Expression Filter Type
    • Regular Expressions
    • Multiset Operators
    • SQL* Plus Enhancements
    • PL/SQL Enhancements
  • SQL Enhancements
    • Hierarchic Queries
    • Interrow Calculations
    • Partitioned Outer Join
  • Loading and Unloading Data
    • Cross-Platform Transportable Tablespaces
    • External Tables Unload
    • Data Pump Export and Import
  • Improved VLDB Support
    • Bigfile Tablespaces
    • Global Partitioned Indexes - Hash Partitioning
    • Local Partitioned Indexes Manageability Improvements
  • The Scheduler
    • Scheduler Features
    • Privileges for Scheduler Components
    • Calendaring Expressions
  • System Management
    • Optimizer Statistics Collection
    • Undo Retention
    • Default User Tablespace
    • Multiple Default Temporary Tablespaces
    • Automatic Workload Repository
    • Automatic Database Diagnostic Monitor
    • Server-Generated Alerts
  • General Storage Management
    • PURGE Statement
    • Rename Tablespace
    • Automatic Shared Memory Management
    • SYSAUX Tablespace
    • Redo Log File Sizing
  • Automatic Storage Management
    • General Architecture
    • Disk Groups
  • Database Administration
    • Resumable Space Allocation Enhancements
    • RMAN Enhancements
    • Logminer Enhancements
    • Checkpoint Tuning
  • Flashback Features
    • Flashback Versions Query
    • Flashback Transaction Query
    • Recycle Bin 
    • Purge Statement
    • Flashback Drop
    • Flashback Table
    • Flashback Database
    • Flash Recovery Area
  • Desupported and Deprecated Features
Back to Oracle 10g Courses