Home » RDBMS Server » Server Administration » Rollback Segments
Rollback Segments [message #369175] Wed, 05 April 2000 11:32 Go to next message
Messages: 27
Registered: December 1999
Junior Member
Hi All,
Currently the database we are using is for high value throughput of raw data. Our rollback segments are not being cleaned when we perform a commit and instead we have to keep expanding the rollback segments. At the moment the rollback segments are all stored in the same tablespace and we may move them around to try and do something about performance. Would this help. Any Ideas?
Re: Rollback Segments [message #369176 is a reply to message #369175] Wed, 05 April 2000 11:49 Go to previous messageGo to next message
Chris Ruel
Messages: 6
Registered: March 2000
Junior Member
Have you tried using the OPTIMAL clause in creation to get them to shrink back down after each use?
Re: Rollback Segments [message #369189 is a reply to message #369176] Thu, 06 April 2000 13:47 Go to previous message
Messages: 45
Registered: February 2000
I have run into a similar problem. I ran optimal and it shrunk my rollback segments by 700 meg. But when I tried to do a backup, oracle seems to be trying to backup the datafiles not the parts of the data files allocated, and in use. We have the system tables, and maybe 40 meg of user tables and the backup fails on disk space after the backup file has grown to 1.5 gig.?.
Previous Topic: Active XACTS in rollback segs
Next Topic: Date formats
Goto Forum:

Current Time: Mon Dec 05 13:01:25 CST 2022