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 11g: New Features for Oracle 9i DBAs
 
 
 
 
oracle certified training  
 
code. 11g-NF   length. 5 days
type. Instructor-Led   partner. Oracle
price.
$3,000  
 
 
This course introduces students to the new features of Oracle Database 10g and Oracle Database 11g. You will learn how to upgrade from an Oracle9i database to Oracle Database 11g. As a Database Administrator, you learn how to set up and perform typical tasks using the new features available with Oracle Database 10g and Oracle Database 11g including many of the Advisors. Students learn how to use features that increase database availability, simplify overall database management, and improve performance. Hands-on practice sessions provide students with an opportunity to upgrade an Oracle9i database to Oracle Database 11g and use many of the new features.

Learn To:

Upgrade to Oracle Database 11g
Perform typical DBA tasks tailored to an 11g database


 
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
  
 

Technical Administrator
Database Administrators


 
prerequisites
  
 
Required Prerequisites:

Oracle9i Database: New Features for Administrators
Oracle9i Database: New Features for Administrators


 
skills gained
  
 

Upgrade your database from 9i to Oracle Database 11g
Use improved ASM, RMAN, and Flashback features
Use database advisors for proactive database monitoring
Implement improved manageability features simplifying database management
Utilize Enterprise Manager to efficiently manage diagnostic data
Use change management features to master database changes


 
suggested next courses:
  
 

Oracle Database 11g: Performance Tuning
 
related courses, exams and materials
  
 


  before related training and products


  after related training and products


 
course content details  
 


  Planning Your Upgrade to Oracle Database 11g

Steps to Upgrade to Oracle Database 11g
Choosing an Upgrade Method
Performing Character Conversion




  Upgrading the Oracle Database 11g

Installing Oracle Database 11g Software
Applying Oracle Software Patches
Creating a Database




  Real Application Testing

Why Use Database Replay?
Pre-Change Production System
Capture / Replay Considerations
Performing Workload Capture
Performing Workload Replay
Using SQL Performance Analyzer
Using Database Replay to test system changes
Using SQL Performance Replay to test SQL changes




  Upgrading Your Database Using other Methods

Using DBUA to Upgrade the Database
Oracle Database 11g: Upgrade Enhancements
Backing Up the Database Before Upgrade
Using the Preupgrade Information Tool
Using New Postupgrade Status Utility




  Performing Post-Upgrade Steps

Upgrading Server Manager scripts
Performing Additional Upgrade Tasks
Using New Features in Your Upgraded Database
Executing the Postupgrade Script
Upgrading the National Character Set toAL16UTF16
Checking for Unusable Function-based Indexes
Upgrading the Recovery Catalog




   Using EM: Database Control and Grid Control

Administering the Database Using Enterprise Manager: Overview
Using Database Control
Granting Database Control Administrative Privileges
Using Grid Control to Manage Your Environment
Setting Preferred Credentials




  Proactively Maintaining the Database

Oracle Database 11g: Self-Managing Database
Automatic Workload Repository
Job Scheduler Concepts
Server-Generated Alerts
Advisor Framework
Automatic Database Diagnostic Monitor
Configuring Alerts




  Managing System Resources

Database Resource Manager: Concepts (auto enabled)
Using New Features of Database Resource Manager
Exploring Allocation methods
Maximum Estimated Execution Time
Automatic Consumer Group Switching
Using Resource Manager Statistics




  Automating Tasks with the Scheduler

Scheduler Concepts
Using Scheduler Programs
Windows and Resources
Administering the Scheduler


  Managing Memory Structures

Enabling Automatic Memory Management
Modifying Parameters for Automatically Managed Components
Modifying Parameters for Manually Sized Components
Monitoring Automatic Memory Management




  Managing Database Storage Structures

Using the SYSAUX Tablespace
Specifying a Default User Tablespace
Using Oracle Managed Files (OMF
Creating Bigfile Tablespaces
Using Nonstandard Block Sizes
Proactively Monitoring Tablespaces
Using the Redo Logfile Sizing Advisor




  Implementing Automatic Storage Management (ASM)

ASM: Key Features and Benefits
ASM: General Architecture
Accessing an ASM Instance
ASM Administration
Database Instance Parameter Changes
Migrating Your Database to ASM




  Managing Database Space

Understanding Automatic Undo Management
Specifying the Undo Management Mode
Setting the Undo Management Initialization Parameters
Using the Undo Advisor




  Administering Users and Database Security

Unlocking Default User Accounts
Specifying a Common Password for System
Securing access by user
Using Fine-Grained Auditing
Auditing the SYS User
Understanding Changes to the Audit Trail




  Managing Schema Objects

Using Automatic Segment-space Management
Estimating Table and Index Size Before Creation
Granting Object Privileges on Behalf of the Object Owner
Performing Online Redefinition of Tables
Enabling Data Segment Compression
Automatically Collecting Statistics
Using the Segment Advisor




  Accessing and Loading Data

Using Data Pump to Import and Export Data
Managing External Tables
Cross-Platform Transportable Tablespaces




  Performing Backup and Recovery Operations

Using RMAN to Back up the SPFILE
Creating Change-aware Incremental Backups
Encrypting backups
Using backup compression
Using RMAN to Perform Recovery: Automatic File Creation During Recovery
Performing Trial Recovery
Enabling and Performing Flashback Database




  Recovering From User Errors

Using Flashback Query
Auditing and Recovering Transactions Using the Flashback Transaction Query Feature
Retrieving Row History Information Using the Flashback Version Query Feature
Recovering Table Data Using the Flashback Table Feature
Recovering Dropped Tables using Flashback Drop Feature
Flashing back a transaction
Using LogMiner Enhancements




  Managing Performance

Using the SQL Tuning Advisor
Using the SQL Access Advisor
Using the trcsess Utility to Consolidate Output from Trace Files
Using DBMS_MONITOR




  Diagnosability Enhancements

Oracle Database 11g Fault Management
Ease Diagnosis: Automatic Diagnostic Workflow
Automatic Diagnostic Repository
Incident Packaging Configuration
Running Health Checks
Using the SQL Repair Advisor
Viewing, Disabling, or Removing a SQL Patch




  Miscellaneous New Features

Managing & Using SQL Query Result Cache
Adaptive Cursor Sharing: Architecture
Temporary tablespace shrinkage
Using the client result cache





 
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 | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware