IIRC you can also grab the view expanded SQL from a 10053 trace as well. On Fri, Mar 27, 2009 at 9:21 AM, Tanel Poder <tanel@xxxxxxxxxx> wrote: > Btw, in 11g the _dump_qbc_tree works as well, but the output is somewhat > less readable (too much detail is outputted) but some post-processing with > AWK should help.. -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l