Oracle Database 10g: New Features for Administrators
What you will learn:
This course introduces students to the new features in Oracle Database 10g – the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.
This course counts towards the Hands-on course requirement for the Oracle 9i Database Administrator and Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led oonline formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Schedule/Purchase Training Formats Price Duration Course Materials Instruction Language
View Schedule Instructor-Led Training US$ 3,000 5 Days English English
Purchase Oonline Self Study CD-ROM US$ 750 not applicable English
Audience:Database Administrators
Support Engineer
Technical Consultant
PL/SQL Developer
Prerequisites:Required Prerequisites:
Administration experience with Oracle9i Database
Course Objectives:Implement improved manageability features to simplify database management
Utilize database advisors to provide proactive database monitoring
Increase data availability through Oracle Database 10g features that offer improved point in time recovery
Assist developers using Oracle Database 10g features in their applications
Course Topics:Introduction
How DBAs Spend Their Time
Oracle Database 10g Manageability Goals
Oracle Database 10g Solution: Self-Managing Database
Grid Computing
Oracle Database 10g: The Database for the Grid
Installation
Installation Performance Enhancements
Installation New Feature Support
Automatic pre & post install validations
CD pack contents
Server Configuration
Database Features Usage Tracking
Automatic Enterprise Manager Configuration
Simplified Initialization Parameters
Simplified Database Install
Load and Unload Data
Cross-platform Transportable Tablespaces
External Tables Unload
DataPump Export and Import Utilities
Automatic Management
Automatic Checkpoint Tuning
Automatic Database Diagnostic Monitor
Automatic Shared Memory Tuning
Automatic Optimizer Statistics Collection
Automatic Undo Retention
Manageability Infrastructure
Advisory Framework
Automatic Routine Administration Tasks
Server-generated Alerts / Threshold-based Alerts
Automatic Workload Repository
Application Management and Availability
SQL Access Advisor
SQL Tuning Advisor
New performance overview charts in EM
Rule-based optimization (RBO) obsolescence
SQL Support for Analytical Applications
MERGE Command Enhancements
Partitioned Outer Join
Integrating Interrow Calculations in SQL
Summary Management Enhancements
System Resource Management
Setting Idle Timeouts
Switching Back to the Initial Consumer Group at End of Call
Database Resource Manager – Adaptive Consumer Group Mapping
Monitoring the Resource Manager
The Scheduler
Core Scheduler Features
Privileges for Scheduler Components
Calendaring Expressions
Advanced Scheduler Concepts
Space Management
Segment Advisor
New Segment Resource Estimation
Oonline Segment Shrink
Proactive Tablespace Management
Undo Advisor
Sorted Hash Clusters
Improved VLDB Support
Bigfile Tablespace
Enhanced Partition Management in Enterprise Manager
Global Partitioned Indexes – Hash Partitioning
Local Partitioned Indexes Manageability Improvements
Temporary tablespace groups
RMAN Enhancements
Flash Backup and Recovery
Backup Compression
Drop Database
Automatic Channel Failover for Backup & Restore
Incrementally Updated Backups
Simplified Recovery Through Resetlogs
Flashback Any Error
Flashback Database
Flashback Table
Flashback Versions Query
Flashback Transaction Query
Flashback Drop
General Storage Management
Rename Tablespace
Redo Logfile Sizing Advisor
SYSAUX Tablespace
Copying Files using the Database Server
Automatic Storage Management
Data mirroring with ASM
ASM Dynamic Rebalancing
ASM Striping
ASM General Architecture
ASM Disk Groups
Failure Groups
Maintain Software
Oracle Database 10g Upgrade Paths
Easy Upgrade (key DBUA features / one script upgrade)
Upgrade Information Tools (pre/post)
Security Enhancements
VPD Static and Dynamic Policies
Column-level VPD
Uniform Audit Trail
Miscellaneous New Features
Transaction Monitoring
End-to-End Tracing
Logminer Enhancements
Resumable Space Allocation Enhancements
Regular Expression functions
Return to top
Related Courses:Oracle Database 10g New Features for Administrators Self-Study CD Course
