Topic Summary

Course topics be customized for classes held at customer locations

• Installing the Oracle 10g Database Software
  • Validating the Environment
  • Using OUI to Install the Software
  • Installing Patches
  • Installing Products from the Companion Disk
• Upgrading an Oracle 8i Database to Oracle 10g
  • Migration Methods
  • The Oracle Upgrade Information Tool
  • Database Upgrade Assistant (DBUA)
  • Manual Upgrades
  • Using Export and Import to Upgrade
  • Documents Required
  • Restoring the Source Database
• Oracle10g Enterprise Manager
  • Browser-based Enterprise Manager
  • Versions - Database Control and Grid Control
  • Major Features
  • Memory Access Mode (Release 2)
  • Top Activity Page (Release 2)
  • Historical View (Release 2)
  • Add-On Packs
  • Alternative Management Tools
• Deprecated and Desupported Features (Replacement Feature Where Applicable)
  • ANALYZE Command
  • Deprecated 9i and 10g Initialization Parameters
  • New Parameter Summary
  • Export and Import Utility - Incremental
  • LONG Datatype
  • bstat/estat
  • CONNECT INTERNAL
  • Server Manager
  • Miscellaneous
• Undo Tablespaces
  • Eliminate Manual Rollback Segment Management with Oracle9i Automatic UNDO Management (AUM)
  • Implementing AUM
  • Sizing the Undo Tablespace with Oracle 10g Undo Advisor
• Using Server Parameter Files
  • Implement and Manage Binary, Server-Side Parameter Files
  • Benefits of SPFILEs
  • Creating an SPFILE
  • Using an SPFILE
  • Persistent Parameters
• SGA Management
  • Oracle9i Multiple Database Block Size Support
  • Oracle9i Dynamic SGA
  • Oracle10g Automatic SGA Management
• Application Tuning Enhancements
  • Oracle 10g Impact on Rule-Based Optimization
  • 9i and 10g New Hints
  • Runtime Plans and Statistics with 9i V$SQL_PLAN
  • 10g SQL Tuning Advisor and SQL Access Advisor
  • Using DBMS_STATS
  • 10g Automatic Optimizer Statistics
  • 9i Table Compression
  • 9i Dynamic Sampling
  • 9i Cursor Sharing Features
  • 10g Sorted Hash Clusters
  • 10g End-to-End Application Tracing
• New Indexing Techniques and Options
  • Oracle9i Bitmap Join Index
  • Index Monitoring
  • Index Organized Table Enhancements
  • DROP CONSTRAINT . KEEP INDEX
  • Create Index on CREATE TABLE Statement
  • Oracle9i Index Skip Scan Access Path
• Database Performance and Tuning Enhancements
  • Oracle9i System Statistics - I/O and CPU time
  • Oracle9i Automatic PGA Management
  • Oracle9i PGA Advisory
  • Oracle Database Resource Manager Enhancements
  • General Oracle 10g Enhancements
  • Oracle 10g Wait Event Enhancements
  • Oracle 10g Automatic Workload Repository (AWR)
  • Oracle 10g Advisors
  • Other Oracle 10g Performance and Tuning Features
• Backup and Recovery Enhancements
  • Introduction to RMAN
  • 9i Automatic Channel Allocation
  • 9i Simplified Command Syntax
  • 9i Control File Auto-Backups
  • 9i Restartable Backups
  • 9i Block Level Recovery
  • 9i Backup and Restore Optimization
  • 9i Archive Log Management
  • Setting up the Oracle 10g Flash Recovery Area
  • Simplified Recovery Through Resetlogs (10g)
  • 10g Compressed Backups
  • 10g Change Tracking
  • 10g Incrementally Updated Backups
  • 10g New V$ Views (Release 2 Adds New Views)
  • 10g DURATION Parameter
  • 10g Encrypted Backups (Release 2)
  • 10g Restore Database Preview
  • 10g Automatic Tempfile Creation (Release 2)
  • RMAN and ASM
  • Other RMAN Enhancements
  • Cross Platform Transportable Tablespace
  • Introduction to Oracle Backup (Oracle10g)
  • User-Managed Backup Enhancements
