Re: Who were the blocker session

Hello Eriovaldo,
you can use Tanel Poder's dash_wait_chains script for that ( https://github.com/tanelpoder/tpt-oracle/blob/master/ash/dash_wait_chains.sql ), if you got the license for diagnostic pack and with a little bit of luck (if not everything was totally stuck and ASH was dumped).

However if the situation occurs again you can always login with prelim option and create a system state or hanganalzye dum - for more information please have a look here: https://blog.tanelpoder.com/2012/05/08/oradebug-hanganalyze-with-a-prelim-connection-and-error-can-not-perform-hang-analysis-dump-without-a-process-state-object-and-a-session-state-object/

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Eriovaldo Andrietta <ecandrietta_at_gmail.com> hat am 25. Juli 2019 um 14:32 geschrieben:
>
> 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