Re: temp extent size

viny wrote:
> My sort area size is 8MB and db_block_size is 8KB
>
> I have created locally managed temporary tablespace. What should be
> ideal value for INITIAL, NEXT extent size for the locally managed
> temporary tablespace??
>
> I am using 8MB+8KB extent size. Is it higher/lower? Need the suggestion
> asap.
>
> thanks in advance !!
>
> regards,
> vinay

Could you please restate your question, adding your version number and operating system, and strive for greater clarity.

The default is 1M for each and I wouldn't change that without some metrics giving a reason to make a different choice.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org