Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If I create a table that has a SecureFile column, does it mean that all the LOBs put into the column are automatically saved as files? In other words, DBFS and SecureFiles go hand in hand mandatorily or SecureFiles can exist without DBFS too?

share|improve this question
add comment

migrated from stackoverflow.com Aug 17 '12 at 17:54

This question came from our site for professional and enthusiast programmers.

1 Answer

No.

The words Secure Files should be interpreted that files can safely be stored in the database. This is often safer than storing them on the FileSystem with a reference from the database. If the file is in the database it is also protected by many of the database features. SecureFiles is the modern implementation of LOB's. The new implementation has a great performance boost compared to the old inplementation.

dbfs is a fileystem that can be created inside the database and that can be mounted on Linux using dbfs_client. Regular operating system processes see it as a regular POSIX filesystem. The LOB's in a dbfs should be implemented as SecureFiles to have the best performance. The performance of dbfs is better than that of NFS, if using filesystem like logging. With normal logging dbfs has about the same performance as NFS, with the added possibility of replicating the data to standby databases.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.