Re: Who were the blocker session

Thanks Stefan and Andy.

Em qui, 25 de jul de 2019 às 09:51, Stefan Koehler <contact_at_soocs.de> escreveu:

> 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