Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Pad temp extents a few bytes larger than sort_area_size?
I had read in some Oracle documentation that typically you will add one
oracle block to sort_area_size to get uniform extent size.
Say, Oracle block size = 8192 bytes
Then, in your case, Uniform extent size should be set to 1056768
"Alan" <alainrtv_at_yahoo.com> wrote in message
news:fbee32ac.0203221907.324821c4_at_posting.google.com...
> Hello,
>
> I'm currently working on a statement to create a temporary tablespace
> on my 8i DB. Here is what I have so far:
>
> CREATE TEMPORARY TABLESPACE temp
> TEMPFILE '/u2/oracle/data/B/tempb.dbf' size 200m reuse
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576;
>
> I picked a UNIFORM SIZE of 1M because my
> SORT_AREA_SIZE = 1048576
>
> Am I wise to set the UNIFORM SIZE to 1048576?
>
> If Oracle needs to do a disk sort it will want to copy data from
> my memory sort area into TABLESPACE TEMP.
>
> When it does this copy, will it be happy to see an extent
> which matches the SORT_AREA_SIZE exactly?
>
> Or would the copy go quicker if I setup temp so each extent
> is padded a few bytes larger than SORT_AREA_SIZE?
>
> A variation on this question is this:
> Should each extent by a multiple of SORT_AREA_SIZE?
>
> If yes, should the extent be 'padded' by a few bytes?
>
> Alan
Received on Sat Mar 23 2002 - 23:01:30 CST