Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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 Sun Aug 20 2000 - 19:13:36 CDT