Re: SYS is sorting to disk

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/05
Message-ID: <36e05fd0.198173026@news.earthlink.net>#1/1

On Sat, 04 Mar 2000 18:03:08 GMT, markp7832_at_my-deja.com wrote:

>Also as a rule per the Oracle 8 Database Performance and Tuning Work
>Shop notes the temp tablespace extent allocations should always be
>multiples of the sort_area_size plus one block.

Everybody has a different recommendation, as long as it is bigger then sort_area_size, I believe it should be fine.

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Sun Mar 05 2000 - 00:00:00 CST