Re: Lock History
Date: Sat, 2 Dec 2017 12:11:00 +0000
Message-ID: <3854FF0E-0D2F-446C-91E3-C8B813B0AEFB_at_mufalani.com.br>
Hi,
If you have diagnostic pack, and if ASH was enable before in this database instance, you can check at v$active_session_history / dba_hist_active_sess_history for this info.
All the best,
Mufalani
[id:image002.png_at_01D2F4C6.8E6B3BE0]
De: <oracle-l-bounce_at_freelists.org> em nome de Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Responder para: "ecandrietta_at_gmail.com" <ecandrietta_at_gmail.com>
Data: sábado, 2 de dezembro de 2017 09:56
Para: ORACLE-L <oracle-l_at_freelists.org>
Assunto: Lock History
Hi,
There is a process that ran at 30/11/2017.
This process was too slow.
The developer ask me if there was some lock during the execution.
I know v$lock that show to us the current lock.
Is there any table to check lock history ?
Regards
[RED]
Rodrigo Mufalani - Dir. Técnico
rodrigo_at_mufalani.com.br
+55 21 988 994 817
+55 21 3193 0326
Rua Almirante Grenfall, 405, Bloco 3, Sala 310
Centro Empresarial Washington Luiz
Duque de Caxias - RJ
CEP 25085-009
www.mufalani.com.br<http://www.mufalani.com.br/>
Eriovaldo
--
http://www.freelists.org/webpage/oracle-l
- image/png attachment: image001.png
- image/png attachment: image002.png