Re: temporary tablespace performance

I don't what init.ora paramaters I have changed that have caused this. The ones that I have been playing with are db_blocks and shared_pool and pre_page_sga. I thought what might be happening was that I was just over allocated memory and the OS was swapping and that was slowing down the reports, but that is not the case. The query is for some reason using temporary tablespace when it runs. This oracle 8 database is also running on Novell oracle 7.1 (We upgraded over the weekend). The report finishes execution within a few seconds on the old oracle 7.1 server and does not use any temporary tablespace (i know it doesn't because I was watching in storage manager). The same query on oracle 8 uses 127 megs of space in the temporary tablespace. The only thing that has changed that i can think of is that it is oracle 8, and in the oracle 8 schema I changed a column of a table that is in that query from char(10) to char(20). I even recreated the index that was on that column.

Thanks for your time.

• Paul

Kelly Young wrote:

> 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