Oracle Performance Tuning
What you'll learn
- By the end of this course, you will have good idea about various performance issues with Oracle database. This course provide comprehensive material for the performance tuning including:
- • Common Causes of performance issues.
- • Places to check for performance issues.
- • Approach to resolve performance issues.
- • Performance tuning resolution tips.
- • SQL tuning, Instance tuning and miscellaneous tuning techniques.
Requirements
- Basic understanding of Oracle database.
Description
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.
Who this course is for:
- Oracle Database Developers
- Oracle Database Administrators
- Database Architect
Instructor
- Over 16 years of IT experience. Worked in all phases of software development life cycle in multiple domains.
- Proven track record as Udemy Instructor, 1400+ students enrolled in database courses.
- I am regular blogger for various sites and written Oracle/ SQL related articles along with certification tests for Oracle, PMP and more.
- Certifications & Training:
-- AWS Certified Solution Architect Associate
-- CFA Foundation Certificate
-- Oracle Certified Professional
-- MongoDB for Developer
-- SQL Server Internals (SQLSkills - Paul Randal)
-- Data Modelling / Design (Themis Inc.)