• LogMiner
  • Oracle9i Logminer Viewer
  • Logminer Architecture
  • Using Logminer in Line Mode
  • Querying V$LOGMNR_CONTENTS
  • Using the Logminer GUI
  • Other Oracle9i Features
  • Oracle10g Enhancements
• Real Application Clusters (RAC) Concepts
  • Introduction to RAC
  • RAC Architecture and Cache Fusion Technology
  • RAC Management Overview
  • Oracle10g RAC Enhancements
• Partitioning Enhancements
  • 9i List Partitioning
  • 9i Range-List Partitioning
  • 9i Sub-Partition Templates
  • Index Organized Table Partitioning Enhancements
  • Partitioned Index Maintenance Enhancements
  • Oracle10g Partitioning Enhancements
• Object, Segment and Storage Management Features
  • Oracle9i DBMS_REDEFINITION
  • Oracle9i ALTER INDEX . REBUILD ONLINE
  • Oracle9i Automatic Segment Space Management (ASSM)
  • Oracle9i Oracle Managed Files (OMF)
  • Oracle 10g SYSAUX tablespace
  • Oracle 10g BIGFILE and SMALLFILE tablespaces
  • Oracle 10g Database-level default tablespace
  • Oracle 10g Database-level default temp tablespace
  • Oracle 10g Temp tablespace groups
  • Oracle 10g Multi-platform transportable tablespace
  • Oracle 10g Renaming tablespaces
  • Oracle 10g Online table redefinition enhancements
  • Oracle 10g Online segment shrink
  • Oracle 10g DBMS_SPACE.OBJECT_GROWTH_TREND
• Oracle10g Automatic Storage Management (ASM)
  • Concepts and Architecture (Updated for Release 2)
  • Installation Tips
  • Starting ASM
  • ASM Disks, Diskgroups and Failgroups
  • Managing ASM with the asmcmd utility
  • ASM from the Database Instance
  • Migrating to ASM Files
  • Miscellaneous Release 2 enhancements
• Oracle Streams
  • Introduction to Streams
  • Oracle10g Enhancements
• Oracle Data Guard
  • Logical Standby Database
  • 9i GUI for Data Guard
  • 9i No Data Loss Mode
  • 9i Switchover Enhancements
  • 10g Real Time Apply
  • 10g Recovery Through Resetlogs
  • 10g Flashback Database Support
  • 10g Physical Standby Startup Changes
  • 10g Logical Standby Enhancements
  • Other 10g Enhancements
• Security Enhancements Strictly for DBA's
  • GRANT ANY OBJECT Privilege
  • Out-of-the-Box Security
  • Auditing SYSDBA Activity
• Security Enhancements for DBA's and Developers
  • Fine Grained Access Control (FGAC) Review
  • Oracle9i FGAC GUI
  • N-Tier Proxy Authentication
  • Oracle9i FGAC Policy Manager
  • Oracle9i FGAC Global Application Contexts
  • Oracle10g FGAC VPD Policy Types
  • Fine Grained Auditing Review
  • Creating a FGA Policy
  • Displaying FGA Activity
  • Fine Grained Auditing Enhancements
  • Oracle9i Enhanced key generation for encryption (FIPS-140 certified)
  • Encryption with Oracle10g DBMS_CRYPTO
  • Transparent Data Encryption (10g Release 2)
• Oracle Flashback Technology
  • Human Error Correction with Flashback Technology
  • Session-Level Flashback with DBMS_FLASHBACK
  • Statement-Level Flashback
  • Flashback Tips and Flashback Limitations
  • Flashback Setup
  • Guaranteeing Retention with Oracle10g
  • 10g Flashback Query Enhancements
  • 10g Flashback Version Query
  • 10g Flashback_Transaction_Query
  • 10g Flashback Table
  • 10g Undo Application Changes
  • 10g Recover from DROP TABLE
  • Managing the Oracle10g Recycle Bin
  • 10g Flash Recovery Area
  • 10g Flashback Database
  • 10g TO BEFORE RESETLOGS Option (Release 2)
  • 10g Using Restore Points (Release 2)
