Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temporary tablespace performance
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