Oracle Scratchpad

January 28, 2022

LOB Catalogue

Filed under: Oracle — Jonathan Lewis @ 2:35 pm GMT Jan 28,2022

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

1 Comment »

  1. […] LOB catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 3:38 pm GMT Jan 28,2022 | Reply


RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by WordPress.com.

%d bloggers like this: