What You’ll Learn
This course is designed for Database Performance Tuning Overview ,Oracle Internal flow of SQL ,DML Statement ,Introduction of Performance Tuning Tools,AWR ,ADDM and ASH Analysis ,Identify Top consuming process,Memory Tuning of Database ,Performance Health check of Database ,Explanation of some important Database Events and Trace file Analysis .After completing this course, Students will be able to carry out: Troubleshooting of all type of performance issue quickly,diagnose and solve sudden slowdown and Analysis of Top process which consume high resource and Memory and Redo log Tunning of Database and Tuning of other parameter of Database.
Oracle Database Performance Tuning
Important Links for Performance Tunning
BASIC SQL
- Oracle Database Performance Tuning Overview
- Oracle Database Internal
- Oracle Memory Evaluation from 8i to 12c
- Oracle Database Wait Event
- Oracle Performance Tuning Technique
- AWR ,ASH and ADDM Analysis
- Oracle Memory Tuning And Instance Tuning
- Redo Log Tuning
- Index Rebuild Concept and Test Case
Advance Database Performance Tools
- Understanding SQL Tuning Tools
(Explain Plan ,Trace and TKPROF) - Oracle DBA Performance Tuning real time scenarios
- Performance Diagnostic by Oracle Enterprise Manager -OEM
- Various OS Commands For Identifying Bottleneck
- Understanding of RDA and OSWATCHER
