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
[…] LOB catalogue […]
Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 3:38 pm GMT Jan 28,2022 |