Re: temp extent size

viny wrote:
> Thanks for your response !!
>
> for more clarity :
> My DB version is 9.2.0.6
> OS is HP Unix 11i
>
> I am facing ORA-1652 even if I have sufficient Temp datafile more than
> 4GB . I think only reason here, i see is Next extent ize is not proper
> , which is 1M by default, /and that may have caused the fragmentation
> in the temp tablespace. Due to which it is not able to provide
> contiguous blocks for the user process.
>
> But I am not sure, how much should we use for extent size in case of
> Temporary content type Temp tablespace?
>
> regards,
> vinay
>
>
>
> DA Morgan wrote:

>> 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

Please don't top post. Scroll to the bottom to reply. Thank you.

I highly doubt the issue is as you suspect. I can't with so little information suggest what it is but I wouldn't change parameters without knowing more. Seriously consider opening an SR if you can not post sufficient information here for someone to help you.

-- 
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