RE: sort_area_size + temp tablespace extent sizing

Hi Ade,
The formula that I use is:
 extent size = Multiples of sort_area_size.

 If the data file for the temp tablespace is configured with the additional db block size for the overhead, then the remaining space would take all possible extents without wasting any disk space.

In your case you can consider the extent size to be some multiple of 128k, to minimize dynamic extent allocation for the temp segments.  

Regards,

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Adrian Roe [SMTP:adrian.roe_at_telewest.co.uk]
> Sent: Tuesday, April 24, 2001 10:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: sort_area_size + temp tablespace extent sizing
>
> Hi List,
>
> Quick question regarding temp tablespace extent sizing.
>
> I have always assumed that the extent size for a temporary tablespace
> needs
> to be equal to the size that sort_area_size is set to. A sort that can't
> fit
> into memory then goes and grabs temp tablespace extents of a size equal to
> sort_area_size. However, I have read somewhere that the extent size should
> be equal to sort_area_size + block size (the block being used for header
> infomation or something like that) eg. 8k block size and 64k sort area
> size
> results in 72K temp tablespace extent size.
>
> So, assume I have a sort area size of 128K and block size of 8k, do I need
> to set temp tablespace extent sizes to 128K or 136K, or doesn't it really
> matter.
>
> Thanks,
>
> Ade
>
>
> --------------------------------------------------------------------------
> ----
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material.
> Statements and opinions expressed in this e-mail may not represent those
> of the company. Any review, retransmission, dissemination or other use of,
> or taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender immediately and delete the
> material from any computer
>
> ==========================================================================
> ====
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Adrian Roe
> INET: adrian.roe_at_telewest.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).