Re: Newbie DBA Problem: Hitting Temp Hard

Temporary segments are not logged, by default. There's no need to make the tablespace nologging.

Regards,

Sybrand Bakker, Oracle DBA

Tanel Põder <tanel.poder_at_tele2.eee> schreef in berichtnieuws 391c20fc$1_at_news.infonet.ee...
>
> <miaemp_at_my-deja.com> wrote in message news:8fgu1f$ovu$1_at_nnrp1.deja.com...
> > If you do increase your sort_area_size, don't forget to rebuild your
> > TEMP tablespace. i.e. the initial and next settings should be the same
> > size as the sort_area_size. Also, make sure that it is temporary
> > storage and not permanent. Don't be alarmed if you have to increase
> > your sort_area_size considerable, we have ours set to approx. 4meg.
>
> initial and next should be sort_area_size + db_block_size!
>
> I'd make the temp tablespace nologging also.
>
> Tanel.
>
>
>
Received on Fri May 12 2000 - 00:00:00 CDT