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: Temporary tablespace fills up

Re: Temporary tablespace fills up

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Tue, 17 Jul 2001 17:24:35 GMT
Message-ID: <3b548e90.1962141@news> 






    
  
  1.   Double-check the temporary tablespace for the user who runs the
query.
  
  2.   check the execution plan for possible inefficiences. Perhaps there
might be a kind of cartesian product below surface, which is hidden by
a distinct sort.






Kind Regards, 



Herman de Boer
Received on Tue Jul 17 2001 - 12:24:35 CDT












Original text of this message













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