Correct uniform size for temporary LMT ?

From: Christian Svensson <chse30_at_hotmail.com>
Date: 27 Feb 2002 07:37:30 -0800
Message-ID: <ccc2a7eb.0202270737.6cc4de1f@posting.google.com>

Greetings,

We are about to swith out temporary tablespace from Dictionary Managed Tablespace (DMT) to Locally Managed Tablespace (LMT) when we will upgrade our database (OLTP) from 8.1.6.0 -> 8.1.7.1

How are we going to decide the "best suitable" uniform size for the LMT ? I have looked everywhere in both this newsgroup and at metalink, but the only thing I find is that it should be:

UNIFORM SIZE = SORT_AREA_SIZE * n

Now we have a sort_area_size of 65536 but how many "n" should we have ? I have seen many examples of a uniform size of 10M and 50M(!) but I have not seen any directions.

In v$system_event there are only 1 total_waits if that helps.

Thanks for any comments on this.

/Christian Received on Wed Feb 27 2002 - 09:37:30 CST