RE: sql_id aged out from v$active_session_history

From: Powell, Mark <mark.powell2_at_hpe.com>
Date: Wed, 2 Dec 2015 17:25:47 +0000
Message-ID: <1E24812FBE5611419EFAFC488D7CCDD130697997_at_G4W3290.americas.hpqcorp.net>

You might try to see if there are entries in dba_hist_active_sess_history for your task.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rodrigo Mufalani Sent: Tuesday, December 01, 2015 1:15 PM To: oracle-l_at_freelists.org
Subject: sql_id aged out from v$active_session_history

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 02 2015 - 18:25:47 CET