Re: rollback seg. for large database

In article <8jt1e0$ims$1_at_nnrp1.deja.com>,   fly13_at_my-deja.com wrote:
> Hi,
>
> Just 2 theory questions :
> - I would like to know if i'm right to put all the rollback segments
 of
> the database in the tablespace RBS ?
> -And as i have to do many sorting (group by, ...), do i have to create
> additional rollback segments, and so in which tablespace ?
>
> thanx by advance
>
> fly13
>

1) It is fairly standard for all rollback segments to be defined in one tablespace named RBS. The only reason to have multiple rbs segment tablespaces is if the first tablespace becames a disk IO bottleneck or you are running OPS and want to define one RBS tablespace per instance.

2) Rollback segments are not used in sorts, temporary or temp, segments are. The temp segments should be allocated in a tablespace dedicated to temp. The most common names for the temp tablespace is TEMP or TMP. You assign users to a temporary tablespace via the alter user command: alter user bob temporary tablespace tmp;

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.