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, Tanel Poder http://blog.tanelpoder.com Oracle Certified Master Oracle ACE Director OakTable Network Member > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael McMullen > Sent: 27 March 2009 17:11 > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: views on views on views > > > This is why mailing lists still rule!!! > Great tip. > > Thanks -- //www.freelists.org/webpage/oracle-l