Oracle APEX - How to deal with Unresponsive Page when executing in SQL Command ?

Billy Verreynne

Jasper, the v$session view has columns indicating the session (if any), blocking the current session.

Remember that hitting the db reset button, effectively destroys the runtime context and data required for root cause analysis - and usually leaves you blind from preventing the problem in future.