Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sort_area_size + temp tablespace extent sizing
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
--
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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). Received on Tue Apr 24 2001 - 13:17:28 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |