Oracle Performance Tuning

You will get a conceptual understanding of various Oracle database performance issues and learn about different places to check for the performance information along with tuning approach.

Broadly this course will cover following:

1. What are common oracle database performance issues?

2. Where to check for messages / tuning information to get to bottom of issue.

3. Different tuning approaches - based on different databases (OLTP vs Data Warehouse).

4. Learn about database statistics, optimizer and maintenance plan for tables and indexes.

5. SQL and Instance tuning details.

6. General guidelines for avoiding performance issues in Oracle database.