Re: Query went from millisec/exe response time to 1-2 seconds per exe

I can't recall a time when I have ever seen query performance change and it only be CPU time when the query and the plan have not changed. I have a lot of history and it is running with the same plan as it always has. No indexes were touched, the table was not purged or anything. It is a large 100+ GB table. Anyone seen this type of thing and have any ideas as to what might cause this? OCI cloud and only this query so not a CPU changed behind the scenes - in the cloud thing.

Can you do SQL trace of the query in question? Maybe there is a data anomaly,  one of the participating tables may contain much more data than is usually the case.  This sounds like an Agatha Christie mystery, but without the access to the database not even Poirot could resolve the problem.

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





image/png attachment: image.png