Re: Securefile LOB without OAC

From: Stefan Koehler <contact_at_soocs.de>
Date: Wed, 11 Feb 2015 19:44:12 +0100 (CET)
Message-ID: <2009794009.12877.1423680252213.JavaMail.open-xchange_at_app10.ox.hosteurope.de>

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:

- http://www.trivadis.de/uploads/tx_cabagdownloadarea/LOB_Komprimierung_mit_Oracle_11g.pdf (page 4)
- http://www.oracle.com/technetwork/database/perf-087187.html
- https://petesdbablog.wordpress.com/2014/02/11/boost-your-database-performance-with-securefiles/

However only trust your own statistics and better use the "SecureFiles Test Kit" from Oracle for benchmarking your environment: http://www.oracle.com/technetwork/database/sftestkit-099298.html

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> stephen van linge <dmarc-noreply_at_freelists.org> 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

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

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