Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
Oracle Database 10g: New Features for Administrators Release 2
 
 
 
 
oracle certified training  
 
code. 10gDB-NF   length. 5 days
type. Instructor-Led   partner. Oracle
price.
$3,000 :: contact for GSA GOV.
 
 
This course introduces students to the new features in Oracle Database 10g Release 2 - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security changes that students need to understand. Hands-on practice sessions give students an opportunity to examine many of the new features, and to practice database administration with Enterprise Manager Database Control.

Learn to:

VLDB Enhancements
Flashback Recovery
Automatic Management
Enhancements to Storage Management
Backup and Recovery Enhancements
Enhancements Space Management


 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 

Database Administrators
Database Designers
Project Manager
Data Warehouse Administrator
Sales Consultants
Support Engineer
Technical Consultant
 
prerequisites
  
 

9i DBA Fundamentals
Oracle9i Database Administration Fundamentals I
Oracle9i Database Administration Fundamentals II
Oracle9i Database: New Features for Administrators
 
skills gained
  
 

Using Database Control to simplify database management
Proactively monitoring the database
Increasing data availability by using improved point in time recovery features
Implementing Automatic Storage Management
Managing Metric Baselines
Using Oracle Secure Backup
Simplifying Instance Configuration
Using Data Pump Export and Import
Configuring the Scheduler
Using the Automatic Workload Repository
Managing Services
Creating Bigfile Tablespaces
Creating Hash-Partitioned Global Indexes
Creating Compressed Backup sets in RMAN
Configuring Flashback Database
Creating the SYSAUX Tablespace


 
course content details  
 


  Installation

Installation New Feature Support
Performance Enhancements to Installation
Checking the Pre-Install Requirements
Management, File Storage, and Backup and Recovery Options
Passwords
Info about installation directories for the DB and EM
Grid control architectures and installation
Distinction between Grid Control and Database Control


  Server Configuration

SYSAUX and DBCA
Using Enterprise Manager: - Command line interfaces: emctl/emca
Database Cloning
Database Feature Usage
Managing Policies
Response File Improvements
Policy Framework
Blackouts


  Data Pump, SQL*Loader, and External Tables

Data Pump: General Architecture
Data Pump Direct Path Considerations
Data Pump Utility: Interfaces and Modes
Data Pump Job Monitoring Views
Data Pump Import Transformations
Using EM to Monitor Data Pump Jobs
Loading Data From Flat Files Using EM
External Table Parallel Populate Operation


  Database and Tablespace Data Movements

Cross-Platform Transportable Tablespaces
Minimum Compatibility Level
Transportable Tablespace Procedure
Dynamic Performance View Changes
Using Enterprise Manager to Transport Tablespaces
Transportable Database
Transport Tablespace From Backup
Tablespace Repository


  Automatic Management

Automatic Database Diagnostic Monitor
Retrieving ADDM Reports Using SQL and EM
Automatic Shared Memory Management (including streams pool)
SGA Advisor
Automatic Optimizer Statistics Collection
Locking Statistics
Automatic Undo Retention Tuning
Automatically Tuned Multiblock Reads


  Manageability Infrastructure

Automatic Workload Repository Data
Active Session History
AWR Snapshot Baselines and Purging Policy
Server-Generated Alerts
Metric and Alert Views
Job Scheduler Concepts
DBCA and Automated Tasks
Dictionary Changes


  Managing Metric Baselines

The Cyclic Nature of Workloads
Thresholds and Metric Baselines
Enable Metric Baselining
Set Adaptive Alert Thresholds
Create Static Metric Baselines
Metric Baseline and Adaptive Threshold Considerations
Classification of Eligible Metrics
Configure Normalization Metrics


  Application Tuning

Automatic Statistics Gathering
Enhanced Query Optimization
Using Enterprise Manager to Gather Dictionary Statistics
Automatic SQL Tuning
SQL Tuning Loop
SQL Tuning Advisor
Concurrency Wait Class: Drill Down
Duplicate SQL page


  System Resource Management

Database Resource Manager
Setting Idle Timeouts
Switching Back to the Initial Consumer Group at End of Call
Creating a Mapping Using Database Control
Using the RATIO Allocation Method
Monitoring the Resource Manager Using EM
Switching Plans at Scheduler Window Boundaries


  Automating Tasks with the Scheduler

Privileges for Scheduler Components
Creating a Scheduler Job
Creating a Job Class
Creating a Window
Managing Jobs, Programs, Schedules, Windows, and Priority
Job chains
Using events


  Space Management

Tablespace Space Usage Monitoring
Shrinking Segments
Automatic Segment Advisor
Fast Ramp-Up
Sorted Hash Cluster
Segment Metadata Dump and Verification


  Improved VLDB Support

Create and maintain bigfile tablespaces
Interpret ROWIDs referencing bigfile tablespaces
Create temporary tablespace groups
Create list-partitioned index-organized tables
Create hash-partitioned global indexes
Partitioned IOT Enhancements
Skipping Unusable Indexes
Bitmap Index Storage Enhancements


  Backup and Recovery Enhancements

New Backup and Recovery Strategy
Flash Backup and Recovery
Best Practices for the Database and Flash Recovery Area
Backup Maintenance
Implementing Fast Recovery
Automated Instance Creation and TSPITR
RMAN Command Changes
Setting Duration and Throttling Option


  Oracle Backup

Installation
Implement the Oracle suggested strategy
RMAN and Oracle Backup
Database Backup/restore to tape
Install Oracle Backup (CLI)


  Flashback Any Error

Flashback Database
Flashback Drop
Recycle Bin
Resource optimized DROP TABLE...PURGE for partitioned tables
Flashback Versions Query
Guaranteed Undo Retention
SCN and Time Mapping Enhancements
Restore Point Usage


  General Storage Enhancements

SYSAUX Tablespace and Occupants
Tablespace Rename
Default Permanent Tablespace
Designating a Default Permanent Tablespace
Copying Files Using the Database Server
Redo Logfile Size Advisor
Dropping an Empty Data File


  Automatic Storage Management

ASM: Key Features and Benefits
ASM Instance Creation
Accessing an ASM Instance
Starting Up and Shutting Down an ASM Instance
ASM Disk Group
ASM Files
Migrate Your Database to ASM
ASM and XML DB


  Maintaining Software

Oracle Database 10g Upgrade Paths
Pre-Upgrade Utility Enhancements
DBUA Advantages
New Post-Upgrade Status Utility
Recompiling Invalid Objects
Performing the Manual Upgrade
OPatch Utility
Support for ASM only upgrade


  Security

Virtual Private Database enhancements
Policy Types
Enhanced Enterprise User Auditing
Transparent Data Encryption
Enhanced Proxy Capabilities
Username and Password in Wallet
OS Audit in XML format
Connect role change


  Services

Traditional Workload Dispatching
Grid Workload Dispatching
High Availability of Services in RAC
Service Aggregation and Tracing
The trcsess Utility
Session-Based and End-to-End Tracing
Using Enterprise Manager to Enable Statistics Aggregation
Using Enterprise Manager to Enable and View SQL Tracing


  Miscellaneous New Features

Transaction Monitoring
Configurationless Client Connect
Resumable Space Allocation Enhancements
Implicit Conversion Between CLOB and NCLOB
UTL_MAIL and UTL_COMPRESS Package
LogMiner Enhancements
Asynchronous COMMIT
Direct Attach to SGA for Statistic Collection



 
Give your team direction. Authorized IT education.


ExitCertified - Oracle 100% Student Satisfaction


find a course
 
phone us
 
view course schedule





Refresh your IT training.

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training |