• Oracle 10g Utility Enhancements
  • Data Pump Concepts
  • Major Differences
  • Data Pump Modes
  • Data Pump Access Methods
  • Parallel Processing
  • Export Example
  • Import Example
  • Data Pump Features
  • Network Export / Import
  • Network Import Example
  • DBMS_DATAPUMP
  • Data Pump Dictionary
  • Helpful Datapump Resources
• Resumable Space Management (RSM)
  • Restart Failed Long-Running Jobs with Oracle9i RSM
  • Errors Handled by RSM
  • Enabling RSM
  • Monitoring RSM Jobs
• External Tables
  • Querying flat files with Oracle9i External Tables
  • Using External Tables instead of SQL*Loader Utility
  • External Table Tips and Limitations
  • Writing to Flat Files with External Tables (Oracle10g)
• New Datatypes
  • Oracle9i Datetime Datatypes
  • Oracle 10g Datatypes: BINARY_FLOAT and BINARY_DOUBLE
• XML DB
  • Oracle9i XMLType
  • XMLType Datatype
  • Creating Tables with XMLType
  • Selecting XML Data
  • Updating XML Data
  • XML Repository
  • Oracle 10g Enhancements
  • Introduction to XQuery (10g Release 2)
  • Oracle Support for XQuery
  • XQuery Examples
• SQL Enhancements
  • 9i MERGE Statement and 10g Enhancements
  • 9i Multi-Table INSERT
  • 9i ANSI Compliant Joins
  • 9i Subquery Factoring
  • 9i CONNECT BY Extensions
  • Scrollable cursors
  • INSERT with DEFAULT
  • Renaming Columns, Triggers and Constraints
  • 10g Regular Expressions (including Release 2 Perl Support)
  • 10g Case-Insensitive Sort
  • 10g Case-Insensitive Search
  • 10g Accent-Insensitive Sort/Search
  • 10g Text Literal Quote Character
  • 10g Partition Outer Join
  • 10g MODEL Clause
  • 10g ORA_ROWSCN
  • New 9i and 10g Functions
  • LOB Enhancements (Including Oracle10g Release 2 Impact)
  • Miscellaneous SQL Features
• PL/SQL Features and Enhancements
  • ETL with Oracle9i Pipelined Table Functions
  • 9i CASE Statement
  • 9i Associative Arrays
  • 9i Record-Level DML Support
  • 9i Object Inheritance support
  • 9i Multi-Level Collections
  • 9i Select Rows into PL/SQL Tables
  • 9i Native Compilation with Oracle 10g Enhancements
  • 9i UTL_FILE Improvements
  • DBMS_METADATA Package
  • 10g Performance: Compiler Enhancements Demonstration
  • 10g Compiler Warnings
  • Locate Errors with Oracle10g FORMAT_ERROR_BACKTRACE
  • 10g GET_CPU_TIME
  • 10g FORALL Improvements
  • 10g Regular Expression Support
  • 10g Quoting Mechanism
  • Emailing with Oracle 10g UTL_MAIL
  • 10g Nested Table Enhancements
  • 10g Obfuscation with DBMS_DDL (Release 2)
  • 10g Conditional Compilation
  • Other New Features
• Automating Tasks with the Oracle 10g Job Scheduler
  • Job Scheduler - Concepts
  • Capability Overview
  • Create Schedule & Job
  • OS Scripts
  • Stored Jobs
  • Stored Schedules
  • Job Chaining (Release 2)
  • Event-Based Scheduling (Release 2)
  • Scheduler-Related Dictionary Views
  • Privileges (CREATE_EXTERNAL_JOB, Release 2)
  • Other Release 2 Enhancements
• Managing Oracle Networking
  • New Connect String Support
  • Connecting as SYSDBA
  • Tuning Features
  • Connection Manager Enhancements
• Miscellaneous Oracle10g Features
  • Undo Guaranteed Retention
  • ROLLBACK Monitoring
  • Database High Watermark Recording
  • Database Feature Usage Tracking
  • DROP DATABASE Support
• Oracle 10g SQL*Plus Enhancements
  • Predefined Variables
  • Recycle Bin
  • SPOOL Enhancements
  • Miscellaneous Enhancements