Oracle 8.1.5 stored Objects suddenly running slowly ????????????????
Date: Fri, 18 Aug 2000 14:05:36 +0100
Message-ID: <8njcb6$fp0$1_at_trinitech.demon.co.uk>
Hi everyone,
[Quoted] [Quoted] 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
[Quoted] [Quoted] that were previously taking less than a second are now taking in excess of 3
mins.
[Quoted] [Quoted] I've checked the sys and user tablespaces - all have enough space, I've [Quoted] checked physical disk space, I've checked the 256 mb NT box we're running as [Quoted] [Quoted] the server - it's happilly plodding along using 190 mb but during the 3 mins [Quoted] while the query is being executed, resources get hammered at about 50%.
[Quoted] [Quoted] 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 - 15:05:36 CEST