Oracle8i SQL Statement Tuning

This 3-day 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. On course completion students 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

 
key facts buy online

• code: d046eng
• 3 days
• Download outline
• Print licence available

Student edition
• A4 format
• A5 format
Instructor edition
• A4 format
• A5 format

Target audience

This course has been developed for Oracle developers. Students should have attended the following courses or have equivalent knowledge and experience:

  • Introduction To Oracle SQL & SQL*Plus
  • Introduction To Oracle PL/SQL Language
  • Introduction To Oracle Advanced SQL & SQL*Plus
  • Oracle8i Architecture For Developers
Course content

Partitioned tables and indexes

Advanced queuing

Advanced index

Advanced table management features

Database migration

Advanced program units

Large objects (LOBS)

Manipulating large objects (LOBS)

Object database features

Collections

Enhancing groups with ROLLUP and CUBE

Using the database loader Using the loader • LOAD1.CTL Control File • Understanding the loader process • Control file options • Direct path loads • OEM data manager, load

Managing physical storage of objects About physical storage • Storage specification and performance parameters • Table physical storage • Create table with Physical Storage Format • Finding chained rows • Index physical storage

Managing clusters Understanding clusters • Creating a cluster • Data Dictionary, USER_CLUSTERS • Dropping a cluster

National Language Support (NLS)

Invoking external procedures About external procedures • Registering with the database • Calling the external procedure

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today

A gtslearning business division :: gtslearning CompTIA learning solutions ::Contact us :: Site map
© gtslearning, 2008. All rights reserved. Ownership of all trademarks and service marks is observed and respected.