Re: Moving BLOBs from BASICFILES to SECUREFILES

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 10 Feb 2016 07:56:07 -0500
Message-ID: <56BB3367.1000408_at_gmail.com>



On 02/09/2016 05:10 PM, Chen Zhou wrote:
> How long should we expect to redefine 300GB BLOBs? A few hours or a
> few days? Can it end up hanging?
> Can I take the opportunity to move the BLOB to another tablespace
> during this redefinition process?
> Thank you for your information.
> Chen

That depends on your configuration and IO performance. There is a definite difference in doing things on a high end AIX box, accessing VMAX or XtremIO array or a Dell box accessing a JBOD device.
-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 10 2016 - 13:56:07 CET

Original text of this message