Re: temporary tablespace performance

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

More Information to add to the question.

The only change that I can think of is that I expanded a column from char(10) to char(20) in a table that is used in this report. There was an index on this column, and I recreated it. Would this contribute to the temporary tablespace use?

Thanks.

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
Received on Mon Mar 30 1998 - 00:00:00 CST