Re: How about 11g SecureFiles LOBs?

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 11 Jan 2011 09:29:09 -0500
Message-ID: <4B75FC04-860E-494C-BFE0-2D768BD6F5CB_at_proquest.com>



Just as a point of reference, I have an 11.2.0.1 db that is about 9 TB in size, almost all of which is due to a table of about 800 million rows, with an XMLTYPE column stored as securefile LOB.

Securefile LOBs are working fine for us.

Yes, it's in production.

-Mark

Sent from my iPhone

On Jan 11, 2011, at 8:46 AM, "Bill Zakrzewski" <bill_at_intactus.com> wrote:

> Actually, the default setting is to allow SecureFile LOBs, but not require them.  In order to create a SecureFile LOB using the default setting you must include the SecureFile options.  I don't see this as Oracle trying to hide anything, but rather allowing the DBA to choose whether or not to use SecureFile LOBs in their environment.  I wouldn't implement anything into a production environment, but in reading the benefits over BasicFile LOBs I don't see any reason to shy away from this new feature.
> 
> Bill
> On Jan 10, 2011, at 11:20 PM, Leyi Zhang (Kamus) wrote:
> 

>> Hi lists
>>
>> Since in 11gR2, SecureFiles LOBs is still not the default setting when
>> create LOB column, based on my experience for oracle database product,
>> if one new feature is not the default feature, it means maybe there
>> are some unpredictable trouble will get into.
>>
>> I have read the "Oracle® Database SecureFiles and Large Objects
>> Developer's Guide 11g Release 2 (11.2)", but I'd like to hear some
>> actual experiences on SecureFiles LOBs compared to BasicFiles LOBs,
>> any pros and cons?
>>
>> --
>> Kamus <kamusis_at_gmail.com>
>>
>> Visit my blog for more : http://www.dbform.com
>> Join ACOUG: http://www.acoug.org
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
> 
> --
> http://www.freelists.org/webpage/oracle-l

> 
> 
> 

i0zX+n{+i^ Received on Tue Jan 11 2011 - 08:29:09 CST

Original text of this message