Re: Rollback segment space
From: Martin Jarvis <smj_at_jbecpor.demon.co.uk>
Date: Mon, 8 Feb 1993 09:52:19 +0000
Message-ID: <C24JF7.HIC_at_jbecpor.demon.co.uk>
Received on Mon Feb 08 1993 - 10:52:19 CET
Date: Mon, 8 Feb 1993 09:52:19 +0000
Message-ID: <C24JF7.HIC_at_jbecpor.demon.co.uk>
: > Does the space from a rollback segment ever get reclaimed
: > by Oracle?
: >
: >
As every else has said, no. Just one extra point though, this applies to _all_ segments in Oracle (data segments, index segments etc).
Oracle 7 has an extra option in the storage clause OPTIMAL which can only be used on rollback segs. I believe that it didn't work to well in the early releases....
Regards,
Martin
Martin Jarvis | John Brown E & C Ltd, smj_at_jbecpor.demon.co.uk | 1 Buckingham Street,Martin Jarvis /JBEC-Portsmouth, IT | Portsmouth, Hampshire, UK
Received on Mon Feb 08 1993 - 10:52:19 CET