Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1652 no matter how big temp tablespace made

Re: ORA-1652 no matter how big temp tablespace made

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 13 Aug 2003 15:25:22 GMT
Message-ID: <3F3A5862.4290EAB0@remove_spam.peasland.com>


While the configuration may be the same, in most development/production environments I've seen, the data in both systems are not the same. Are you trying to sort more rows? This can cause more sort space to be needed.

HTH,
Brian

Shirley Taylor wrote:
>
> Hi,
> We have a query which runs on our development instance using a total
> of 512M of temp tablespace. On the production instance it fills a 6gig
> temporary tablespace and fails. Database parameters are identical.
> Tablespaces are temporary not permanent. I used dbms_stats on the
> production server and exported the stats to the development server
> where I imported them but the query still runs properly and only uses
> 512M of sort space in temp. I've sent a mass of stuff to Oracle
> support but haven't heard back yet. Anyone experience this before?
> Thanks,
> Shirley

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Wed Aug 13 2003 - 10:25:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US