Toon Koppelaars
@toonkoppelaars.bsky.social
Real-World Performance @oracle - ACE Director alumnus - database design - architect of SQL assertions - 📖 Applied Mathematics for Database Professionals - @TUeindhoven alumnus - Views are my own
Pinned
fw_error_www
community.oracle.com
If you like this database idea, https://community.oracle.com/ideas/13028, you can vote it up by pressing the 'up-arrow'.
#sqlassertions #multirowconstraints
#sqlassertions #multirowconstraints
Next interesting topic.
November 20, 2025 at 7:58 AM
Next interesting topic.
This is just fan-tas-tic :-)
dev.to/sreeni5018/t...
dev.to/sreeni5018/t...
TOON vs JSON: A Modern Data Format Showdown
Introduction The evolution of data formats tells a fascinating story about how technology...
dev.to
November 12, 2025 at 12:27 PM
This is just fan-tas-tic :-)
dev.to/sreeni5018/t...
dev.to/sreeni5018/t...
Reposted by Toon Koppelaars
A little known about SQL feature... being able to "bring along extra columns" when you aggregate.
October 7, 2025 at 1:07 AM
A little known about SQL feature... being able to "bring along extra columns" when you aggregate.
Apart from the funny pronounciation of SQL, a pretty good summary of history here.
www.youtube.com/watch?v=lvCZ...
www.youtube.com/watch?v=lvCZ...
The Untold Story of Databases
YouTube video by CodeSource
www.youtube.com
September 16, 2025 at 6:50 AM
Apart from the funny pronounciation of SQL, a pretty good summary of history here.
www.youtube.com/watch?v=lvCZ...
www.youtube.com/watch?v=lvCZ...
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.
August 25, 2025 at 1:34 PM
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.
Reposted by Toon Koppelaars
If you're a DBA, this is essential viewing
youtu.be/QLyCcOBWb9o
youtu.be/QLyCcOBWb9o
DB Time, Average Active Sessions, and Active Session History - Core Performance Concepts for DBAs
YouTube video by Oracle Developers
youtu.be
July 14, 2025 at 2:45 AM
If you're a DBA, this is essential viewing
youtu.be/QLyCcOBWb9o
youtu.be/QLyCcOBWb9o
Reposted by Toon Koppelaars
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
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
May 13, 2025 at 3:01 PM
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
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
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...
May 4, 2025 at 4:07 PM
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...
Omg... Looks like I'm going to Poland :-)
April 24, 2025 at 7:35 AM
Omg... Looks like I'm going to Poland :-)
Reposted by Toon Koppelaars
Recognizable.
Mandatory Reading for IT folks....
Mandatory Reading for IT folks....
These 7 database design mistakes lead to trouble
Business field as primary key
Redundant data
Spaces in table names
No constraints
Many bits of data in one field
Many columns for optional data
Incorrect data types
Ben Brumm shows how to avoid them
Business field as primary key
Redundant data
Spaces in table names
No constraints
Many bits of data in one field
Many columns for optional data
Incorrect data types
Ben Brumm shows how to avoid them
7 Database Design Mistakes to Avoid (With Solutions)
📝 Get my Database Design Guides to many different sample databases: https://databasestar.mykajabi.com/lpkj-dbdesign/?video=s6m8Aby2at8🎓 Turn your idea into...
buff.ly
April 18, 2025 at 11:16 AM
Recognizable.
Mandatory Reading for IT folks....
Mandatory Reading for IT folks....
Just submitted my first abstract for POUG.
Now we sit and wait...
Now we sit and wait...
March 24, 2025 at 3:05 PM
Just submitted my first abstract for POUG.
Now we sit and wait...
Now we sit and wait...
Reposted by Toon Koppelaars
Some more details on the SQL Assertions feature. New language construct to get used to 😉.
March 18, 2025 at 6:27 PM
Some more details on the SQL Assertions feature. New language construct to get used to 😉.
Reposted by Toon Koppelaars
The (near) future of data integrity in the Oracle database is looking beautiful thanks to @toonkoppelaars.bsky.social and his team.
March 18, 2025 at 6:44 PM
The (near) future of data integrity in the Oracle database is looking beautiful thanks to @toonkoppelaars.bsky.social and his team.
Reposted by Toon Koppelaars
Feature X session tonight in a (almost) sold-out room. This feature coming soon.
There is another chance to learn more about this feature at #apexworld25 this Friday! nloug.nl/events/apex-...
There is another chance to learn more about this feature at #apexworld25 this Friday! nloug.nl/events/apex-...
March 18, 2025 at 5:28 PM
Feature X session tonight in a (almost) sold-out room. This feature coming soon.
There is another chance to learn more about this feature at #apexworld25 this Friday! nloug.nl/events/apex-...
There is another chance to learn more about this feature at #apexworld25 this Friday! nloug.nl/events/apex-...
Friday is the day...
March 17, 2025 at 9:00 AM
Friday is the day...
Reposted by Toon Koppelaars
New to database development? We've got a one-stop shop for your to get up to speed in just a few days
asktom.oracle.com/databases-fo...
asktom.oracle.com/databases-fo...
March 10, 2025 at 2:12 AM
New to database development? We've got a one-stop shop for your to get up to speed in just a few days
asktom.oracle.com/databases-fo...
asktom.oracle.com/databases-fo...
Reposted by Toon Koppelaars
btw, you might be able to get even BETTER performance across the network even when you have set your fetch size well.
youtu.be/PQjnaCuqtYw
youtu.be/PQjnaCuqtYw
February 24, 2025 at 2:58 AM
btw, you might be able to get even BETTER performance across the network even when you have set your fetch size well.
youtu.be/PQjnaCuqtYw
youtu.be/PQjnaCuqtYw
Another "whoah!" today...
#Oracle-DB: Estimate network latency of client connections by evaluation of Active Session History
It is always surprising what unexpected insights can still be drawn from the Active Session History.
rammpeter.blogspot.com/2025/01/orac...
It is always surprising what unexpected insights can still be drawn from the Active Session History.
rammpeter.blogspot.com/2025/01/orac...
Oracle-DB: Estimate network latency of client connections by evaluation of Active Session History
Oracle-DB: Estimate network latency of client connections by evaluation of Active Session History
rammpeter.blogspot.com
February 19, 2025 at 8:44 PM
Another "whoah!" today...
Enjoying a last good wine as a fifty- something.
New decade starts tomorrow. 😊
New decade starts tomorrow. 😊
February 13, 2025 at 8:57 PM
Enjoying a last good wine as a fifty- something.
New decade starts tomorrow. 😊
New decade starts tomorrow. 😊
Should have been:
Edit
Continue sending
As I'm already in the Send process...
Edit
Continue sending
As I'm already in the Send process...
December 28, 2024 at 7:55 PM
Should have been:
Edit
Continue sending
As I'm already in the Send process...
Edit
Continue sending
As I'm already in the Send process...
Reposted by Toon Koppelaars
Cosmologists, what is your take on this work?
Is dark energy seriously under threat?
Could the accelerating expansion of the universe just be because time runs faster in the voids between galaxies?
academic.oup.com/mnrasl/artic...
Is dark energy seriously under threat?
Could the accelerating expansion of the universe just be because time runs faster in the voids between galaxies?
academic.oup.com/mnrasl/artic...
Supernovae evidence for foundational change to cosmological models
ABSTRACT. We present a new, cosmologically model-independent, statistical analysis of the Pantheon$+$ Type Ia Supernovae spectroscopic data set, improving
academic.oup.com
December 23, 2024 at 9:09 AM
Cosmologists, what is your take on this work?
Is dark energy seriously under threat?
Could the accelerating expansion of the universe just be because time runs faster in the voids between galaxies?
academic.oup.com/mnrasl/artic...
Is dark energy seriously under threat?
Could the accelerating expansion of the universe just be because time runs faster in the voids between galaxies?
academic.oup.com/mnrasl/artic...
December 20, 2024 at 12:54 PM