Oracle Performance Tuning



Last updated on May 4th, 2017 at 05:33 pm

Oracle Performance Tuning  is very important part. It is not just the DBA responsibility ,it is also the responsibility of Oracle developers.Performance tuning should starts before Design and should be continuously tested. We need to have good Knowledge of Oracle Software working. Many times problems occurs as we are not aware of the working of the Oracle

In this section,We are presenting the Oracle performance tuning articles which will help u in solving the problems quickly

Tuning Tools

Tuning Tools
Autotrace Utility
Oracle Performance :sql_trace parameter and its impact
How to turn on the trace in database and Format the trace file
How to run sql tuning expert for particular sql -d in the Cursor cache

Performance Terms explained

What is Logical I/O and Physical I/O in Oracle Database
how to find session generating lots of redo
What is IOPS and How to calculate it in oracle
What is DB time and Average Active sessions, Active session in oracle
Performance Lesson :What is a Bind Variable
How to create ADDM task and check its report
ASH decoded
All about AWR ( Automatic Workload Repository)
Oracle DBA: Hanganalyze and system state dump
Oracle waits events Part 1
Oracle waits events Part II
Oracle waits events Part II
How to find which sid is doing full table scan

Optimizer

New Optimizer Feature with 11g
How to use Optmizer hints
Optimizer Mode
Oracle DBA: Joins Method in Oracles

Statistics

Find indexes and assigned columns for a table
How Table Monitoring and STATISTICS_LEVEL parameter are connected from 10g onwards
How to check Stale statistics
How to find table where statistics are locked

General Performance topics

Sql performance tuning
Sql performance tuning quiz
Nested Loop Join in Oracle 11g
Hash join in Oracle with example
Oracle performance tuning examination part 3
Oracle performance tuning examination part 2
Oracle performance tuning examination part 1
How Oracle Index clustering factor is calculated
How to turn on the SQL trace, 10046 event in Oracle database and trcsess, tkprof utility
Incremental Statistics Gathering in 11g
Top Useful scripts for Oracle Database for Monitoring purpose
Oracle Enqueue and locks(Oracle table locks): How it works