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

You might want to check your physical table-structures (e.g. do they contain redundant information? Are some tables static/dynamic? do views (stored objects) contain fully loaded tables? (for example... employees... shouldn't all be stored in the virtual memory, only the ones needed for the view)...

maybe upgrade your serveR???

Instead of using Oracle8i you might want to change to MySQL, running on a Linux server (increases accestime and security (and most import: totally free)

Kris

jason <jfielding_at_trinitech.co.uk> schreef in berichtnieuws 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 Sat Aug 19 2000 - 20:34:27 CEST