ake you choose a certain value
> (i.e.: using '3'
> versus '4.5')?
>
> -Message d'origine-
> De: paquette stephane [
> mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> ]
> Date: Tuesday, April 24, 2001 6:03 PM
> À: Mu
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
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
+ N*
N depends on size of typical sort operations.
HTH
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Tuesday, April 24, 2001 11:01 AM
To
: 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 tem
Title: RE: sort_area_size + temp tablespace extent sizing
Stephane,
What situation would make you choose a certain value (i.e.: using '3' versus '4.5')?
-Message d'origine-
De: paquette stephane [mailto:[EMAIL PROTECTED]]
Date: Tuesday, April 24,
The extent size of the temp tablespace should be a
multiple of the sort_area_size parameter + 1 block.
If your sort_area_size is 128K and if you need to go
to temp tablespace that means that 128K is not enough
so you should allocate for more than 128K.
temp extent = (sort_area_size*n)+ 1 block
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
sor