oracle 8.1.5 performance problems

From: tractor boy <gavin_balaam_at_yahoo.co.uk>
Date: 27 Jan 2004 03:45:48 -0800
Message-ID: <17048108.0401270345.539a0832@posting.google.com>

I have a problem with an Oracle 8.1.5 database in that recently the database seems to be running very slowly.

I have tried

1) rebuild indexes
2) Analaysis NT performance
3) checking fragmentation

But it would seem that connecting, selecting data is slow. I spent a couple of days on the net trying find solutions but have not had much success.

Currently exporting a database is horrendously slow, and the tables returned are in a random order.

I have also has suggested that maybe the sys user is casuing problems.

How can I find out if the sys user is causing problems, and how do I fix it?

Any help or guidance would be greatly appreciated Received on Tue Jan 27 2004 - 05:45:48 CST