Re: Newbie DBA Problem: Hitting Temp Hard

From: Tanel Põder <tanel.poder_at_tele2.eee>
Date: 2000/05/12
Message-ID: <391c20fc$1@news.infonet.ee>#1/1

<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