Performance Tuning

ASH
ASH
AWR
AWR
Disk I/O
Disk I/O
Hit ratios
Hit ratios
How to start
How to start
Indexes
Indexes
Oracle Wait Interface
Oracle Wait Interface
Parallel processing
Parallel processing
Statistics
Statistics

Last updated scripts

Recently added scripts to the site:

Transfer oracle sql profiles between two databases.  Added: 2015-03-29 19:58:47
Rollback statistics  Added: 2013-12-20 06:01:03
Create stored outlines for changing explain plans  Added: 2012-11-26 12:11:18
Create an Oracle SQL TUNING TASK manually with the sql_id  Added: 2012-11-23 18:22:37
Table space vs index space  Added: 2010-11-03 09:13:23
PX Deq wait events  Added: 2010-08-05 13:08:09
FLEXCUBE, gather statistics without using histograms.  Added: 2010-07-09 15:37:25
Estimate statistics for oracle subpartitions  Added: 2010-07-07 08:39:18
Global cache cr request  Added: 2010-06-26 19:15:42
Transfer partition statistics to another partition  Added: 2008-11-26 17:25:16
Tablespace Disk I/O  Added: 2008-10-13 13:23:21
Find unused indexes with STATSPACK  Added: 2008-07-30 13:06:05
Library load locks  Added: 2008-07-28 14:01:38
Library cache wait events  Added: 2008-07-28 11:14:16
Direct path write  Added: 2008-07-26 20:30:25
Direct path read  Added: 2008-06-03 12:50:39
Reset the max_wait column on v$session_event  Added: 2008-06-02 15:15:22
How to setup parallel in an SMP Server  Added: 2008-05-30 14:44:43
Latches  Added: 2008-05-29 12:02:09
User sessions hit ratios  Added: 2008-05-15 13:26:12
Average length of the dirty buffer write queue  Added: 2008-05-15 13:21:33
Db file scattered read  Added: 2008-05-13 13:01:19
Db file sequential read  Added: 2008-05-13 09:55:16
Column selectivity  Added: 2008-04-09 12:48:06
Concatenated index columns order  Added: 2008-04-08 13:56:40
Fast index rebuild  Added: 2008-03-31 19:57:18
Compare historic executions plans  Added: 2008-03-21 12:25:26
Buffer busy waits by files  Added: 2008-03-09 17:03:57
Find unused indexes with MONITORING USAGE clause  Added: 2008-03-05 11:53:19
Hot file writes using AWR  Added: 2008-03-04 13:24:44
Categories
Filters
Search