Sometime SQL queries takes long time to complete. You can check long running sessions using v$session_longops script which will show … Continue reading How to find long running queries in Oracle