what version are you upgrading from . We had issues with Sql code when we upgeaded from 8.1.7 but that was already caught during the test cycle and resolved. The problem was with unnested views and an _ parameter setting that had changed from 8 to 9 Ray Stell <stellr@xxxxxxxxxx> wrote: Note 547411.994 complains of slow performance after upgrading to 9.2.0.6. Anybody had a similar hit? =============================================================== Ray Stell stellr@xxxxxx (540) 231-4109 28^D -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l