Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Performance issue 19c

mk270dFeb 20 2024 — edited Feb 20 2024

Hi All,

We have created a new procedure for the Data warehouse. the version of the data warehouse is Oracle 19c. In an Oracle stored procedure, we have 2 inserts and around 10 Merge statements. The procedure was completed within 1 hour till last week(15/02/2023), but after that, the procedure took more time to execute. On every run, a Merge takes more time and on the very next run the same Merge is completed within 5mts but a different Merge is taking time. Is this issue due to environmental problems or am I missing something?

There is no major data changes and the statistics are also up to date. Please comment down if more details are required.

Kindly guide me on this....

Comments
Post Details
Added on Feb 20 2024
0 comments
104 views