Forum Stats

  • 3,781,584 Users
  • 2,254,530 Discussions
  • 7,879,762 Comments

Discussions

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

2»

Answers

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,648 Red Diamond

    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.