Re: 10g slowdown

 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_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
> problem?
>
> Let me know if you need any other info.
>
> Thank you,
>
> William B.
>

-- 
J.A. van Zanen

--
http://www.freelists.org/webpage/oracle-l