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?
Independent Oracle Professional
Oracle Certified Master
Disaster Recovery - Seminars - Technical Interviews
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.