Re: query re-write SQL text

From: Yong Huang <>
Date: Tue, 22 Dec 2009 08:36:29 -0800 (PST)
Message-ID: <>

I remember Jonathan Lewis said v$sql_redirection was supposed to show rewritten SQLs but it was never populated. I checked 11gR2. There's nothing new. If anybody can find some use of this view, let us know.

Yong Huang

> when Oracle re-writes a query, is there any way to get the new
> equivalent SQL Text?
> Thanks
> Kyle

Received on Tue Dec 22 2009 - 10:36:29 CST

Original text of this message