Forum Stats

  • 3,837,534 Users
  • 2,262,268 Discussions
  • 7,900,315 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,833 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.