 |
Please contact us
for GSA pricing.
Contract #
GS-35F-0307T
Recent Training Venues Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Vancouver, British Columbia
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- San Diego, California
- Orange County / Los Angeles, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Boise, Idaho
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Annapolis / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Detroit, Michigan
- Grand Rapids, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Fredericton / Moncton / Saint John, New Brunswick
- Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- San Juan, Puerto Rico
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Knoxville, Tennessee
- Memphis / Nashville, Tennessee
- Houston, Texas
- El Paso, Texas
- San Antonio / Austin, Texas
- Dallas, Texas
- Salt Lake City, Utah
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
|
|
Oracle 11g Training: Oracle 11g Performance Tuning |
Course Number: ORC-218
Duration: 4 days
view class outline
Oracle 11g Performance Tuning Training Overview
Accelebrate's Oracle 11g Performance Tuning training teaches attendees how to tune Oracle® using the many levers available. 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. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, 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/?action=category&page=oracle.
Oracle 11g Performance Tuning Training Prerequisites
No prior experience is presumed.
Hands-on/Lecture Ratio
This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.
Oracle 11g Performance Tuning Training Materials
All students receive Apress' Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach and comprehensive courseware.
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 Performance Tuning Training Objectives
All attendees will learn how to:
- Understand the database host system and tune it for optimal performance
- Monitor current database performance
- Tune proactively with Metrics, Alerts and Baselines
- Tune memory and I/O for optimal performance
- Block space usage
- Improve the performance of PL/SQL queries
- Tune performance using Statspack
|
Oracle 11g Performance Tuning Training Outline
- Properly Focusing Database Tuning Efforts
- The Database Tuning Focus
- Comparing Database Applications
- Impact Of Systems Infrastructure
- Impact Of Enterprise Architecture
- Top 10 Oracle Database Mistakes
- Understanding The Database Host System
- Top 3 Host Performance Issues
- The Operating System
- Host System Processors
- I/O Processing
- Oracle Exadata Database Platform
- Assessing Current Database Performance
- About Database Tuning
- Performance Statistics
- Comprehensive Performance Analysis
- Real-Time Performance Monitors
- Real-Time Instance Activity Monitoring
- Drill-Down Real-Time Monitors
- How To Monitor Instance Activity
- Cursor Measures
- Transaction Measures
- Session Measures
- Logical I/O Measures
- Physical I/O Measures
- Net I/O Measures
- Table Measures
- All Measures
- Understanding Statistics and Wait Events
- How Are The Statistics Organized?
- Controlling The Statistics Collection
- Statistics_Level Parameter
- Timed_Statistics Parameter
- Timed_Os_Statistics Parameter
- Examining Current Statistics Collection Settings
- Control_Management_Pack_Access Database Parameter
- Using Operational Statistics
- Using Wait Events
- Using Time Model Statistics
- Interpreting Os Statistics
- Understanding I/O Internals
- Automatic Database Tuning and Awr
- Management and Advisory Framework
- Managing Awr
- About Active Session History (Ash)
- Addm
- Managing Snapshots
- Create_Baseline() and Drop_Baseline()
- Create_Snapshot() and Drop_Snapshot_Range()
- Proactive Tuning With Metrics, Alerts and Baselines
- Metrics and Alert Thresholds
- Managing Metrics
- Using Metric Baselines
- Managing Alerts
- Tuning Memory: The Shared Pool
- More About The Shared Pool
- Diagnose Shared Pool Problems
- Keep Objects In The Shared Pool
- Tuning Memory: The Buffer Cache
- More About The Buffer Cache
- Remedy Performance Issues
- Tuning Memory: Automatic Shared Memory
- Automatic Shared Memory Management
- Using Em and The Memory Advisors
- Tuning I/O: Checkpoint and Redo Tuning
- Tune Redo Writing and Archiving
- Mttr Advisor and Tuning Checkpoints
- Log_Checkpoints_To_Alert
- Additional Redo Tuning Options
- Redo Log Files and 4k Sectors
- Tuning I/O: Database Writes
- Space Tuning: Block Space Usage
- Using The Shrink Space Option
- Using The Segment Advisor
- About Chained and Migrated Rows
- Call Delete_Task()
- PL/SQL Tuning Support From Em
- Application Tuning Setup
- Em Application Monitoring and Tuning
- Performance Tuning Using Statspack
- Install The Statspack Utility
- Create Statspack Snapshots
- Generate Statspack Reports
- Identify The Report Sections
- Conclusion
© 2011 Sideris Courseware Corporation
|
| |
Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.
Oracle® is a registered trademark of the Oracle Corporation 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®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
|
|
