Re: Can I combine TEMP and RBS tablespace?

"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 Received on Tue Jul 16 2002 - 09:35:53 CDT