Re: Who were the blocker session

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_at_gmail.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l