4

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?

  • 1
    Why will having them in-row will improve performance? – Jack Douglas Mar 27 '13 at 16:11
3

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!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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