Slow Database

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 18 Feb 2003 13:57:08 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703517998@lnewton.leeds.lfs.co.uk>

Hi Dimce,

install statspack, and take a few snapshots while the performance is slow. Once you have done this, run off a report and check out what the top wait events are - then tune them out. Make sure you have TIMED_STATISTICS = true though, otherwise you won't see which of the wait events is hogging the most time.

Statspack has docs at $ORACLE_HOME/rdbms/admin/spdoc.txt.

The top level creation script is $ORACLE_HOME/rdbms/admin/spcreate.sql and the report is $ORACLE_HOME/rdbms/admin/spreport.sql

Once you get the hang of StatsPack, you'll just love it !

Cheers,
Norman.

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


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

-----Original Message-----
From: dtumbov_at_mt.net.mk (Dimce Tumbov) [mailto:dtumbov_at_mt.net.mk] Posted At: Tuesday, February 18, 2003 1:35 PM Posted To: server
Conversation: Slow Database
Subject: Slow Database

I have problem that my Oracle 8i (8.1.7) database is rather slow. There are no differences between schemas, all the schemas are equally slow. For example simple browsing through the data or through the structure of the database is veeeeeeeeeery slow.

Some hints where could I more investigate would be appreciated.

thanks,
Dimce Received on Tue Feb 18 2003 - 07:57:08 CST