Oracle 8.1.5 stored Objects suddenly running slowly ????????????????

From: jason <jfielding_at_trinitech.co.uk>
Date: Fri, 18 Aug 2000 14:05:36 +0100
Message-ID: <8njcb6$fp0$1@trinitech.demon.co.uk>

Hi everyone,
This might be a bit newbie but we don't have a proper DBA here, our stored procedures and functions are suddenly running really really slowly. Queries that were previously taking less than a second are now taking in excess of 3 mins.

I've checked the sys and user tablespaces - all have enough space, I've checked physical disk space, I've checked the 256 mb NT box we're running as the server - it's happilly plodding along using 190 mb but during the 3 mins while the query is being executed, resources get hammered at about 50%.

If anyone can shead any light on why our server is now running like a (3 legged) dog, I would be most grateful.
Cheers
Jason Received on Fri Aug 18 2000 - 08:05:36 CDT