Oracle Database 10g New Features for Administrators Study Guide

1-4188-1110-6 © 2006 Publish date: March 10, 2005 603 pages

Buy Now: $199.99

Course ID: oracle-database-10g-new-feat-admin-sg

Learn about the new features of Oracle 10g by choosing the Oracle Database 10g New Features for Administrators study guide from our selection of Oracle computer training books.

By choosing this self-directed course, you will get an overview of the various manageability features and enhancements that have been included in the new release of Oracle Database 10g. While the Oracle Database 10g New Features for Administrators courseware doesn't present an exhaustive overview of all of Oracle's new features, it focuses on one of the most important areas of this new release: manageability. Manageability is also considered one of the more interesting topics to database administrators.

This study guide goes over a variety of topics including server configuration, loading and unloading data, automatic management, application management, SQL support, system resource management, the scheduler, space management, and improved VLDB support.

The Oracle Database 10g New Features for Administrators courseware is an excellent reference book that will get you up to speed on the new features of this release of Oracle. You can use the manual to learn these features on your own in about a week or so. But if you need more time, you can take as long as you need because this is a self-directed course.

Course Contents

Server configuration

• Database installations simplified
• Enterprise management configuration is automatic
• Initialization parameters simplified

Loading and unloading data

• Working with cross-platform, transportable table spaces
• Export and import utilities
• Using external tables

Automatic Management Features

• Working with checkpoint tuning
• Using the database diagnostic monitor
• Working with shared memory management
• Working with optimizer statistics collection
• Working with the automatic undo retention

Automatic management continued

• Working with advisory frameworks
• Automating routine administration tasks
• Working with server generated alerts
• Working with the automatic workload repository

Working with application management and availability

• The SQL access advisor
• The SQL tuning advisor
• A discussion about DBMS_SQLtune
• Working with performance overview charts in database control
• A discussion about rule-based obsolescence

SQL support for analytical applications

• Enhancements for merge commands
• Working with partitioned outer joins
• SQL and interrow calculations integration

System resource management

• How to set idle timeouts
• How to switch back to the initial consumer group at the end of calls
• Using database resource manager to create mappings
• Working with CPU_MTH=>run-to-completion
• Working with CPU_MTH=> ratio
• Working with monitoring the resource manager

The scheduler

• Features of the scheduler
• Working with privileges for various scheduler components
• How to create scheduler jobs
• Advanced scheduler concepts
• Working with the DBA scheduler job log
• DBA scheduler jobs

Managing space

• The segment advisor
• Estimating segment resources
• Online segment shrink
• Managing tablespace proactively
• The undo advisor
• Working with sorted hash clusters

Improved VLDB support

• Working with bigfile tablespaces
• Using database control to enhance partition management
• Working with hash-partitioned global
• Indexes
• Working with local partitioned
• Working with temporary tablespace groups