Re: Configure Rollbacks

In <37hk96$t8e_at_abacus.tis.tandy.com> bpearc1_at_abacus.tis.tandy.com (Byron Pearce) writes:

>
>Is there a recommended method for distributing your rollback segments
>across disks? We are noticing heavy i/o on our disk drive that contains
>the rollback segments, and I was considering splitting them into several
>smaller segments to minimize contention for i/o on that drive.
>
>Are there any suggestions here? I would LOVE to hear from someone
>who has faced such a situation before.
>
>Thanks!
>
>==============================================================================
>Byron Pearce | The thoughts and views herein do not
>Tandy Information Services | necessarily reflect that of Tandy
>byron.pearce_at_tandy.com | Corporation.
>------------------------------------------------------------------------------
>"It's hard to be a ninja when you wear a beeper."
>==============================================================================
>
>
>

Consider following suggestion :

1. Create separate tablespaces for rollback segments with datafiles scattered across disks. (Make it such a way that each tablespace have atleast two datafies scattered in two disks).
2. Create small rollback segments (Preferably public) in those tablespaces.
3. Make these rollback segments as TEMPORARY TABLESPACE for different users.
4. If you are making private rollback segments, include those in init.ora file.
5. Shutdown the Oracle Instance and startup again.

This will solve the disk I/O Problem to some extent.

If you are using ORACLE7, consider setting transaction to use a particular rollback segment.

Regards

VK Nair Received on Fri Oct 14 1994 - 14:25:08 CET