Re: How to measure Oracle Database Performance?

max,

OK, here is a tip. Use Oracle trace on a typical user session, or query the SGA to find some typical SQL (look for something your users run a lot). Take these SQL queries and put them in an OS script or PL/SQL procedure, I'd suggest putting each query in twice to avoid discrepancies caused by buffers/caches. Now run this at different times during the day and get some typical timings for your system under different loads. You now have a simple benchmark you can use to test out how changes affect system performance!

Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"M.a.x G.e.decke" <spam_at_gedecke.de> wrote in message news:ajitrq$16uk$1_at_redenix.uni-muenster.de...
> Thanx very much for your fast reply. But I would really appreciate it, if
> somebody has a tip which saves me the 45 $ for the book. :-)
>
> max
>
> "Fraser McCallum" <fmcc_at_removetoemail_odbaguru.com> schrieb im Newsbeitrag
> news:oo579.7518$g9.25338_at_newsfeeds.bigpond.com...
> > max,
> >
> > I'd suggest getting hold of a copy of "Scaling Oracle8i" by James Morle
he
> > covers benchmarking very thoroughly in chapter 3 and the rest of the
book
> is
> > well worth reading also!
> >
>
>
>
Received on Sat Aug 17 2002 - 07:07:27 CDT