Author | Lightnews

Toon Koppelaars

@toonkoppelaars.bsky.social

210 followers 90 following 1.5K posts

Real-World Performance @oracle - ACE Director alumnus - database design - architect of SQL assertions - 📖 Applied Mathematics for Database Professionals - @TUeindhoven alumnus - Views are my own

Posts Media Videos Starter Packs

Pinned

Toon Koppelaars @toonkoppelaars.bsky.social · Nov 19

If you like this database idea, https://community.oracle.com/ideas/13028, you can vote it up by pressing the 'up-arrow'.
#sqlassertions #multirowconstraints

fw_error_www

community.oracle.com

2 1

Toon Koppelaars @toonkoppelaars.bsky.social · 2d

That's what we have EBR for...
db-oriented.com/my-ebr-blog-...

My EBR Blog Post Series - @DBoriented

This is an index to a series of posts I have been writing about Edition-Based Redefinition. New entries will be added as soon as they are published. Part 1: Overview and Setup [1-Dec-2017] Part 2: Loc...

db-oriented.com

Reposted by Toon Koppelaars

Connor McDonald on Database and SQL @connormcd.bsky.social · 28d

A little known about SQL feature... being able to "bring along extra columns" when you aggregate.

1 8

Toon Koppelaars @toonkoppelaars.bsky.social · Sep 16

Apart from the funny pronounciation of SQL, a pretty good summary of history here.
www.youtube.com/watch?v=lvCZ...

The Untold Story of Databases

YouTube video by CodeSource

www.youtube.com

1 2

Toon Koppelaars @toonkoppelaars.bsky.social · Sep 1

My first one, and shortly thereafter the C64 ofcourse... :-)

Toon Koppelaars @toonkoppelaars.bsky.social · Aug 25

I noticed different people use the terms "inner" and "outer" table/rowsource differently for NL-joins. Never liked the terms myself: I always use 1st table/rowsource and 2nd table/rowsource when discussing NL-joins. And for HASH-joins: build and probe.

Toon Koppelaars @toonkoppelaars.bsky.social · Aug 20

Strange pic for connection leaks...
I like the pic though :-)
Be sure to keep on the lookout for #SQLAssertions

1 1

Toon Koppelaars @toonkoppelaars.bsky.social · Aug 7

Interacting...

Toon Koppelaars @toonkoppelaars.bsky.social · Aug 4

Another fine what-todo-when-retired example...

Toon Koppelaars @toonkoppelaars.bsky.social · Jul 18

🤣

Reposted by Toon Koppelaars

Connor McDonald on Database and SQL @connormcd.bsky.social · Jul 14

If you're a DBA, this is essential viewing
youtu.be/QLyCcOBWb9o

DB Time, Average Active Sessions, and Active Session History - Core Performance Concepts for DBAs

YouTube video by Oracle Developers

youtu.be

1 7

Toon Koppelaars @toonkoppelaars.bsky.social · Jul 13

Yeah,....
Be patient, please.

Toon Koppelaars @toonkoppelaars.bsky.social · Jul 12

Fantastic! 🤣

Toon Koppelaars @toonkoppelaars.bsky.social · Jul 10

The worries during retirement....
😜

1 1

Toon Koppelaars @toonkoppelaars.bsky.social · Jul 2

I read "statistics" as "patterns".
If there's dominant query-pattern now that joins data of T1+T2, then having T1+T2 data denormalized into 1 table, helps that pattern. But in-time this pattern may become irrelevant, and other patterns become dominant.
Fully normalized = neutral wrt query patterns.

2 5

Toon Koppelaars @toonkoppelaars.bsky.social · Jun 13

1965 was an extraordinary year... ;-)

1 2

Toon Koppelaars @toonkoppelaars.bsky.social · Jun 13

Been working on #10 a lot the past 2-3 years...

Toon Koppelaars @toonkoppelaars.bsky.social · Jun 10

Like Oracle v6...

2 6

Toon Koppelaars @toonkoppelaars.bsky.social · May 17

The same will happen with Google.
My kids don't use it anymore.

1 1

Toon Koppelaars @toonkoppelaars.bsky.social · May 16

Really like them!
trivadis.github.io/plsql-and-sq...

PL/SQL & SQL Coding Guidelines

trivadis.github.io

2 3

Reposted by Toon Koppelaars

Chris Saxon @chrisrsaxon.bsky.social · May 13

Oracle Database Free 23.8 is now available

Get it at

www.oracle.com/database/fre...

This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL:

Enhanced dynamic stats for PL/SQL in FROM & WHERE

This can be particularly useful for estimating pipelined table functions

Dynamic stats for PL/SQL functions (23.8)
Improve row estimates for PL/SQL functions in SQL with dynamic stats
By default row estimates for pipelined table functions are poor

Dynamic stats for PL/SQL functions (23.8)
Improve row estimates for PL/SQL functions in SQL with dynamic stats
With dynamic PL/SQL stats in 23.8, get accurate row estimates for pipelined functions

1 12 25

Toon Koppelaars @toonkoppelaars.bsky.social · May 4

Morgen 80 jaar geleden, verloor mijn vader (nu 90) één van zijn zussen. Zijn ouders hadden gehoord dat NL bevrijd was en gingen met 'n roeiboot met hele gezin van boord naar de wal, om 't te vieren. Een paar Duitse soldaten op de dijk hadden het bericht nog niet gehoord, en schoten op de roeiboot...

Toon Koppelaars @toonkoppelaars.bsky.social · May 3

Six saws?

2 1

Toon Koppelaars @toonkoppelaars.bsky.social · Apr 30

I beg to differ, and have seen the opposite:
www.youtube.com/watch?v=8jiJ...

NoPLSql and Thick Database Approaches with Toon Koppelaars

YouTube video by Oracle Learning

www.youtube.com

Toon Koppelaars @toonkoppelaars.bsky.social · Apr 29

ICT: one of the few industries where we do not learn from history...

Toon Koppelaars @toonkoppelaars.bsky.social · Apr 25

It'll be my 1st one. I'm very late to the party. But in the end, it was inevitable... #POUG2025