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

One other item to check is to make sure you don't have any screwey triggers running that are locking the tables.

"jason" <jfielding_at_trinitech.co.uk> wrote in message news:8njcb6$fp0$1_at_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 Mon Aug 21 2000 - 02:13:36 CEST