Thanks Stefan and Andy.
Em qui, 25 de jul de 2019 às 09:51, Stefan Koehler <contact@xxxxxxxx>
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: @OracleSK
Eriovaldo Andrietta <ecandrietta@xxxxxxxxx> hat am 25. Juli 2019 um14:32 geschrieben:
because I did not got to connect.
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,
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
