Re: How about 11g SecureFiles LOBs?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "bill@xxxxxxxxxxxx" <bill@xxxxxxxxxxxx>
- Date: Tue, 11 Jan 2011 09:29:09 -0500
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@xxxxxxxxxxxx> 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@xxxxxxxxx>
>>
>> Visit my blog for more : http://www.dbform.com
>> Join ACOUG: http://www.acoug.org
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
