Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: temporary tablespace
Don't bother trying to use anything but uniform-sized extents in a temporary
tablespace...
SQL> create temporary tablespace t2 tempfile '/tmp/t2.dbf' size 10M 2 extent management local autoallocate; extent management local autoallocate
*
Sometimes, itıs better not to have options... :-)
on 1/29/04 1:05 PM, Mladen Gogala at mladen_at_wangtrading.com wrote:
> It depends. If you can create sort_area_size that can dynamically > autoallocate larger and larger chunks of memory, then go ahead, create > autoallocate temporary tablespace. If your sort_area_size is fixed, > then you should create temporary tablespace with the uniform extent > size. > > On 01/29/2004 02:54:37 PM, Jeffrey Beckstrom wrote:
> ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request_at_freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> ----------------------------------------------------------------- ----------------------------------------------------------------Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Jan 29 2004 - 17:54:53 CST
![]() |
![]() |