Hello All,

I am trying to find out what sql is taking too long and causing my database to hang for 12 minutes and taking up CPU resources. I queried V$sqlarea view and did not get the result I was looking for.

Thank you for your help in advance.