Hi all,
I kicked some procedures off 5 hours ago. Normally they wouldn't take more than 45 min to run. It is still running and my sqlplus session screen is blank.
How do I check what is going on? How to find out why they hung?
Thank you.
p.s. the quick solution is to kill those sessions but I though I may nee to do some investigation before.