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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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