Re: query re-write SQL text

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: kylelf@xxxxxxxxx
  • Date: Tue, 22 Dec 2009 08:36:29 -0800 (PST)

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


      
--
//www.freelists.org/webpage/oracle-l


Other related posts: