Rollback Segment Philosophy
- From: Kevin Lange <klange@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Jul 2004 12:36:28 -0500
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
