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.
>> 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
>>
>>
>>
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Jan 11 2011 - 08:29:09 CST
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 > > >
†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Tue Jan 11 2011 - 08:29:09 CST