Sorry if this has been explored, but it sounds like the difference in the plans is the problem. Can you elaborate on WHAT is different about the plans? Is something else hogging temp? -- Jeremiah Wilton Independent Oracle Professional Oracle Certified Master Disaster Recovery - Seminars - Technical Interviews http://www.speakeasy.net/~jwilton On Fri, 19 Nov 2004, Duret, Kathy wrote: > two database set up is EXACTLY the same (init.ora, files size etc) > > Query using two views in OLD 32 bit runs in 2 seonds and with the WHOLE > company running on the database uses less than 1/2 G of temp tablespaces. > > Query ONLY running on new production database get ora-1652 (out of temp > space) on 1G of temp space after 81 seconds. > > Once again same set up, same data, BUT the explain plans are different but > are fairly similiar. -- //www.freelists.org/webpage/oracle-l