This class will give you a sound introduction to the prominent new features available with Oracle10g. The primary objective is to provide you with an understanding of the intended purpose and use of the feature, while adding context from the instructor’s research and / or use of the feature. Most topics are discussed within the context of a working example, so you will have a head-start on implementation.
It is not possible to cover every new feature supplied with Oracle10g. Therefore, we urge to carefully review the Topic Summary provided below. If you have a concern that a feature you have particular interest in may not be discussed, we urge you to contact us prior to the class to talk to your instructor.
Oracle Training Prerequisites
Students must already have a working knowledge of Oracle, preferably Oracle9i. Students should be taking the course as an introduction to the new features in Oracle10g, not as an introduction to Oracle concepts. Those needing an introduction to Oracle should attend Introduction to Oracle: SQL & SQL*Plus course.
Oracle Training Audience
Oracle DBAs, programmers, operators and managers with technical experience will benefit from the class.
Oracle Training Course duration
1 Day
Oracle Training Course Objectives
After successfully completing this course, you will understand the key new features in Oracle10g and be able to determine if and where the feature can be used in your systems.
Oracle Training Course outline
- Automatic Storage Management
- ASM Instance
- Creating Disk Groups
- Using Disk Groups
- Checking the Dictionary
- Tablespace-Related Features
- SYSAUX Tablespace
- Multiple Temporary Tablespaces and Tablespace Groups
- Transportable Tablespace Enhancements
- Default Tablespaces
- Rename Tablespace
- Oracle Enterprise Manager
- Database Control
- Grid Control
- Primary New Features
- Performance and Tuning Features
- Automatic Memory Management
- Automatic Workload Repository
- Automatic Database Diagnostic Monitor
- SQL Profiles
- SQL Tuning Advisor
- Redo Log Advisor
- Segment Advisory
- DBMS_STATS Enhancements
- Diagnosing Wait Events
- Hints – Old and New
- Checkpoint Enhancements
- Enhanced Trace – DBMS_MONITOR
- Sorted Hash Clusters
- Changes to CBO
- Miscellaneous
- UNDO Enhancements
- UNDO Advisor
- Guaranteed Retention
- Automatic Undo Retention
- RMAN Enhancements
- Real Compressed Backups
- Better Incremental Backups
- Recovery Across Resetlogs Operations
- Scheduled Backups (The Scheduler)
- DB_RECOVERY_FILE_DEST
- Restore Preview
- Recovery Enhancements
- Flashback Enhancements
- Flashback Database
- Flashback Table
- Flashback Drop
- Flashback Version Query
- Flashback Transaction Query
- PL/SQL Improvements
- New Optimization
- Access line number with DBMS_UTILITY.FORMAT_ERROR_BACKTRACE
- CPU Time with DBMS_UTILITY.GET_CPU_TIME
- Compiler Warnings
- FORALL and Sparse Arrays
- Set Operations on Nested Tables
- UTL_COMPRESSION
- SQL Language Enhancements and Extensions
- Regular Expressions
- SQL Model Clause
- Returning Clause Aggregates
- Grouped Table Outer Joins
- New Connect By Features
- New and Improved Utilities
- Data Pump
- SQL*Plus
- iSQL*Plus
- Scheduling Jobs with The Scheduler
- Replacing DBMS_JOB
- Using DBMS_SCHEDULER
- Data Warehouse and VLDB Enhancements
- SQL Access Advisor
- Bigfiles
- Partitioning Enhancements
- Materialized View Enhancements
- Security Enhancements
- VPD
- Auditing
- Encryption – DBMS_CRYPTO
- Miscellaneous
- DBA_FEATURE_USAGE_STATISTICS and DBA_HIGH_WATER_MARK_STATISTICS
- Segment Shrink Capability
- Rollback Monitoring
- Database Resource Manager Enhancements
- Changes to DBCA
- External Table Enhancements
- Initialization Parameter Changes
- Logminer Automatic Redo Log File
- TCP/IP Connect Strings
- A Moment on HTML DB – What is it good for?
Hardware/Software Requirements
- Hardware Requirements
- Software Requirements
