If you have paid for the diagnostics pack then everything you’d want should
be in v$active_session_history. Look at event, blocking_session and
blocking_session_serial# over the sample_time that had the problem
That should get you started,
Andy
On Thu, 25 Jul 2019 at 13:33, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
wrote:
Hello,
I got situation where instance had lot of locks simultaneously.
So, when I tried to check the blocker session, I did not get sucess,
because I did not got to connect.
After few time, all locks were released.
Now, I want to know who were the blocker session .
Is there a way / query to get this information ?
Regards
Eriovaldo