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

You may check one or a combinations of following areas:

1. Checked your SQL statement(s) that are accessing data within tables.
2. Check your SQL statements outside of your stored procedures and/or functions.
3. Perform query optimization of your SQL statements outside of your stored procedures and/or functions. You can visually check your SQL statements for the performing of full-table scans. If you cannot determine the access and/or process methods being used by the database on a visual basis, use EXPLAIN PLAN to determine how the database is accessing or processing your SQL statement.

If the problem still exist after performing steps one through three, go to step four.

4. Checked the indexes on the tables that are being accessed by your stored procedures and/or functions. If an index

    does not exist on a table, place an index or indexes on the table.

If all fails, perform step five.

5. Checked the size of your SHARED_POOL_SIZE.

I may have missed a few steps or troubleshooting methods so if someone else notices a few steps or troubleshooting methods that I have missed, please post them.

Kevin

"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 - 09:10:59 CDT