Golden Consulting

Oracle 10g New Feature & Skills for DBAs (ORL555)

Course Description

This hands-on class will give you a practical introduction to upgrading to Oracle 10g and to approximately 100 new administrative-related enhancements and features available with Oracle 10g. Both Release 1 and Release 2 of Oracle 10g are covered. In addition to DBA-related features, this training includes an overview of more than 25 SQL and PL/SQL enhancements offered with Oracle 10g.

The primary objective of this training is to provide you with a solid understanding and intended purpose of a feature and an opportunity to practice implementing the feature. Limitations or known problems are included where applicable.

The 350+ page course book contains detailed, working examples and detailed yet concise explanations. More than 150 scripts are supplied with the course book. Solutions are provided for all workshops. It is not possible to cover every new feature supplied with Oracle 10g. Therefore, we request that you review the Topic Summary provided below prior to attending the class

Course Audience

Oracle9i DBAs

Course Topics

Oracle 10g Release 2 Upgrade
  • Documentation Required
  • Software Requirements
  • Media Requirements
  • Upgrade Paths
  • Upgrade Methods
  • Backing Up the OS and Database
  • Validating the Host
  • Creating the Oracle 10g Home
  • Oracle10g Release 2 Software Installation
  • Patching Oracle 10g Release 2
  • Running Release 2 Upgrade Information Tool
  • Upgrade the Source Database (DBUA or Manual Upgrade)
  • Oracle 10g Backout Procedures
Oracle 10g Backup and Recovery Enhancements
  • Flash Recovery Area: Concepts
  • Flash Recovery Area: Benefits
  • Flash Recovery Area: Configuration
  • Flash Recovery Area: Monitoring
  • Simplified Recovery Through RESETLOGS
  • Architectural Changes
  • Compressed Backups
  • Change Tracking
  • Incrementally Updated Backups
  • New V$ Views for Oracle 10g RMAN
  • Encrypted Backups
  • DURATION Parameter
  • More RMAN Enhancements
  • User-Managed Enhancements
  • Backing up to Tape with Oracle Backup
  • Lesson Summary
  • Workshop
Oracle 10g Flashback Features
  • Flashback Evolution
  • Flashback Setup
  • Oracle 10g Flashback Version Query
  • Oracle 10g FLASHBACK_TRANSACTION_QUERY View
  • Flashback Table Concepts, Preparation
  • Flashback Table: Undo Application Changes
  • Flashback Table: Recover Dropped TABLE
  • Introducing the Oracle 10g Recycle Bin
  • Managing the Recycle Bin
  • Flashback Database
  • Configure the Oracle 10g Database for Flashback Database
  • Flashback Database: Example
  • Lesson Summary
  • Workshop
Oracle 10g Automatic Storage Management
  • Introducing ASM
  • What is Automated S.A.M.E.?
  • ASM Feature Highlights
  • ASM Instance Architecture
  • ASM Installation Tips
  • Starting ASM
  • ASM Disks
  • ASM Diskgroups
  • ASM Failgroups
  • Creating Diskgroup
  • Altering Diskgroup
  • Referencing Disk Group
  • Using ASMCMD
  • Lesson Summary
  • Workshop
Oracle 10g Job Scheduler
  • Introduction to the Oracle 10g Job Scheduler
  • Scheduler Components
  • Control Resources
  • Monitoring Jobs
  • Exploring More Features in the Oracle 10g Job Scheduler
  • Example: Create Schedule
  • Example: Create Job
  • Example: Running an OS Script (Under Windows or Unix)
  • Scheduler-Related Dictionary Views
  • Miscellaneous Oracle 10g Job Scheduler Features
  • Oracle 10g Job Scheduler Privileges
  • Lesson Summary
  • Resources
  • Workshop
Oracle 10g Performance and Tuning I: General Enhancements
  • Automatic Shared Memory Management
  • Automatic SGA Demonstration
  • V$SESSION Enhancements
  • What's New with Enterprise Manager
  • Tuning with Enterprise Manager
  • Enterprise Manager Database Control
  • Enterprise Manager Grid Control
  • Automatic Optimizer Statistics
  • DBMS_STATS Enhancements
  • Rule-Based Optimization Desupport
  • Cost-Based Optimization Enhancements
  • SQL*Plus AUTOTRACE Enhancements
  • PL/SQL Performance - New Optimizing Compiler
  • End-to-End Application Tracing
  • Other Trace Enhancements
  • Miscellaneous Oracle 10g Performance and Tuning Features
  • Additional Oracle 10g Release 2 Enhancements
  • Lesson Summary
  • Workshop
Oracle 10g Performance and Tuning II: New Statistics
  • New Performance Data
  • Metrics Data Collected
  • Metric Thresholds
  • Server-Generated Alerts and Notifications
  • Time Model Statistics
  • Database Time
  • Active Session History
  • Wait Classes
  • Lesson Summary
  • Workshop
