Re: Rollback segment space

From: Ray Dutcher <rdutc_at_sarek.xerox>
Date: Thu, 4 Feb 1993 20:13:36 GMT
Message-ID: <1993Feb4.201336.12333_at_spectrum.xerox.com>

Oracle V6 does not release any new extents for rollback segments. V7 does. You may want to consider a periodic job to drop and recreate your rollback segment(s), that's the only way to reclaim rollback segment extents, keeping in mind that at peak usage Oracle will probably extend the rollback segment(s) again. Having them in their own tablespace with pctincrease of 0 and the same extent size as initial is good practice also. Received on Thu Feb 04 1993 - 21:13:36 CET

This message: [ Message body ]
Next message: Daniel Druker: "Re: Rollback segment space"
Previous message: Joel Garry: "Re: Oracle logging and recovery"
In reply to: David Hiltz: "Rollback segment space"
Next in thread: Daniel Druker: "Re: Rollback segment space"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message