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)

Can some one assist me on how do I find what's running on the background and how do I troubleshoot ?
Thanks in advance.