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