Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I combine TEMP and RBS tablespace?

Re: Can I combine TEMP and RBS tablespace?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 16 Jul 2002 19:54:06 +0200
Message-ID: <4cn8jucl7fv5314inmfedd056ismb7925p@4ax.com>


On 16 Jul 2002 07:35:53 -0700, sjefke12_at_hotmail.com (Foggy) wrote:

>"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<agvaj5$ljb$1_at_lust.ihug.co.nz>...
>> "Edzard" <edzard_at_volcanomail.com> wrote in message
>> news:5d75e934.0207151039.59ba72a8_at_posting.google.com...
>
><SNIP>
>
>> Which is probably bad news. The extent sizes for temporary segments need to
>> be a multiple of your sort_area_size plus one block. The extent sizes for
>> your rollback segments probably ought to be something else - a common
>> multiple of 5 blocks and your multiblock_read_count.
>>
><SNIP>
>
>Two small questions:
>
>- is it '(multiple of your sort_area_size) plus one block' or
> 'multiple of (your sort_area_size plus one block)' ?
>
>- Why is it 'plus one block'?
>
>Regards,
>
>Johan

It is '(multiple of your sort_area_size) plus one block *for the initial extent only*

It is plus one block as every segment has a header block.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 16 2002 - 12:54:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US