Dan offers training for both the advanced developer and/or DBA
and for those who are new to the Oracle RDBMS or to expand the knowledge of
those group of users known as 'Power Users'.
My pricing model is 1 course fee for up to 15 attendees.
This course fee is comparable to what others charge for 2 to 4 attendees.
The course fee includes the use of my portable computer lab. Course guides
are priced separately per attendee and vary by course offering. Many of
these courses also have an optional book on a related topic.
This training is in the form of workshops with hands-on
lab exercises. www.DanHotka.com is
completely portable and can be scheduled on-site. This format
eliminates the expenses and issues of sending employees away for training.
Attendees will receive hands-on training using the latest Oracle development
tools. The knowledge learned can
easily be utilized in your companies purchased tools, current freeware tools, or manual methods such as SQL*Plus.
The attendees will also receive a study guide packed full of examples and course
exercises that emphasize the learning process.
These classes are
available on-site, in your own training center or conference room.
Attendees Receive:
- Study guide with presentations and relevant white
papers
- Most workshops include a relevant book
- Diskette full of course example SQL and SQL*Plus
scripts
- Opportunity to ask the tough Oracle questions
download a
summary of these workshops.
Jump to Business Intelligence Courses
Jump to Additional Course Offerings
Oracle SQL Performance Tuning Tips and
Techniques
The focus of this tuning course is to illustrate
coding techniques that insure a consistent response time between instances and
releases of the Oracle database. This
course works closely with performance tuning of actual SQL statements as well as
covering a variety of Oracle Server tuning topics.
Both
of these courses are available over the web!
There
are 2 options for this course:
This course is designed for the Oracle
professional with novice or no SQL tuning skills.
The focus of this tuning course is to cover
advanced SQL performance tuning topics for those Oracle professionals that
already have a SQL tuning background. This
course is perfect for DBA’s that need the additional background to solve the
more difficult problems.
These
courses can be combined for a 3-day on-site or a 5-day web-based class.
Oracle SQL Performance Tuning
for Developers
This course is designed for the Oracle professional with
novice or no SQL tuning skills.
The course starts out with a complete overview of the
Oracle architecture so students can get an understanding how their SQL and
applications can take advantage of the computing environment.
This course goes in-depth on understanding and controlling the explain
plan (how Oracle retrieves data and in what order).
The discussions include the differences of the various Explain Plan steps
such as Merge-Join and Nested-Loop, and when is it best to use each.
Dan goes into considerable detail, with SQL examples, on how the
optimizers (both rule-based and cost-based but mostly cost-based) make their
decisions. Students will work with
a variety of SQL statements, reviewing explain plans and making changes to make
these SQL statements perform better. Lectures
include index design, using hints and coding style to control the explain plans,
and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL
profiler. This course takes a close
look at indexes: how Oracle selects them, why they are sometimes not used, and
how to tell if indexes are being used/not being used.
The focus this course is tuning SQL via coding style.
The instructor finds that tuning in this fashion maintains the
performance of the SQL when migrating to other Oracle environments (upgrades to
newer releases).
Lectures and topics are enhanced with live illustrations
and hands-on exercises.
Topics covered includes:
- Oracle
Architecture from a SQL Performance point-of-view
- Understanding
SQL Tuning Statement Topics
- Reading
Explain Plans/Understanding Explain Plans
- Controlling
both the Cost-based and Rule-based Optimizers
- A
close look at Indexes – how they work and how they are selected
- SQL
Tuning via coding style/SQL Coding tips
- Oracle
Trace Facility - collecting SQL and interpreting using TKProf
- Profiling
PL/SQL
- PL/SQL
Coding Tips
Download
a course description
Oracle
SQL Tuning for Developers over the Web
Oracle
SQL Tuning for Developers 2-day
Advanced Oracle SQL Performance Tuning
Topics
The focus of this tuning course is to cover advanced SQL
performance tuning topics for those Oracle professionals that already have a SQL
tuning background. This course is
perfect for DBA’s that need the additional background to solve the more
difficult problems.
This course covers a number of advanced topics such as
Index clustering factor, Oracle10g Tablespace options that affect index
performance, various Oracle traces including the 10053 Cost-Based
Optimizer trace and sizing the SORT_AREA_SIZE and HASH_AREA_SIZE using
the 10053, 10033, 10034, and 10104 traces.
Lectures include an in-depth look at various SGA structures such as
buffer cache options and sizing, library cache and cursor sharing, and Oracle
fragmentation and locking issues/data block internals.
Students will also experience how to monitor their application
environment, their indexes, and see how to find problem SQL in their
applications using Stats Pack, SQL Trace, AWR, SQL Tuning Advisor, and the V$
dictionary tables (using a variety of supplied SQL*Plus scripts).
This course takes a close look at indexes: how Oracle selects them, why
they are sometimes not used, and how to tell if indexes are being used/not being
used.
Lectures and topics are enhanced with live
illustrations and hands-on exercises.
This course shows how to use TOAD, SQL Developer
and SQL*Plus for SQL Performance Tuning.
Topics covered includes:
- Oracle
Architecture from a SQL Performance point-of-view
- Review
of Reading Explain Plans/Understanding Explain Plans
- Review
of CBO Hints
- A
close look at Indexes – how they work and how they are selected and
advanced topics such as clustering factor and other reasons indexes may NOT
be selected
- Oracle
Trace Facility/Stats Pack/Wait Events
-
Tracing wait events back to the problem SQL
- Oracle
AWR and new tools such as SQL T are covered
- Profiling
PL/SQL and PL/SQL Coding Tips
- Oracle10g
Tablespace options that affect indexes
- Oracle
Data Block internals and fragmentation review
- Finding
various problems using the V$ Dictionary Tables with scripts
- SGA
Topics include:
o
Buffer Cache options
and sizing
o
Library Cache utilization/internals including cursor-sharing
topics
o
Oracle11g Result Cache
Download
a course description
Advanced
Oracle
SQL Tuning over
the Web
Advanced
Oracle
SQL Tuning 2-day
Advanced PL/SQL Tips and
Techniques (3-days)
