back to Course Categories | back | print
Oracle10g New Features for DBAs (R1 and R2)          

Duration: 5 days

Description 
This intense five-day course is designed to develop proficiency in features new in Oracle10g. This course covers new features in Oracle10g Release 1 and Release 2. Topics include new components in the Oracle10g Database Server, 10g Advisory infrastructure, Direct SGA Access, block integrity checking in memory, faster startup, event based scheduling, Grid computing, optimization enhancements, Automatic Storage Management (ASM) and improved management. Oracle Secure backup, transparent data encryption and additional security enhancements are covered. Enhancements to utilities, network services, backup/recovery, high availability, LogMiner, RAC, Data Guard, SQL*Plus, SQL, PL/SQL, Streams and business intelligence features. Hands-on labs will develop skill with the new features in Oracle10g.

Topics

  • Oracle10g database management strategies
  • Oracle10g infrastructure management strategies
  • Oracle10g new features and tools
  • Oracle10g enhancements to Oracle9i features
  • Common Infrastructure
  • Faster startup
  • Unlimited DBMS ouput
  • Conditional compilation
  • Error logging clause
  • XML query
  • Automatic workload repository
  • Enterprise Manager configuration
  • Automatic Database Diagnostic Monitor
  • Automatic Optimizer statistics collection
  • Automatic shared memory management
  • Automatic undo retention
  • Usage tracking
  • Server generated alerts
  • Advisory framework
  • Transporting AWR data
  • Direct SGA access for slow systems
  • Block integrity checking in memory
  • Compare periods report
  • 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
  • Cross-platform transportable tablespaces
  • CRS, OCR, services, VIP and AWM
  • Automatic storage management (ASM)
  • ASM disk group
  • ASM disk
  • ASM files
  • ASM instance
  • ASM command line tool
  • Enhancements to external tables
  • Space Management
  • Proactive tablespace monitoring
  • Automatic segment advisor
  • Segment management
  • Online segment shrink
  • Redefining a partition online
  • Quick partition split for partitioned index
  • LONG to LOB conversion during online reorg
  • Online reorganization of a single partition
  • Partition by partition table drop
  • Segment resource estimation
  • VLDB enhancements
  • Partitioning enhancements
  • Enhanced partitioning
  • Undo management
  • Redo logfile size advisor
  • Additional Manageability Enhancements
  • Enhancements to Resource management
  • Adaptive Consumer Group Mapping
  • Monitoring resource manager
  • Fixed CPU Quota
  • Integrating Resource Manager and Profiles
  • SQL*Plus enhancements
  • SQL access advisor
  • Regular expressions
  • New analytical features
  • Interrow calculations
  • Summary management
  • Materialized view tuning API
  • Human Error Correction
  • Flashback database
  • Flashback drop
  • Flashback versions query
  • Flashback transaction query
  • Flashback table
  • flashback database/query through resetlogs
  • Flashback database restore points
  • Flash recovery area view
  • Enhanced Log Miner features
  • Automated LogMiner configuration
  • Enhanced LogMiner support
  • Dynamic views for RMAN jobs
  • Tempfile recovery using RMAN
  • Dynamic channel allocation for RMAN
  • Data Pump export and import
  • Transaction manageability
  • Enhanced Tuning Features
  • Automated checkpoint tuning
  • Enhancements to summary management
  • CPU costing
  • Dynamic sampling
  • Enhancements to Data Guard
  • Real time apply
  • Named data guard configurations
  • Secured redo transmission
  • Zero downtime instantiation for SQL apply
  • Scheduler features
  • Scheduler privileges
  • Methods for using the scheduler
  • Advanced scheduler features
  • Event based scheduling
  • 10g initialization parameters
  • Simple versus complex parameters
  • VPD static and dynamic policies
  • Column-level VPD
  • Transparent data encryption
  • Enhanced commit
  • Changes in CONNECT role
  • Uniform audit trail
  • Grid computing
  • Wrap package
  • 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