LOB Catalogue

This is a list of all articles I’ve written that talk about LOB handling. Each entry has a date stamp and a short note of the contents. The articles will generally be listed most-recent first.

I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.

• GTT LOBs (Aug 2021): a delayed report of an error in the 12.1.0.2 data dictionary about lobindex placement, and a reminder that you can associate global temporary tables with a specific temporary tablespace.
• In-row LOB lengths (Nov 2020): Oracle is not good at reporting the column lengths when the column is a LOB (and not consistent across versions), so you need to check the details carefully.
• Costs of reading LOBs (Aug 2019): it’s important to check exactly what a client program does to fetch LOBs from the database – it may be doing far more network round-trips than you expect.
• How big are your LOBs (May 2019): a few key points to avoid surprises about the space that disappears when you start using LOBs.
• Optimizer LOB costs (May 2018): an example of the optimizer including unexpected and unnecessary arithmetic adjustments for predicates involving LOBs.
• Basicfile LOBs (Jan 2017): a series of 6 articles on basicfile LOB implementation and a performance threat due to high volume deletes and updates that may be fixed in 19c