Re: How to find the exact SQL locking others?
From: Leyi Kamus Zhang <kamusis_at_gmail.com>
Date: Mon, 2 Jul 2012 22:11:11 +0800
Message-ID: <CAPtFprobMgPgMHPTnPap4etB=_ah6L2OGTp6RDt=-zmQbrrQEg_at_mail.gmail.com>
Oh, yes, you are correct, I forgot what I mentioned is the EXACT SQL.
Date: Mon, 2 Jul 2012 22:11:11 +0800
Message-ID: <CAPtFprobMgPgMHPTnPap4etB=_ah6L2OGTp6RDt=-zmQbrrQEg_at_mail.gmail.com>
Oh, yes, you are correct, I forgot what I mentioned is the EXACT SQL.
-- Kamus <kamusis_at_gmail.com> Visit my blog for more : http://www.dbform.com Join ACOUG: http://www.acoug.org On Mon, Jul 2, 2012 at 9:59 PM, Alex Fatkulin <afatkulin_at_gmail.com> wrote:Received on Mon Jul 02 2012 - 09:11:11 CDT
> No you can't, redo does not store SQL statements. Logminer parses and
> interprets the redo into SQL but these are not the same SQLs which
> resulted in the data changes.
>
> On Mon, Jul 2, 2012 at 9:49 AM, Leyi Kamus Zhang <kamusis_at_gmail.com>
> wrote:
> > columns, so yes, I think I can find the exact SQL text by Logminer (from
> > SQL_REDO), but it's really complicated when doing it in a product system.
> >
>
> --
> Alex Fatkulin,
> http://afatkulin.blogspot.com
>
> Enkitec,
> http://www.enkitec.com
>
-- http://www.freelists.org/webpage/oracle-l