Perpetual Solutions
Tuition House
27-37 St Georges Road, London
SW19 4DS

+44 (0)20 7620 0033
+44 (0)20 7620 0055

Training Course Outline

IT Vendor Courses Oracle Developer Training Courses

SQL*Plus Performance Tuning

Course Duration: 2 days

Course Code: OSPP

Course Description:

This course is designed for SQL*Plus Programmers, Application Designers/Developers and Technical Support professionals who are required to monitor and tune the performance of an Oracle8i or 9i application. By the end of the course, the delegate will be able to tune applications for optimal performance, optimize SQL*Plus queries for faster access and tune PL/SQL code to reduce disk I/O and reduce network traffic.

Prerequisites:

A working knowledge of SQL*Plus and PL/SQL is required. Attendence on SQL*Plus (OSP) and PL/SQL (OPI).

Prerequisite courses:

SQL*Plus

PL/SQL

This course includes the following modules:

Course topics:

Tuning Methodology
Diagnostic Tools
Understanding the SGA and the UGA and the large pool
Tuning Database Applications
Sizing Extents
Structuring Tables and Indexes for Performance
Monitoring and Tuning Indexes
Structuring SQL Statements for Performance
Tuning SQL Statements
SQL Optimizer
8i and 9i Optimizer and Query improvements
SQL Trace
The tkprof command
Using explain plan
The DBMS_APPLICATION_INFO package
Controlling plan stability with stored outlines
Managing statistics with DBMS_STATS
Optimizing Top Queries
Monitoring Long Running operations
Enforce Data Integrity
Tune PL/SQL Code

Location	Duration	RRP	Jan	Feb	Mar	Apr	May	Jun
Click on course date to make a booking, check availability, or find out about available discounts.
London	2 days	£725		5 - 6	19 - 20		14 - 15	25 - 26

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print Print this course