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.

--
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:



> 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

Received on Mon Jul 02 2012 - 09:11:11 CDT