Re: Moving BLOBs from BASICFILES to SECUREFILES

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 10 Feb 2016 07:56:07 -0500

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: