Database and Reporting Training     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
Crystal Reports Training * MySQL Training * Oracle Training * SQL Server Training * Live Online Training


* Introduction to Oracle 11g SQL training
* Beginning and Advanced Oracle 11g PL/SQL training
* Oracle 11g Administration I training
* Oracle 11g Administration II training
* Oracle Data Warehousing and Warehouse Builder training
* Oracle 11g Backup & Recovery training
* Oracle 11g Features for Administrators



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary Database & Reporting Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour database or reporting training seminar. For more details, please contact us today.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Sacramento, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

 

Oracle Administration Training: Oracle 11g Administration II
Print This Outline
E-mail This Outline
Get A Quote
Course Number: 575
Duration: 5 days
view class outline

Oracle 11g Administration II Training Overview

This advanced Oracle 11g administration training course teaches attendees advanced Oracle 11g administration skills necessary for enterprise environments.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/database.htm.

Oracle 11g Administration II Training Prerequisites

Oracle 11g Administration I training or equivalent experience.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.

Oracle 11g Administration II Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

  • A complete installation of Oracle 11g

Please contact us for detailed setup instructions if you have purchased this class.

Oracle 11g Administration II Training Objectives

All attendees will learn how to:

  • Explore automatic database management, monitoring and tuning facilities
  • Use Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability
  • Control resource utilization on database servers whose resource demand exceeds its capacity
  • Automate launching routine maintenance tasks and even application functions using the database Scheduler
  • Handle database corruption
  • Utilize diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data
  • Automate resumption of database operations even in the face of failures and errors
  • Set up user-managed and automatically managed backup strategies and database recovery operations
  • Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others
  • Explore Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager

Oracle 11g Administration II Training Outline

  • Managing Memory
    • About Manual Memory Management
    • Automatic Memory Management
    • Memory_Target
    • Memory_Max_Target
    • Sga_Target
    • Sga_Max_Size
    • Workarea_Size_Policy & Pga_Aggregate_Target
    • Using EM & The Memory Advisors
    • Monitor In Memory Access Mode
  • Managing Storage & The Segment Advisor
    • Monitor Tablespaces
    • About Resumable Space Allocation
    • Table Storage Management
    • Pctfree Illustrated
    • Use The Segment Advisor
    • Using The Shrink Space Option
    • Cascade To Dependent Objects
    • Optionally Call Delete_Task()
  • Managing Resources
    • Database Resource Manager Architecture
    • Consumer Groups
    • Resource Plans
    • Automatic & Adaptive Consumer Group Mapping
    • Activating Plans
    • Monitoring Resource Allocation
    • Explicit Consumer Group Switching
  • Automating Tasks With The Scheduler (Basic)
    • Scheduler Architecture
    • Rac Environment
    • Manage Programs
    • Manage Schedules
    • Manage Jobs
  • Automating Tasks With The Scheduler (Advanced)
    • Manage Job Classes
    • Manage Windows & Window Groups
    • Manage Chains
    • About Events & The Scheduler
  • Globalization
    • Globalization Settings
    • Nls_Lang
    • Nls_Language & Nls_Territory
    • Date & Time Localization
    • Linguistic Indexes
    • About Locale Builder
  • Diagnosing Database Problems
    • About The Fault Diagnosability Infrastructure
    • ADR Highlights From EM
    • Using The Alert Log
    • About The Trace Files
    • Database Instance Health Snapshot
    • Using The Support Workbench
    • Enable Oracle Configuration Manager
  • Automatic Storage Management
    • ASM & The Broader Database Architecture
    • Creating The ASM Instance
    • Administering The ASM Instance
    • Sysasm Super Administrator
    • ASM Storage Parameters
    • Using DBCA
    • Using ASMcmd
    • Configuring Databases For ASM Storage
    • DBCA
    • DBUA
    • ASM Migration Using EM
  • Recovery Concepts
    • About The Backup & Recovery Structures
    • Managing Redo Data
    • Is Log_Buffer Large Enough?
    • What V$Log Reveals
    • What V$Log_History Reveals
    • What V$Logfile Reveals
    • What V$Archived_Log Reveals
    • Managing Archived Redo Data
    • Archivelog Status
    • Creating A Foundation For Sound Recovery
  • Oracle Flashback Technology
    • About Flashback Technology
    • Flashback Query
    • Select...As Of Timestamp
    • Select...As Of SCN
    • Using Dbms_Flashback()
    • Configuring Undo Management For Flashback
    • Undo_Retention
    • Flashback Table
    • Flashback Drop
    • Flashback Versions Query
    • Flashback Transaction Query
    • Flashback Transaction Backout
  • Flashback Database
    • About Flashback Database
    • Configuring The Flash Recovery Area
    • More About Db_Recovery_File_Dest
    • Performing Database Flashback
    • Monitoring Flashback Performance
    • Flashback Database Considerations
    • Configure Flashback Data Archive
  • Instance Recovery
    • About Instance Recovery
    • Smon Process & Instance Recovery
    • Pmon Process & Process Recovery
    • Instance Recovery Parallelism
    • Changing Recovery_Parallelism
    • Mttr Advisor & Tuning Checkpoints
    • Log_Checkpoints_To_Alert
    • Redo Logfile Size Advisor
    • Fast-Start On-Demand Parallelism
  • Configuring RMAN
    • RMAN Architecture
    • RMAN Sample Backup Session
    • Launch & Use RMAN
    • Configure RMAN Settings
    • Allocate RMAN Channels
  • Backup With RMAN
    • About Backup File Types
    • Performing Full Backups
    • Performing Incremental Backups
    • Establishing A Backup Retention Policy
    • Generate Reports
    • Report Unrecoverable
    • Report Need Backup
    • List Incarnation
    • Validate Backup Data Integrity
  • RMAN Management With EM
    • Monitoring The Flash Recovery Area
    • The EM Interface To RMAN
    • Scheduling RMAN Backups
    • Using The Oracle-Suggested Backup Strategy
    • Manage Current Backups
    • Backup Reports
    • Manage Restore Points
  • User-Managed Recovery Operations
    • Recovery Concepts
    • Recover Temporary Tablespaces
    • Recover Read-Only Tablespaces
    • Recover Index Tablespaces
    • Recover Redo Log Group Member
    • Recreate The Password File
  • Recovery With RMAN
    • Complete Media Recovery
    • Incomplete Media Recovery
    • TSPITR
    • DBPITR
    • Recovery Using EM
  • Using The RMAN Recovery Catalog
    • Configuring The Recovery Catalog
    • Using A Virtual Private Catalog
  • Advanced RMAN Capabilities
    • Backup Set Encryption
    • RMAN Duplicate Database
  • Conclusion

© 2008 Sideris Courseware Corporation
 
Print This OutlineE-mail This OutlineGet A Quote

Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

MySQL™ and all MySQL-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the U.S. and other countries.

Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.
 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!

VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK
About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Database and Reporting Training