Oracle Database 10g: New Features for Administrators Release 2

Revision: TE1912_20060501

(8.62 KB) View, Download, or Print Catalog as a PDF.

Course Length:

5 Days

Course Description:

This course introduces students to the new features in Oracle Database 10g Release 2. Students learn how to use new features to increase database availability, simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and offer simplified database manageability. The course also covers security changes.

Who Should Attend:

This course is for Database Administrators, Data Warehouse Administrators, Database Designers, Project Managers, Sales Consultants, Support Engineers, and Technical Consultants.

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Use Database Control
• Proactively monitor the database
• Increase data availability
• Implement Automatic Storage Management
• Manage Metric Baselines
• Simplify Instance Configuration
• Use Data Pump Export and Import
• Configure the Scheduler
• Use the Automatic Workload Repository
• Manage Services
• Create Bigfile and SYSAUX Tablespaces
• Create Hash-Partitioned Global Indexes
• Create Compressed Backup sets in RMAN
• Configure Flashback Database

Prerequisites:

Students should have taken 9i DBA Fundamentals, Oracle9i Database Administration Fundamentals I, Oracle9i Database Administration Fundamentals II, and Oracle9i Database: New Features for Administrators.

Course Outline:

• Installation
• Server Configuration
  1. SYSAUX and DBCA
  2. Enterprise Manager: - Command line interfaces: emctl/emca
  3. Database Cloning
  4. Database Feature Usage
  5. Managing Policies
  6. Response File Improvements
  7. Policy Framework
  8. Blackouts
• Data Pump, SQL*Loader, and External Tables
  1. Data Pump: General Architecture
  2. Data Pump Direct Path Considerations
  3. Data Pump Utility: Interfaces and Modes
  4. Data Pump Job Monitoring Views
  5. Data Pump Import Transformations
  6. Using EM to Monitor Data Pump Jobs
  7. Loading Data From Flat Files Using EM
  8. External Table Parallel Populate Operation
• Database and Tablespace Data Movements
  1. Cross-Platform Transportable Tablespaces
  2. Minimum Compatibility Level
  3. Transportable Tablespace Procedure
  4. Dynamic Performance View Changes
  5. Using Enterprise Manager to Transport Tablespaces
  6. Transportable Database
  7. Tablespace Repository
• Automatic Management
  1. Automatic Database Diagnostic Monitor
  2. Retrieving ADDM Reports Using SQL and EM
  3. Automatic Shared Memory Management (including streams pool)
  4. SGA Advisor
  5. Automatic Optimizer Statistics Collection
  6. Locking Statistics
  7. Automatic Undo Retention Tuning
  8. Automatically Tuned Multiblock Reads
• Manageability Infrastructure
  1. Automatic Workload Repository Data
  2. Active Session History
  3. AWR Snapshot Baselines and Purging Policy
  4. Server-Generated Alerts
  5. Metric and Alert Views
  6. Job Scheduler Concepts
  7. DBCA and Automated Tasks
  8. Dictionary Changes
• Managing Metric Baselines
  1. The Cyclic Nature of Workloads
  2. Thresholds and Metric Baselines
  3. Enable Metric Baselining
  4. Set Adaptive Alert Thresholds
  5. Create Static Metric Baselines
  6. Classification of Eligible Metrics
  7. Configure Normalization Metrics
• Application Tuning
  1. Automatic Statistics Gathering
  2. Enhanced Query Optimization
  3. Using Enterprise Manager to Gather Dictionary Statistics
  4. Automatic SQL Tuning
  5. SQL Tuning Loop and Advisor
  6. Concurrency Wait Class: Drill Down
  7. Duplicate SQL page
• System Resource Management
  1. Database Resource Manager
  2. Setting Idle Timeouts
  3. Switching Back to the Initial Consumer Group at End of Call
  4. Creating a Mapping Using Database Control
  5. Using the RATIO Allocation Method
  6. Monitoring the Resource Manager Using EM
  7. Switching Plans at Scheduler Window Boundaries
• Automating Tasks with the Scheduler
  1. Privileges for Scheduler Components
  2. Creating a Scheduler Job, Job Class, and Window
  3. Managing Jobs, Programs, Schedules, Windows, and Priority
  4. Job chains
  5. Using events
• Space Management
  1. Tablespace Space Usage Monitoring
  2. Shrinking Segments
  3. Automatic Segment Advisor
  4. Fast Ramp-Up
  5. Sorted Hash Cluster
  6. Segment Metadata Dump and Verification
• Improved VLDB Support
  1. Create and maintain bigfile tablespaces
  2. Interpret ROWIDs referencing bigfile tablespaces
  3. Create temporary tablespace groups
  4. Create list-partitioned index-organized tables
  5. Create hash-partitioned global indexes
  6. Partitioned IOT Enhancements
  7. Skipping Unusable Indexes
  8. Bitmap Index Storage Enhancements
• Backup and Recovery Enhancements
  1. New Backup and Recovery Strategy
  2. Flash Backup and Recovery
  3. Best Practices for the Database and Flash Recovery Area
  4. Backup Maintenance
  5. Implementing Fast Recovery
  6. Automated Instance Creation and TSPITR
  7. RMAN Command Changes
  8. Setting Duration and Throttling Option
• Oracle Backup
  1. Installation
  2. Implement the Oracle suggested strategy
  3. RMAN and Oracle Backup
  4. Database Backup/restore to tape
  5. Install Oracle Backup (CLI)
• Flashback Any Error
  1. Flashback Database and Drop
  2. Recycle Bin
  3. Resource optimized DROP TABLE...PURGE for partitioned tables
  4. Guaranteed Undo Retention
  5. SCN and Time Mapping Enhancements
  6. Restore Point Usage
• General Storage Enhancements
  1. SYSAUX Tablespace and Occupants
  2. Tablespace Rename
  3. Default Permanent Tablespace
  4. Designating a Default Permanent Tablespace
  5. Copying Files Using the Database Server
  6. Redo Logfile Size Advisor
• Automatic Storage Management
  1. ASM: Key Features and Benefits
  2. ASM Instance Creation
  3. Accessing an ASM Instance
  4. Starting Up and Shutting Down an ASM Instance
  5. ASM Disk Group and Files
  6. Migrate Your Database to ASM
  7. ASM and XML DB
• Maintaining Software
  1. Oracle Database 10g Upgrade Paths
  2. Pre-Upgrade Utility Enhancements
  3. DBUA Advantages
  4. New Post-Upgrade Status Utility
  5. Recompiling Invalid Objects
  6. Performing the Manual Upgrade
  7. OPatch Utility
  8. Support for ASM only upgrade
• Security
  1. Virtual Private Database enhancements
  2. Policy Types
  3. Enhanced Enterprise User Auditing
  4. Transparent Data Encryption
  5. Enhanced Proxy Capabilities
  6. Username and Password in Wallet
  7. OS Audit in XML format
  8. Connect role change
• Services
• Miscellaneous New Features