Re: query re-write SQL text
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 22 Dec 2009 08:36:29 -0800 (PST)
Message-ID: <544540.17764.qm_at_web80606.mail.mud.yahoo.com>
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.
Date: Tue, 22 Dec 2009 08:36:29 -0800 (PST)
Message-ID: <544540.17764.qm_at_web80606.mail.mud.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 22 2009 - 10:36:29 CST