RE: question about progress of shrink operation
Date: Sat, 27 Jan 2024 15:06:36 -0500
Message-ID: <479701da515c$55b30e50$01192af0$_at_rsiz.com>
+42.
Likewise if conditions are correct for you to copy to a new location to effectively “shrink” rather than making shrink work, a reasonable amount of work should go into the optimization of the details about your LOB storage in the destination. The storage choices should not affect the ability to copy from your current source to a new destination, but they may make a significant change in the storage footprint in the destination.
IF memory serves and IF a substantial number of your lobs should no longer be logically changed, things effectively like pctfree for “regular” block storage might be set very small for the copy in of those now unmutable lobs, and then be set optimally for change of your still mutable lobs before they are copied in. Don’t trust my memory on this, especially for more recent releases. A change from basicfile in the original to securefile in the destination may well be more important than anything else if the current lobs are basicfile.
Notice in particular than zero of what I have written changes or challenges what JL has written about getting shrink to work at all.
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis
Sent: Saturday, January 27, 2024 1:43 PM
To: ORACLE-L (oracle-l_at_freelists.org)
Subject: Re: question about progress of shrink operation
THank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 27 2024 - 21:06:36 CET