Oracle8I SQL Statement Tuning Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 259
Course Abstract:	This course is tailored for developers to write efficient, well-tuned SQL statements. An in-depth discussion of the Oracle optimizer is considered including cost based optimization, optimization modes and altering behavior of the optimizer. Various utilities which assist in SQL statement tuning are also presented including EXPLAIN PLAN, TKPROF and AUTOTRACE. Special techniques such as histograms and specialty indexes are also considered.
Audience:	This course is designed for Oracle Developers.
Duration:	3 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Examine the execution plan of the Oracle optimizer > Alter the mode and goals of the optimizer > Collect statistics for database objects > Interpret and influence SQL statement execution plans > Exploit Oracle8i plan stability techniques
Course Topics:	UNDERSTANDING THE TUNING ISSUES OLTP vs. Data warehouses Database tuning Infrastructure & network issues SQL STATEMENT EXECUTION Parse phase Execution phase Fetch phase Dedicated server processes Multi-threaded server processes Parallel query processes EXPLAIN PLAN UTILITY Generating the execution plan Viewing the execution plan Interpreting the execution plan COST BASED OPTIMIZER (CBO) Optimization methods Collecting statistics ANALYZE DBMS_STATS() Chained rows COLLECTING STATISTICS Statistics Collection Methods Monitoring Object Modifications Using the DBMS_STATS() Package Using the ANALYZE Command CREATE INDEX...COMPUTE STATISTICS OPTIMIZER OPERATIONS Table scan Join operations Hash operations INDEXES & THE EXECUTION PLAN B-tree indexes Bitmap indexes Function-based indexes OPTIMIZER HINTS USING TKPROF & AUTOTRACE HISTOGRAMS Creating Histograms Data Dictionary Storage USING PLAN STABILITY Preparing for Stored Outlines Creating & Using Stored Outlines Data Dictionary Storage Managing Stored Outlines EDITING PRIVATE OUTLINES Preparing for Private Outlines Creating Private Outlines Editing Private Outlines Utilizing Private Outlines COLLECTING SYSTEM STATISTICS Managing System Statistics Developing a Tuning Strategy EXPLOITING & MANAGING CURSOR SHARING Bind Variables & Cursor Peeking Using the CURSOR_SHARING Parameter UNDERSTANDING THE RULE BASED OPTIMIZER About the RBO Activating the RBO Explicitly How the RBO Works The Access Paths RBO Join Execution Plan Selection TUNING WITH THE RULE BASED OPTIMIZER Correctly Building Indexes Understanding When Indexes Will Be Ignored Rewriting Queries to Avoid Index Suppression Rewriting Queries to Force Index Suppression
Prerequisites:	Introduction To Oracle8i SQL & SQLPlus Introduction To Oracle8i PL/SQL Language Oracle8i Advanced SQL & SQLPlus Oracle8i Architecture For Developers

Oracle8I SQL Statement Tuning Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology