Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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
194 views