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 performance

Re: temporary tablespace performance

From: Kelly Young <young_at_maricopa.edu>
Date: 1998/03/30
Message-ID: <351FB20D.384F@maricopa.edu>#1/1

Paul Bennett wrote:
>
> 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!
>
> -- Paul

 Which init.ora parameters did you change?

-- 
Kelly Young
Database Administrator
Maricopa Community Colleges
young_at_maricopa.edu
Received on Mon Mar 30 1998 - 00:00:00 CST

Original text of this message

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