Re: temp extent size

joel garry schrieb:
> viny wrote:

>> My sort area size is 8MB and db_block_size is 8KB >>

>
> So of course, if you use uniform, that would imply the initial. I
> would set it much higher, dependent on how much data you intend to be
> putting through temp. You should also figure out what goes into temp,
> while you are at it (it's in the docs). Somewhere is told the limited
> number of segment sizes for LMT.
>
> Oddly enough, looking at some script (hacked from an old wizard,
> probably) that created my 9.2 db, it has this clause in the create
> database statement:
>
> ....
> EXTENT MANAGEMENT LOCAL
> DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/xxxx/temp01.dbf'
> SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE 10000M
> ....
>
> But of course, since it is LMT, it's 1M:

>
> jg

Joel, this NEXT is part of AUTOEXTEND ON clause and specify the size of tempfile increment ( which is nevertheless not very smart specified with 640K while to allocate next extent tempfile should be extended sometimes twice which can be probably optimized ;-)).

Best regards

Maxim Received on Fri Jan 19 2007 - 02:48:51 CST