The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Using SecureFiles with E-Business Suite Databases

Steven Chan
Senior Director

A pair of recent OTN forum threads raised questions about using SecureFiles with the E-Business Suite.  I'm very pleased to let you know that SecureFiles is supported for use with Oracle E-Business Suite Release 11i and 12.  SecureFiles is a new Oracle Database 11g Enterprise Edition feature that allows the efficient storage and management of file or unstructured data via LOBs.

SecureFiles features entirely new disk formats, network protocol, space management, redo and undo formats, buffer caching, and intelligent I/O subsystem. SecureFiles represents the core infrastructure for managing unstructured content inside the Oracle database.  It has additional advanced features for deduplication, compression, encryption, and advanced logging.

SecureFiles_architecture diagram showing automatic storage management asm disk groups.png

Works Transparently with the E-Business Suite

SecureFiles is completely transparent to the E-Business Suite.  In other words, you can follow the generic Oracle SecureFiles documentation to use online redefinition to enable this feature for E-Business Suite databases:

As far as E-Business Suite databases are concerned:

  • SecureFiles works transparently with both Oracle E-Business Suite Release 11i and 12.
  • No additional database or E-Business Suite patches are required.
  • No special configuration options are required.

Considerations for EBS Environments

Given the wholly transparent nature of this database feature, we haven't published any special whitepapers or Metalink Notes for E-Business Suite environments.  We would consider the use of SecureFiles to be a very benign customization, similar to, say, applying custom partitioning to a table.

That said, your users' transactional mix, your historical production data, and your database server and storage configurations will all affect overall performance.  As with all customizations, you should test your environment thoroughly before enabling SecureFiles in a production environment.

What Have You Found?

We're eager to hear about your experiences with SecureFiles in your E-Business Suite environments.  If you have anecdotal remarks about how well it's worked for you, please drop me a line or post a comment here.  Any statistics or performance benchmarks would be even more welcome.

Related Articles

Join the discussion

Comments ( 9 )
  • guest Thursday, November 17, 2011

    Could FND_LOBS be converted to a secure file table during reorganization?

  • Elke Phelps (Oracle Development) Wednesday, November 23, 2011

    Yes, you may convert EBS LOBS to SecureFiles. This includes the FND_LOBS table. Oracle has successfully implemented Advanced Compression on its Global Single Instance. This compression included LOBS through the use of 11g SecureFiles.



  • guest Tuesday, June 19, 2012

    Is there any document on converting FND_LOBS into securefiles on MOS?

  • Elke Phelps (Oracle Development) Thursday, June 21, 2012


    You may use the following My Oracle Support Documenst as the basis of your plan for migrating FND_LOBS to securefiles:

    - How To Migrate LOBs From Basicfiles to Securefiles [ID 1433579.1]

    - Secure file Migration and Accessing securefile metadata information [Video] [ID 1170351.1]

    - Oracle E-Business Suite Release 12.1 with Oracle Database 11g Advanced Compression [ID 1110648.1]



  • guest Friday, May 3, 2013


    Please can you let me know if using securefile with deduplication is certified with EBS 12.1.3 or not. We are planning to use securefile with deduplication for our FND_LOBS table.



  • Steven Chan Friday, May 3, 2013


    There are no EBS-specific requirements for using SecureFiles. As noted n the article above, you can folow the generic SecureFiles documentation to enable this in your E-Business Suite environment.

    We haven't explicitly tested the deduplication option within EBS environments but it should work with no issues. Please feel free to drop me a line with your experiences with this option.



  • guest Wednesday, February 12, 2014

    Hi Steven,

    Can we move FND_LOBS table from APPLSYSD tablespace to APPS_TS_MEDIA using online redefinition? I am not trying to convery from basicfile to securefile. I just want to move the table.


    Suresh Rajagopal

  • Elke Phelps (Oracle Development) Wednesday, June 18, 2014


    My apologies for the delayed response. I may be too late to provide you guidance; however, perhaps my reply will help others.

    Redefining tables online is an Oracle Database 11g feature that can be used with E-Business Suite database objects including the FND_LOBS table. We have not published any special whitepapers or MOS notes for the same.

    You should refer to the Oracle Database Administration Guide for your version of the database for information regarding redefining tables online. When researching the feature, pay particular attention to usage restrictions.



  • Shoeb Friday, October 17, 2014

    Hello Steven / Elke,

    Our EBS R12.1.3 architecture consists of two-node application tier (shared application file system) and three-node RAC database tier. Due to application-level firewall, we are facing periodic file-system hang issues for the NFS file-system which is shared between the RAC database nodes and referenced by APPLPTMP environment variable on the application side. This file-system hang issue causes the concurrent programs which are doing temporary PL/SQL write to APPLPTMP directory to halt and causes a build up of pending concurrent programs until the file-system issue is resolved (by UNIX admins).

    We are exploring the options available to address this issue and would like to know if Oracle 11g SecureFiles could be used for the APPLPTMP file-system implementation.

    We are planning to use SecureFiles for APPLPTMP directory implementation only. The EBSR12 RAC database on ASM will remain unchanged.

    I would like to know if the approach mentioned above is doable, supported and certified.

    Best Regards,


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.