Oracle Database 11g: SQL Tuning Workshop :: 11g-TUNING-WRK

ExitCertified US

ExitCertified Canada English

ExitCertified Canada French



	start > courses and registration > training feature sheet

Oracle Database 11g: SQL Tuning Workshop

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

11g-TUNING-WRK

length.

3 days

type.

Instructor-Led

partner.

Oracle

price.

$1,800

The SQL Tuning Workshop class covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Partitioning topics are covered, in addition to taking advantage of hints, bind variables, and different types of indexes.

Learn to:

	Identify Poorly Performing SQL
	Understand the Query Optimizer
	Trace applications
	Monitor SQL execution in real time
	Interpret execution plans

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.

who can benefit

	Application Developers
	Data Warehouse Developer
	Developer
	Support Engineer
	Technical Consultant

prerequisites

	Oracle Database 11g: Introduction to SQL
	Oracle Database 11g: SQL Fundamentals I

skills gained

	Identify problem SQL statements
	Modify a SQL statement to perform at its best
	Trace an application
	Understand how the Query Optimizer makes decisions about how to access data
	Interpret execution plans
	Use optimizer hints effectively
	Generate a load test

suggested next courses

Oracle Database 11g: Performance Tuning

course content details

	Exploring the Oracle Database Architecture

	Oracle Database Server Architecture: Overview
	Oracle Database Memory Structures: Overview
	Background Process Roles
	Automatic Shared Memory Management
	Automated SQL Execution Memory Management
	Automatic Memory Management
	Database Storage Architecture
	Logical and Physical Database Structures

	Introduction to SQL Tuning

	Reasons for Inefficient SQL Performance
	Performance Monitoring Solutions
	Monitoring and Tuning Tools: Overview
	EM Performance Pages for Reactive Tuning
	CPU and Wait Time Tuning Dimensions
	Scalability with Application Design, Implementation, and Configuration
	Common Mistakes on Customer Systems
	Proactive Tuning Methodology

	Introduction to the Optimizer

	Structured Query Language
	SQL Statement Representation, Implementation & Processing: Overview
	SQL Statement Parsing: Overview
	Why Do You Need an Optimizer?
	Optimization During Hard Parse Operation
	Cost-Based Optimizer
	Controlling the Behavior of the Optimizer
	Optimizer Features and Oracle Database Releases

	Optimizer Operators

	Row Source Operations
	Main Structures and Access Paths
	Full Table Scan
	Indexes: Overview
	Using Indexes: Considering Nullable Columns
	Bitmap Indexes, Composite Indexes &Invisible Index
	Guidelines for Managing Indexes
	Clusters

	Interpreting Execution Plans

	Execution Plan
	Links Between Important Dynamic Performance Views
	Automatic Workload Repository (AWR)
	Generating SQL Reports from AWR Data
	SQL Monitoring: Overview
	Reading More Complex Execution Plans
	Reviewing the Execution Plan
	Looking Beyond Execution Plans

	Case Study: Star Transformation

	The Star & Snowflake Schema Model
	Execution Plan Without Star Transformation
	Retrieving Fact Rows from One Dimension All Dimensions
	Joining the Intermediate Result Set with Dimensions
	Using Bitmap Join Indexes
	Star Transformation
	Bitmap Join Indexes

	Optimizer Statistics

	Optimizer Statistics & Types of Optimizer Statistics
	Multicolumn Statistics: Overview
	Expression Statistics: Overview
	Gathering System Statistics
	Statistic Preferences: Overview
	Optimizer Dynamic Sampling: Overview
	Locking Statistics

	Using Bind Variables

	Cursor Sharing and Different Literal Values
	Cursor Sharing and Bind Variables
	Bind Variables in SQL*Plus & Enterprise Manager
	Cursor Sharing Enhancements
	Adaptive Cursor Sharing: Overview
	Interacting with Adaptive Cursor Sharing

	Using Optimizer Hints

	Optimizer Hints: Overview
	Types of Hints
	Specifying Hints
	Rules for Hints
	Hint Recommendations
	Hint Categories
	Optimization Goals and Approaches
	Additional Hints

	Application Tracing

	End-to-End Application Tracing Challenge
	Location for Diagnostic Traces
	What Is a Service?
	Use Services with Client Applications
	Trace Your Own Session
	SQL Trace File Contents
	Formatting SQL Trace Files: Overview
	Invoking the tkprof Utility

	Automating SQL Tuning

	Tuning SQL Statements Automatically
	Application Tuning Challenges
	SQL Tuning Advisor: Overview
	Stale or Missing Object Statistics
	SQL Statement Profiling
	Plan Tuning Flow and SQL Profile Creation
	Database Control and SQL Tuning Advisor
	Implementing Recommendations

Give your team direction. Authorized IT education.

ExitCertified - Oracle 100% Student Satisfaction

Rock solid authorized training. Search all courses now...

	go to top

© 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

sun microsystems training | veritas training | linux training | mysql training | symantec training
oracle training| project management training | ibm training | netapp :: network appliance training