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 -> temporary tablespace performance

temporary tablespace performance

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: 1998/03/30
Message-ID: <351FA506.45C3E15E@cc.gatech.edu>#1/1 







I am running oracle 8.0 on NT and I have changed some init.ora paramater
or something that is causing, for some reports, 127 megs of my
temporary_tablespace table to be used up.  This is causing the report to
run unbeleivably slow.  No matter how many rows this report is being run
on.  Three rows, which used to take half a second, is now taking
minutes.  The machine is not swapping oracle SGA to disk.  Any ideas?



Help!




Received on Mon Mar 30 1998 - 00:00:00 CST












Original text of this message













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