Re: 10g slowdown
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?
2008/12/12 Blanchard William <William.Blanchard_at_kohler.com>
> 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
> Let me know if you need any other info.
> Thank you,
> William B.
-- J.A. van Zanen -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 11 2008 - 22:17:29 CST