sql_id aged out from v$active_session_history

From: Rodrigo Mufalani <rodrigo_at_mufalani.com.br>
Date: Tue, 1 Dec 2015 16:15:24 -0200
Message-Id: <66C68AEB-880A-4D13-8243-FCCB033EEB70_at_mufalani.com.br>



Hi folks,

   I wanna get some info about a machine that did one particular update. I've found on v$sql, but as it was executed twice the information was aged out from v$active_session_history (easier way to found). There is another way to get that info?! another view? I have the sql_id.

[ ]'s
#mufalani

   Desculpe por erros! Este e-mail foi escrito do meu smartphone!

    Sorry for typos! This mail was written from my smartphone!!!-- http://www.freelists.org/webpage/oracle-l Received on Tue Dec 01 2015 - 19:15:24 CET

Original text of this message