Re: How to find the exact SQL locking others?
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: kamusis@xxxxxxxxx
- Date: Mon, 2 Jul 2012 09:59:32 -0400
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:
