Oracle Virtualization and Cloud Consulting
view counter

Where is LOB data stored?

Thanks to Tanel Poder for this story

There was a question in Oracle-L about where is the LOB data actually stored (in the row or the LOB segments) and what are the exact conditions when a switch from one to another may happen. The documentation isn’t fully clear about this and the “4000 bytes” number may mislead people to think that you can store 4000 bytes of your data in a LOB item before it must move out-of-line.

Oracle Virtualization and Cloud Consulting
view counter

Read the entire article at its source

view counter