Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Oracle Database 10g: New Features For Administrators Training

Oracle Database 10g: New Features For Administrators Training

Course#: WA1385

This course reviews all of the major administration features and improvements introduced with version 10g of the Oracle database Students will be able to apply their experience with previous releases of the Oracle database to this new release, which offers numerous productivity and manageability improvements.

Objectives:

Within this course, students will learn how to:

  • Install and initially configure a database instance
  • Load and unload data between databases, including use of the Data Pump architecture
  • Enable and configure automatic database management
  • Enable and configure manageability features
  • Enable and use general storage management and automatic storage management (ASM)
  • Exploit new security enhancements to create a trusted database environment

Audience

The target audience for this course is database administrators with experience using Oracle9i, wanting to learn about the new and modified features introduced in Oracle 10g.

Prerequisites

Students should have experience administering production databases using Oracle9i Students with experience in Oracle8i or earlier are required to read the course book ORACLE9I NEW & ADVANCED FEATURES FOR ADMINISTRATORS as a prerequisite to this course

Duration

Five days.

 

Outline of WA1385 Oracle Database 10g: New Features For Administrators Training

1. DATABASE SERVER INSTALLATION & CONFIGURATION 

  • SIMPLIFIED DATABASE INSTALL
  • ENTERPRISE MANAGEMENT CONFIGURATION
  • SIMPLIFIED INITIALIZATION PARAMETERS
  • DATABASE FEATURES USAGE TRACKING
  • DATABASE SERVER INSTALLATION & CONFIGURATION

2. LOAD & UNLOAD DATA 

  • THE DATA PUMP ARCHITECTURE
  • EXPDP & IMPDP UTILITIES
  • USING THE DATA PUMP EXPDP UTILITY
  • USING THE DATA PUMP IMPDP UTILITY
  • CROSS-PLATFORM TRANSPORTABLE TABLESPACES
  • LOAD & UNLOAD WITH EXTERNAL TABLES

3. AUTOMATIC MANAGEMENT

  • ABOUT AUTOMATIC MANAGEMENT
  • AUTOMATIC CHECKPOINT TUNING
  • AUTOMATIC SHARED MEMORY MANAGEMENT
  • AUTOMATIC OPTIMIZER STATISTICS COLLECTION
  • GATHER_STATS_JOB()
  • AUTOMATIC UNDO RETENTION
  • AUTOMATIC DATABASE DIAGNOSTIC MONITOR

4. MANAGEABILITY INFRASTRUCTURE

  • ABOUT THE ADVISORY FRAMEWORK
  • AUTOMATIC ROUTINE ADMINISTRATION TASKS
  • SERVER GENERATED ALERTS
  • DBMS_SERVER_ALERTSET_THRESHOLD()
  • DBMS_SERVER_ALERTGET_THRESHOLD()
  • AUTOMATIC WORKLOAD REPOSITORY

5. APPLICATION MANAGEMENT & AVAILABILITY

  • SQL ACCESS ADVISOR
  • SQL TUNING ADVISOR
  • DBMS_SQLTUNE()
  • NEW PERFORMANCE OVERVIEW CHARTS
  • RULE-BASED OPTIMIZATION OBSOLESCENCE

6. SQL SUPPORT FOR ANALYTICAL APPLICATIONS

  • MERGE COMMAND ENHANCEMENTS
  • PARTITIONED OUTER JOINS
  • INTEGRATING INTER-ROW CALCULATIONS IN SQL
  • MATERIALIZED VIEW ENHANCEMENTS

7. SYSTEM RESOURCE MANAGEMENT

  • SETTING IDLE TIMEOUTS
  • SWITCHING BACK TO INITIAL CONSUMER
  • MAPPINGS WITH DATABASE RESOURCE MANAGER
  • CPU_MTH=>RUN-TO-COMPLETION
  • CPU_MTH=> RATIO
  • MONITORING THE DATABASE RESOURCE MANAGER

8. THE SCHEDULER

  • CORE SCHEDULER FEATURES
  • PRIVILEGES FOR SCHEDULER COMPONENTS
  • CREATING A SCHEDULER JOB
  • ADVANCED SCHEDULER CONCEPTS

9. SPACE MANAGEMENT

  • THE SEGMENT ADVISOR
  • SEGMENT RESOURCE ESTIMATION
  • ONLINE SEGMENT SHRINK
  • PROACTIVE TABLESPACE MANAGEMENT
  • UNDO ADVISOR
  • SORTED HASH CLUSTERS

10. IMPROVED VLDB SUPPORT

  • ABOUT BIGFILE TABLESPACES
  • ENHANCED PARTITION MANAGEMENT
  • HASH-PARTITIONED GLOBAL INDEXES
  • LOCAL PARTITIONED INDEXES
  • TEMPORARY TABLESPACE GROUPS

11. RMAN ENHANCEMENTS

  • FLASH BACKUP & RECOVERY
  • ENHANCED ONLINE BACKUP MODE
  • BACKUP COMPRESSION
  • RMAN ENHANCEMENTS
  • INCREMENTALLY UPDATED BACKUPS
  • SIMPLIFIED RECOVERY THROUGH RESETLOGS

12. FLASHBACK ANY ERROR

  • INTRODUCTION
  • ABOUT FLASHBACK TECHNOLOGY
  • FLASHBACK DATABASE
  • FLASHBACK TABLE
  • FLASHBACK VERSIONS QUERY
  • FLASHBACK TRANSACTION QUERY
  • FLASHBACK DROP

13. GENERAL STORAGE MANAGEMENT

  • RENAME TABLESPACE
  • REDO LOGFILE SIZE ADVISOR
  • SYSAUX TABLESPACE
  • COPYING FILES USING THE DATABASE SERVER
  • DEFAULT PERMANENT TABLESPACE

14. AUTOMATIC STORAGE MANAGEMENT

  • AUTOMATIC STORAGE MANAGEMENT
  • THE ASM INSTANCE
  • ASM ADMINISTRATION
  • ASM FILES
  • MIGRATING THE DATABASE TO ASM

15. SECURITY ENHANCEMENTS

  • VIRTUAL PRIVATE DATABASE
  • STATIC AND DYNAMIC POLICIES
  • THE AUDIT TRAIL

16. MISCELLANEOUS NEW FEATURES

  • TRANSACTION MONITORING
  • CLIENT CONNECT CONFIGURATION
  • SIMPLIFIED SHARED SERVER CONFIGURATION
  • LOGMINER ENHANCEMENTS
  • RESUMABLE SPACE ALLOCATION ENHANCEMENTS
  • MISCELLANEOUS FEATURES
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.