Oracle Scratchpad

January 29, 2022

Design catalogue

Filed under: Oracle — Jonathan Lewis @ 6:27 pm GMT Jan 29,2022

This is a list of all articles I’ve written that make some comments about things that might be worth remembering when you’re thinking about adding some new functionality to a system. 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 note including a reminder that you can associate global temporary tables with a specific temporary tablespace.
  • Sequence accelerator (Aug 2021): it’s important to think about the sequence cache size for most versions of Oracle, but an enhancement in 21c allows you to forget about it (almost). Links to a generic 4-part series on sequences written for Simpletalk.
  • SQL Table Macros (Aug 2021): a possible alternative to using CTEs (or pipelined functions)
  • Generating CSV from SQL*Plus (April 2021): a couple of hints and warnings.
  • Finding nearest – a case study (April 2021): lateral views, subqueries and bugs
  • Engineering indexes (Jan 2020): A case study about designing indexes to get maximum benefit for minimum cost.

1 Comment »

  1. […] Design catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 29, 2022 @ 6:50 pm GMT Jan 29,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: Logo

You are commenting using your 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

%d bloggers like this: