How to tune for "too many" users ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 30 Apr 2003 10:14:22 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7039D9B9F@lnewton.leeds.lfs.co.uk>

Morning Jan,

Statspack.

Install it and run snapshots during the normal times as well as the bad times. Once you have the normal times reported on, you'll know what is different in the bad times. The snapshot reports will show you the top wait events which are where you want to be looking in the first place. Just make sure you have timed_statistics turned on though - otherwise you won't get any idea how bad the waits are.

Unfortunately, most performance tuning is 80% application design, 10% database design, the rest is server performance and database performance.

Cheers,
Norman.

PS. If you have problems reading or understanding the statspack report you can upload it to http://oraperf.com and get an easily readable report back. You have to register but it is free and you will never get spammed !

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Wed Apr 30 2003 - 04:14:22 CDT