Query went from millisec/exe response time to 1-2 seconds per exe
From: Ethan Post <post.ethan_at_gmail.com>
Date: Wed, 13 Nov 2024 17:38:32 -0600
Message-ID: <CAMNhnU3ffwrwU6y77iwcgB81E0WznKhLjnH_ajOhX4qn4xu0=w_at_mail.gmail.com>
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.
Date: Wed, 13 Nov 2024 17:38:32 -0600
Message-ID: <CAMNhnU3ffwrwU6y77iwcgB81E0WznKhLjnH_ajOhX4qn4xu0=w_at_mail.gmail.com>
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.
[image: image.png]
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 14 2024 - 00:38:32 CET
- image/png attachment: image.png
