10g slowdown
From: Blanchard William <William.Blanchard_at_kohler.com>
Date: Thu, 11 Dec 2008 17:17:48 -0600
Message-ID: <AD7C091172665E4387E4EBA18BFE01F0088C56DD@USWIMS03.kohlerco.com>
Date: Thu, 11 Dec 2008 17:17:48 -0600
Message-ID: <AD7C091172665E4387E4EBA18BFE01F0088C56DD@USWIMS03.kohlerco.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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 11 2008 - 17:17:48 CST