RE: sort_area_size + temp tablespace extent sizing

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Tue, 24 Apr 2001 11:17:28 -0700
Message-ID: <F001.002F0A69.20010424091100@fatcity.com>

Hello, Ade,
You are right, Oracle needs one-block header, and you have to add this block to optimize performance.
The extent size my be
<one block> + N*<SORT_AREA_SIZE>
N depends on size of typical sort operations.

HTH
Vadim Gorbounov
Oracle DBA

-----Original Message-----

Sent: Tuesday, April 24, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L

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: Vadim Gorbounov
INET: vgorbounov_at_simplyengineering.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