Re: Lock History

From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
To: Rodrigo Mufalani <rodrigo@xxxxxxxxxxxxxxx>
Date: Sat, 2 Dec 2017 10:26:30 -0200

Thanks Rodrigo.

2017-12-02 10:11 GMT-02:00 Rodrigo Mufalani <rodrigo@xxxxxxxxxxxxxxx>:

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,

[image: RED]

*Rodrigo Mufalani* - Dir. Técnico
rodrigo@xxxxxxxxxxxxxxx
+55 21 988 994 817

* Mufalani*
+55 21 3193 0326 <+55%2021%203193-0326>
Rua Almirante Grenfall, 405, Bloco 3, Sala 310
<https://maps.google.com/?q=Rua+Almirante+Grenfall,+405,+Bloco+3,+Sala+310&entry=gmail&source=g>
Centro Empresarial Washington Luiz
Duque de Caxias - RJ
CEP 25085-009
www.mufalani.com.br

[image: id:image002.png@01D2F4C6.8E6B3BE0]

*De: *<oracle-l-bounce@xxxxxxxxxxxxx> em nome de Eriovaldo Andrietta <
ecandrietta@xxxxxxxxx>
*Responder para: *"ecandrietta@xxxxxxxxx" <ecandrietta@xxxxxxxxx>
*Data: *sábado, 2 de dezembro de 2017 09:56
*Para: *ORACLE-L <oracle-l@xxxxxxxxxxxxx>
*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

Eriovaldo

References:
- Lock History
  - From: Eriovaldo Andrietta
- Re: Lock History
  - From: Rodrigo Mufalani

Re: Lock History

Other related posts: