Skip to Main Content

Query gets hanged during first of month

User_DDYV1Mar 2 2022 — edited Mar 2 2022

Hello, I have a oracle query (merge statement) that runs every day. But during the first few days of the month , it gets hanged whereas other days it is fine.
I tried running manually and the execution time is done but this screen stay for a long time (more than an hour)
image.png
Can some one assist me on how do I find what's running on the background and how do I troubleshoot ?
Thanks in advance.

Comments
Post Details
Added on Mar 2 2022
8 comments
48 views