Hi,

We have LOB fileds in our table. We always keep LOB in separate tablespace than Table. Also, we use DISABLE
STORAGE IN ROW clause for LOB to make sure all contents
of LOB are stored outside table. We have OLTP and some queries do FTS on table. If first 4000 bytes are stored
in table, FTS will be costly.

HTH,

Let me know if you need more info.

np70