Performance Tuning

ASH	AWR	Disk I/O	Hit ratios	How to start
Indexes	Oracle Wait Interface	Parallel processing	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

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

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