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.

LOBs in Oracle are stored in-row when they are less than 4K in size and out-of-row otherwise.

I'm wondering how do SECUREFILE storage options COMPRESS and ENABLE STORAGE IN ROW work?

I have a lot of XML documents that are 4-10K in size that could easily be compressed to fit in under 4K. Would COMPRESS option result LOBs getting stored in-row therefore improving performance? Or does Oracle make in-row/out-of-row storage decision based on uncompressed size?

share|improve this question
1  
Why will having them in-row will improve performance? –  Jack Douglas Mar 27 '13 at 16:11
add comment

1 Answer 1

Consider using de-duplication if you have lots of identical XML - documentation link.

I wrote a huge unit test, but it turns out that SecureFile LOBs are always stored in a Lob Segment outside the row!

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.