IFS Performance Tuning

This course is an introduction into database performance tuning for a Foundation1-based business application. It is an introduction to the Oracle tuning tools and procedures.

WHO SHOULD ATTEND?

This course is strongly recommended for IT personnel responsible for maintaining and administering an IFS Applications system.

PREREQUISITES

Basic Oracle knowledge is highly recommended. The IFS DBA Workshop is recommended, but not required.

VERSION

Latest released version unless otherwise noted

LENGTH

2 days

COURSE DESCRIPTION

After this course, participants should be able to do Oracle database tuning following the Oracle performance methodology.

Topics include:

• Oracle tuning tools
• Performance planning
• Instance tuning
• When to tune
• V$ Performance Views
• Oracle StatsPack & Automatic Workload Repository
• Optimizer Statistics
• Tips and tricks