Re: Securefile LOB without OAC

From: Stefan Koehler <>
Date: Wed, 11 Feb 2015 19:44:12 +0100 (CET)
Message-ID: <>

Hi Stephen,
yes, SecureFiles (even without deduplication / compression) usually perform better than the classic BasicFiles.

There are several benchmarks from Oracle or independent researchers - just for example:

- (page 4)

However only trust your own statistics and better use the "SecureFiles Test Kit" from Oracle for benchmarking your environment:

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage:
Twitter: _at_OracleSK

> stephen van linge <> hat am 11. Februar 2015 um 18:11 geschrieben:
> Hi all,
> Is there any particular performance or storage benefit to converting basicfile LOBs to securefile lobs if you don't have the OAC option enabled on
> an 11gR2 database?
> Having trouble finding anything about this on Google...
> Thanks,
> Stephen

Received on Wed Feb 11 2015 - 19:44:12 CET

Original text of this message