How can a DML sql_id show in v$sql but not in v$logmnr_contents within same time frame?

  • From: fmhabash <fmhabash@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Dec 2010 18:20:00 -0500

Trying to explain a situation where v$sql showed an update statement as seen below ... 


sql_id: bwh1dxng531pw
last_active_time: 12/21/2010 10:04:28 am
executions: 4
sql_text: update Layout set ....

I then grabbed these archive logs

SEQUENCE#  FIRST_TIME             NEXT_TIME              NAME
---------- ---------------------- ---------------------- ---------------------------------------------------------------------------------------- 
21925 12/21/2010 7:20:06 am  12/21/2010 7:38:12 am
21936 12/21/2010 10:50:08 am 12/21/2010 11:20:07 am
The v$logmnr_contents (showing committed txns only with online catalog) did not show any updates on the table above whatsoever. 

How can this happen?
- the update DML never committed?
- it rolledback?
- txn never completed?
- txn failed?

How else can this be explained?

Thank you.
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2010