Objectives
To enable the tuning of Oracle SQL Language to improve performance. The course takes you through the cost based and rule based optimisers and Oracle utilities that are provided to allow the tuning of SQL code. The course is organised into chapters covering the What you will learn in a lecture format interspersed by sets exercises designed to illustrate the points covered and are completed by the delegate. A performance tuning text book is provided with the course.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
2 Days
Who Should Attend
The course is suitable for any personnel involved in the maintenance or development of Oracle applications and databases and for users with some technical knowledge who wish to extend that knowledge and for end users who wish to construct their own reports.
Pre-Requisite Skills
Delegates should have a good knowledge of their operating system, SQL*PLUS and PL/SQL and the Oracle 9i database.
What You Will Learn
1. Tune SQL code to optimise performance
and cache usage.
2. Use the Explain plan command and interpret its output.
3. Use the SQL Trace & TKPROF facilities and interpret their output.
Associated Course(s)
What is the tuning process?
Cursors.
Using Bind & Lexical Variables.
Parsing, Optimisers and using Hints.
Indexes & Indexing
· Concatenated indexes
· Index merges
· Nulls, Clusters & foreign key lookups
· B*Tree, Function based Indexes, Index organised tables and Bitmap indexes
· Full table scan V's Index Lookup
Using Explain Plan
Using SQLTRACE & TKPROF
|
|
|