|
|
Overview
This course explores both issues and analysis of database performance, and then focusses
on the tuning of Oracle SQL Language to improve performance. You will gain experience in
the cost based and rule based optimisers, and Oracle utilities that are provided to allow
the tuning of SQL code. A performance tuning text book is provided with the course.
Available as a public or closed course at our London training centre, or can be tailored
to your team's requirements and delivered onsite as a bespoke, customised training 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
Target Audience
The course is suitable for experienced database administrators and any personnel involved
in the maintenance or development of Oracle applications and databases.
Course Requirements
Delegates should have a good background knowledge of their operating system, SQL*PLUS and
PL/SQL.
Course Objectives
At the end of the course the delegate should be able to:
Associated Course(s)
Oracle 8i Development
Database Architecture Overview
The components of the Oracle Database
How Each Component Relates to the Performance of the Database
Designing a Monitoring regime.
The importance of a Regular Monitoring Regime
The Areas Which Should be Monitored
Performance tuning
How to performance Tune
The Init.ora Parameters
Analysing the database
Using UTLBSTAT and UTLESTAT
Using the Data Dictionary
Optimising Memory usage
Identifying Cache Hit Rates
Sizing the SGA
Optimising I/O Activity
Identifying I/O Bottlenecks
Positioning and Striping Data Areas
Effects of RAID
Identifying tuning Contentions
Wait states and Latch Contentions
Identifying Background Process Contentions
Avoiding Contentions
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
Table Storage Parameters and their effects on performance.
Optimising Sub-queries & PLSQL usage.
Optimising Sorts
HAVING, UNION, INTERSECT, MINUS, DISTINCT, GROUP BY
Optimising Data Manipulation
INSERT, UPDATE, DELETE
Miscellaneous Issues
Partitioning
Sequences
Views & Snapshots
Parallel Processing
Case Studies