Re: 10g slowdown
- From: "Jack van Zanen" <jack@xxxxxxxxxxxx>
- To: William.Blanchard@xxxxxxxxxx
- Date: Fri, 12 Dec 2008 15:17:29 +1100
are you saying that a query on a single table takes 6 hours?
How big is the table in GB/TB?
Jack
2008/12/12 Blanchard William <William.Blanchard@xxxxxxxxxx>
> We have a query that began taking a long time about a week ago. The
> program, in SAP, ran for 10 - 15 minutes but is now taking about 6 hours.
> The table has 5.1 million rows. The explain plan shows a simple index range
> scan. We just reran statistics on the table and all indexes but no luck We
> are concentrating on the one query that took about 4.75 hours.
>
> Does anyone see something glaring or know of a simple test to locate the
> problem?
>
> Let me know if you need any other info.
>
> Thank you,
>
> William B.
>
--
J.A. van Zanen
Other related posts:
