Hi Ade and list,
This is folk lore.
Please see http://www.ixora.com.au/q+a/0103/27075321.htm for the explanation.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-----Original Message-----
Sent: Wednesday, 25 April 2001 1:01
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Steve Adams
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
