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: [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: Vadim Gorbounov
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).
