back to Course Categories | back | print
Oracle10g New Features for DBAs 3 day Workshop          

Duration: 3 days

Description 
This three day workshop is a condensed version of our five day Oracle10g New Features for DBAs course. This course will take a look at the core new features in Oracle10g a DBA needs to be aware of. Topics will include new tuning, management, SQL, utilities, network, backup/recovery, high availability, LogMiner, RAC, Data Guard, SQL*Plus, SQL, Streams and business intelligence features.

Topics

  • Oracle10g database management strategies
  • Oracle10g infrastructure management strategies
  • Oracle10g new features and tools
  • Oracle10g enhancements to Oracle9i features
  • Common Infrastructure
  • Automatic workload repository
  • Server generated alerts
  • Advisory framework
  • Database storage enhancements
  • The SYSAUX tablespace
  • Automated RAC Services
  • DROP DATABASE
  • New static data dictionary views
  • New dynamic data dictionary views
  • Bigfile tablespaces
  • Extended rowid format
  • Renaming tablespaces
  • New features in temporary tablespaces
  • Transportable tablespace enhancements
  • Automatic storage management (ASM)
  • ASM disk group
  • ASM disk
  • ASM files
  • ASM instance
  • Enhancements to external tables
  • Space Management
  • Proactive tablespace monitoring
  • Segment management
  • Enhanced partitioning
  • Undo management
  • Redo logfile size advisor
  • Other Manageability Enhancements
  • Enhancements to Resource management
  • Adaptive Consumer Group Mapping
  • Fixed CPU Quota
  • Integrating Resource Manager and Profiles
  • SQL*Plus enhancements
  • SQL access advisor
  • Materialized view tuning API
  • Automatic shared memory management
  • Human Error Correction
  • Flashback database
  • Flashback drop
  • Flashback versions query
  • Flashback transaction query
  • Flashback table
  • Enhanced Log Miner features
  • Automated LogMiner configuration
  • Enhanced LogMiner support
  • Data Pump export and import
  • Transaction manageability
  • Enhanced Tuning Features
  • Automated checkpoint tuning
  • CPU costing
  • Dynamic sampling
  • Enhancements to Data Guard
  • Real time apply
  • Named data guard configurations
  • Secured redo transmission
  • Zero downtime instantiation for SQL apply
  • 10g initialization parameters
  • Grid computing
  • How Oracle10g will change database administration
  • How Oracle10g will impact Oracle9i database management

Prerequisites

  • Attendees must have a strong backround in Oracle9i database administration.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design