Re: Slow Database

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 18 Feb 2003 06:52:24 -0800
Message-ID: <3E5248A8.88E65C5C@exesolutions.com>

Dimce Tumbov wrote:

> 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

Define slow.
Has it always been slow? If not, slow since when? what actions? Run explain plan?
TK PROF?
DBMS_PROFILER?
How many users?
What size transactions?
How many transactions per time period?
Anyone accidentally run statistics on SYS and SYSTEM?

Daniel Morgan Received on Tue Feb 18 2003 - 08:52:24 CST