Re: How to find the exact SQL locking others?
- From: Leyi Kamus Zhang <kamusis@xxxxxxxxx>
- To: Alex Fatkulin <afatkulin@xxxxxxxxx>
- Date: Mon, 2 Jul 2012 22:11:11 +0800
Oh, yes, you are correct, I forgot what I mentioned is the EXACT SQL.
--
Kamus <kamusis@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx>
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
