Re: Temporary tablespace (oracle 8.1.7)

Hi Marcin,

As Kenneth has said, you will fix one problem (maybe) by creating others.

I would also look at the setting for sort_area_size and check out the system statistics for sorts(disk) and sort (memory) and see if a highish number of disk sorts are being run. In which case consider upping the SAS.

Then look to see which buggers are doing the large sorts. If you don't have a GUI to tell you, useful views include v$sesstat, v$sort_usage and v$sqlarea. Determine if tuning the SQL (hence fixing the cause rather than the symptom) is appropriate.

Cheers

Richard
<Kenneth Koenraadt> wrote in message
news:3d99b0c4.3895341_at_news.capgemini.se...
> No, in best case it treats the symptom. Most likely it will make your
> application crash.
>
> 250 Mb is not much for a TEMP tablespace nowadays, it can easily be
> consumed by queries producing large sorts or the DBA i.e. rebuilding
> an index.
>
> For now, just allocate more space for your TEMP tablespace instead.
>
> Then, if it grows out of proportion ( say it reaches 10 Gb on a DB
> with 1 Gb of user data), go looking for huge sorts in the application.
>
> - Kenneth Koenraadt
>
>
>
> On Tue, 1 Oct 2002 16:20:13 +0200, "Marcin" <mwolski_at_poczta.fm> wrote:
>
> >Hello,
> >
> >My temporary tablespace has been reaching limit space after two or three
> >weeks working (250MB). Then I have to restart database to clean it up.
And
> >then the situation repeats, so I am thinkink about quota on temporary
> >tablespace (let's say 50MB). Is it good idea?? Does it solve the
problem??
> >
> >M.
> >
> >
>
Received on Tue Oct 01 2002 - 19:58:00 CDT