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.
Basic Oracle knowledge is highly recommended. The IFS DBA Workshop is recommended, but not required.
Latest released version unless otherwise noted
After this course, participants should be able to do Oracle database tuning following the Oracle performance methodology.
- Oracle tuning tools
- Performance planning
- Instance tuning
- When to tune
- V$ Performance Views
- Oracle StatsPack & Automatic Workload Repository
- Optimizer Statistics
- Tips and tricks