	Training/Mentoring

	E-Business Suite
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Training/Mentoring
		The Service
		The Value
		References
		Contact Us / Registration
		Oracle Certification Prep
		Pricing
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing

Oracle 10g New Features for DBAs

Click here to contact us

Course Overview

Oracle 10g New Features for DBAs introduces students to major new database features in Oracle 10g that are relevant to typical DBA work. Some of the features are demonstrated and experienced through hands-on lab exercises. This course intentionally doesn't cover ALL new features introduced in Oracle 10g. There simply wouldn't be enough time to afford any single one of them a justified treatment if the effort is to cover them all. There are simply too many new features. If such an unfair effort is made to cover ALL new features, it's doubtful there would be real learning experienced by the student of any one feature. Such an approach would be only slightly beyond what would be gained by reading a new features list. On the contrary, a selection of very good and useful features is covered in fair depth. There is an accelerated segment of time at the end that introduces many other new features.

Course Goals

To describe major new 10g features in a conceptual manner
To practice the use of some of the features by implementing them in lab exercises
To facilitate discussion of student questions about the concepts and implementation of the features

Prerequisites

SQL & SQL*Plus
Database Administration
Backup and Recovery
Performance Tuning

Who Should Attend?

Database administrators

Course Materials

10g New Features for DBAs Course Notes
10g New Features for DBAs Sample Script Disk

Duration

Three days

Tuition

$1,395

Course Outline

Database administration
- Simplified install
- Easy upgrade and the upgrade information tool
- Upgrade paths from previous versions
- Feature usage tracking
- Flashback
  - Flashback version query
  - Flashback transaction query
  - Flashback table and the recycle bin
  - Flashback drop
  - Flashback database
- Enterprise manager
  - Grid control
  - Space advisor
  - Undo advisor
- Using the scheduler for automated administration tasks
- ASM and Oracle managed files
- Cross-platform transportable tablespaces
- Bigfile tablespaces
- SYSAUX tablespace
- Rename tablespace command
- Server-generated alerts
- DBMS_MONITOR
- DBMS_ALERT
- Pertinent DBMS* packages
- Online segment shrink
- Drop database command
Performance management
- Optimizer changes/improvements
- Advisors and statistics
  - ADDM and AWR
  - System statistics
  - SQL tuning advisor
  - SQL access advisor
  - Buffer cache advisor
  - Automatic shared memory management
  - Automatic statistics collection
- Wait event enhancements
- DBMS_TRACE
- Buffer cache flush
- OEM enhancements useful for performance diagnosis and management (performance overview charts, etc.)
- Bitmap indexes on range/hash/list partitioned IOTs sorted hash clusters
- Pertinent new data dictionary views for performance and administration
Backup, recovery and standby management
- Flash backup/recovery
- Applying incremental backups to a previous backup to update it
- Compressed RMAN backup pieces
- Bounded backup window
- Recovery area full notification
- Automatic TSPITR
- Recovery through resetlogs
- Automatic file creation during recovery
- Faster begin backup and full database begin backup commands
- Change-aware incremental backups
- Data guard broker support for RAC
- Easier logminer use through automatic configuration
- Logminer support for IOTs and additional data types (long, CLOB, etc.)
- Fine-grained supplemental logging
- Increased security of propagated redo records/logs from primary to standby
- Zero data loss support for logical standby
- Real-time apply for standby databases
Network and security management
- Oracle names use must be converted to connection manager
- Auditing enhancements
Data warehousing
- Data pump
- Using external tables to unload data
- Merge functionality
- Materialized view enhancements
  - TUNE_MVIEW view
- Partitioning
  - Partitioning IOTs
  - Easier partition maintenance
Accelerated introduction to other new features
- New/changed SQL hints
- RAC
  - Rolling patches (hotfixes only)
  - Introduction to the grid
- Introduce initialization parameters not yet discussed in the course
- Resource manager enhancements
- Automatic usage of older backups of corruption detected by RMAN
- Security
- Data mining
- Analytics
- Language and application development features
  - SQL (regex, model clause, etc.)
  - Commit timestamp/scn table pseudocolumns
  - Expression filter
  - PL/SQL
  - Unicode