Oracle 10g Performance and Tuning III: AWR & Advisors
  • Introduction to the Oracle 10g Automatic Workload Repository (AWR)
  • AWR Snapshots
  • Controlling AWR Snapshots
  • AWR Views
  • AWR Reporting
  • Oracle 10g Tuning Advisors
  • Introduction to ADDM
  • ADDM Report Excerpt
  • ADDM Findings and Recommendations
  • Enabling ADDM
  • SQL Tuning Advisor
  • SQL Tuning Advisor Interfaces
  • Input to SQL Tuning Advisor
  • Running SQL Tuning Advisor
  • SQL Tuning Advisor Demonstration
  • SQL Profiles
  • SQL Profile Demonstration
  • Other Oracle 10g Advisors
  • Lesson Summary
  • Workshop
Oracle 10g Security Enhancements
  • CONNECT Role
  • Fine Grained Access Control (FGAC) Review
  • Virtual Private Database (VPD) Policy Types Review
  • Oracle 10g VPD Policy Types
  • Column-Level VPD
  • Oracle 10g VPD Example
  • Fine Grained Auditing (FGA) Review
  • Review: Create FGA Policy
  • Review: Display Audited Activity
  • Oracle 10g Auditing Enhancements
  • Using the DBMS_CRYPTO Package
  • Transparent Data Encryption (Release 2)
  • Lesson Summary
  • Workshop
Oracle 10g Tablespace, Table and Segment Management
  • SYSAUX Tablespace
  • BIGFILE Tablespace
  • SMALLFILE Tablespace
  • Default Tablespace
  • Rename Tablespace
  • Temp Tablespace Groups
  • Transportable Tablespace
  • Predicting Object Growth
  • Online Table Redefinition
  • Online Segment Shrink
  • Shrink: Oracle 9i versus Oracle 10g
  • How to Shrink
  • Lesson Summary
  • Workshop
Oracle 10g Utility Enhancements
  • Introducing Data Pump
  • Server-Based Utility
  • Major Differences
  • Data Pump Modes
  • Data Pump Access Methods
  • Export Example
  • Import Example
  • Monitoring Jobs
  • Filtering Capabilities
  • Remap & Transformation
  • Flashback Support
  • expdp Features
  • impdp Features
  • Network Export / Import
  • Network Import Example
  • DBMS_DATAPUMP
  • Data Pump Dictionary Views
  • Enterprise Manager Support
  • External Table Enhancements
  • Logminer Enhancements
  • Lesson Summary
  • Workshop
Miscellaneous Oracle 10g Enhancements
  • Guaranteed Retention
  • Rollback Monitoring
  • New Connect String Support
  • High Watermark Statistics
  • Database Feature Usage
  • Deprecated Parameters
  • Release 1 Parameters
  • Release 2 Parameters
  • DROP DATABASE
  • Lesson Summary
  • Workshop
Oracle 10g SQL Enhancements
  • Regular Expressions
  • REGEXP_LIKE Condition
  • Common Metasymbols
  • Perl Expressions (Release 2)
  • Matching Sets and Repeaters
  • Backreferences
  • Summary: Regular Expressions
  • Case-Insensitive Sort
  • Case-Insensitive Search
  • Accent-Insensitive Sort and Search
  • Effect on Index Use
  • Text Literal Quote Character
  • MERGE Statement Enhancements
  • Partition Outer Join
  • MODEL Clause Concepts
  • MODEL Clause Examples
  • ORA_ROWSCN Concepts and Use
  • New SQL Datatypes
  • Oracle 10g LOB Enhancements
  • New SQL Functions
  • RETURNING Aggregates
  • CONNECT BY Enhancements
  • COMMIT Enhancements
  • Miscellaneous SQL Features
  • Introduction to XQuery
  • Oracle 10g XQuery Support Overview
  • Oracle 10g XQuery Examples
  • Lesson Summary
  • Workshop
Oracle 10g PL/SQL Enhancements
  • Performance: Compiler
  • Optimization Comparison: Oracle9i to Oracle10g
  • PL/SQL Compiler Warnings
  • Oracle9i Native Compilation Review
  • Oracle 10g Native Compilation Enhancements
  • Oracle 10g Release 2 Conditional Compilation
  • Error Handling with FORMAT_ERROR_BACKTRACE
  • ORACLE !)G GET_CPU_TIME
  • FORALL Improvements
  • Regular Expressions
  • Quoting Mechanism
  • Introducing UTL_MAIL
  • UTL_MAIL SET UP
  • UTL_MAIL EXAMPLE
  • Nested Table Enhancements
  • New and Revised Packages
  • Lesson Summary
  • Workshop
Oracle 10g SQL*Plus Enhancements
  • Predefined Variables
  • Recycle Bin
  • SPOOL Enhancements
  • SQL*Plus AUTOTRACE
  • Miscellaneous
  • Lesson Summary
  • Workshop

Prerequisite Knowledge/Experience

Students must already have a working knowledge of Oracle9i database administration.

Delivery & Duration

This instructor-led offering is a four-day course.


Outline Location: http://www.goldencg.com/edu/outlines/orl555.html

Golden Consulting Group, LLC
800 Cottage Grove Road
Building 3
Bloomfield, CT 06002

Telephone:      860.242.7704
Fax:                 860.242.7866
Email:              golden@goldencg.com     



Golden Consulting Group LLC © 2008 All Rights Reserved