Re: database slow

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 29 Nov 2004 17:01:59 -0800
Message-ID: <1101776519.403771.225710@c13g2000cwb.googlegroups.com>

Kumar wrote:
> where to check first?. I know there exists a statspack report too.But
> i am confused what could be first step and how to drill down?.Could
> any of you give me some detailed hint.

As well as all the other advice, get this book:

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning.
Richmond Shee, Kirtikumar Deshpande and K Gopalakrishnan are the authors.
Oracle Press. ISBN 0-07-222729-X

It has everything you'll ever need to find out what's ticking, where to look and how to fix. Most complete reference anywhere.
It won't teach you how to write and design like others do, but it will teach you how and where to look for problems and it is not restricted to just one version. Received on Mon Nov 29 2004 - 19:01:59 CST