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

Home -> Community -> Mailing Lists -> Oracle-L -> Rollback Segment Philosophy

Rollback Segment Philosophy

From: Kevin Lange <klange_at_ppoone.com>
Date: Tue, 20 Jul 2004 12:36:28 -0500
Message-ID: <ED1256BD4F253C44B1627B2D365A334F0528FB44@ppoone1.ppoone.com>


Evening;
  Is there 'accepted' philosophy on Rollback Segments and how many and how big they should be ?

We are running an 8.1.7.4 database on Solaris 5.9. The database is a hybrid Transactional with some long running processes.

We have always made it a point to have a limited number of rollback segments using a limited amount of space. But, the issue of no space no longer applies.

Since we are starting to get rollback issues due to running out of space on our rollback segments we have decided to reopen our analysis of our rollback design.

I was just wondering if any of you would mind sharing your philosophy on Rollbacks .

Thanks

Kevin



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Jul 20 2004 - 12:33:53 CDT

Original text of this message

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