Sequence catalogue

This is a list of all articles I’ve written about sequences. Each entry has a date stamp and a short note of the contents. The articles are grouped in a couple of different categories (mainly because I hadn’t previously created an index for a short series I wrote for Simpletalk), but otherwise are generally listed most-recent first.

Miscellaneous

• Sequence Accelerator (Aug 2021) – a follow-up to a note by Connor McDonald about a recent (19.10) enhancement to internal sequence handling that aims to reduce pressure on the seq$ table. (Starting with a link to a threat warning in the comments).
• Distributed Sequences pt.1 (March 2021) – a critical point about inserting into a local table with a local sequence and a fully remote query.
• Distributed Sequences pt.2 (June 2021) – a little follow-up to the previous note.
• Sequence Costs (March 2020) – a bug introduced in 19.3 (fixed by 19.11) when the audit_trail parameter is set.
• Sequences (March 2007) – “how do you tell which column is using this sequence?” That’s not the way it works in Oracle (until several years later and 12c “identities”) but …

A series written for Simpletalk

• Oracle sequences: The basics (Mar 2021)
• Oracle sequences: RAC (May 2021)
• Typical uses of Oracle sequences (July 2021)
• Oracle sequences – 12c features including “identity” (Aug 2021)