Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle LogMiner question
Howard, thanks for answering my question.
Actually I DO want a unique identifier for a particular single item of
redo.. any idea how can I get that??
As for the unique transaction id I use a combination of XIDUSN, XIDSLT,
and XIDSQN. Do you think there is a problem with that??
Thanks,
Sami.
Howard J. Rogers wrote:
> "Sami Zeitoun" <samizn_at_walla.co.il> wrote in message
> news:e0c648ba9aa21039ea10f577f2dcb646$1_at_www.orafaq.net...
>> **** Post for FREE via your newsreader at post.usenet.com **** >> >> I posted this message couple of minuts ago but I can't find it anywhere!! >> here it's again: >> >> Does anyone know how can I get a unique identifier for a redo record in >> the LogMiner?? >> >> I tried to run the following SQL statemnet: >> >> select operation,sql_undo,SCN from v$logmnr_contents where operation IN >> ('INSERT','DELETE','UPDATE','START','COMMIT','ROLLBACK'); >> >> I expected to get a unique number (SCN) for each record returned, but as I >> see now this SCN is not unique... sometimes I got more than one record >> with the same SCN!! >> >> Can anyone help me??
> I'm assuming you want a unique identifier for a transaction, and not really
> for a single item of redo. In other words, an identifier for all 14 sets of
> redo generated by, say, 'update emp set sal=900'... not for the particular
> before and after images for the update to KING's salary occasioned by that
> transaction.
> There are various technical answers that could use the Undo Segment Number
> and Slot, but the simpler approach would be, I should have thought, to
> combine the SCN, Session# and Serial#.
> There are all sorts of other things you could try, but that's where I would
> start. I confess to not having tried it out though.
> Regards
> HJR
<!--NavBarBottom--> <CENTER><p> <table border=0 width=600 cellspacing=0 cellpadding=0><tr> <TD VALIGN="TOP"><IMG SRC="../../img/title5.gif"></td> <td VALIGN="MIDDLE" background="../../img/title6.gif" WIDTH=600><center><font face=arial size=-2><B> HOME | ASK QUESTION | ADD FAQ |<A HREF="../../supsearc.htm">SEARCH</A> | <A HREF="../../supemail.htm">E-MAIL US</A></B></FONT></td>
<TD VALIGN="TOP" ><IMG SRC="../../img/title7.gif"></td></tr> </table></CENTER> <!--/NavBarBottom-->
</BODY></HTML>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=