“victory disease ... believing that winning those battles means that they are winning the larger war or achieving some grand strategic aim—right up until the moment they realize that they have overreached and find themselves facing a military disaster or even total defeat."
Assertions for data integrity on a less-than-ideal data model.
www.kibeha.dk/2026/03/asse...
Or "How I could have used assertions 25 years ago when I worked with Concorde XAL"...
#OrclDB #SQL #Assertions #OracleACE
note to self: never use query block names longer than 20 characters. They will be ignored anyhow.
New blog: Testing the Datadog Explain Plan Visualizer with Oracle execution plans
tanelpoder.com/posts/testin...
see gist.github.com/PhilippSalvi...
You can skip columns entirly, keep just PK/FK columns or PK/FK columns with some important columns.
Do you have a template for E & R?
(played a little bit with Mermaid, but have nothing beautiful yet)
Hierarchies should be trees and not loops.
Learn how SQL Assertions in Oracle AI Database 23.26.1 can help prevent cycles in hierarchical data.
www.salvis.com/blog/2026/02...
note to self: when using qb_name hint, always enclose the name with "
note to self: when tweaking arraysize, don't remember prefetchrows.
otherwise:
FETCH #1: e=23, r=2
WAIT #1: nam='SQL*Net message to client' #bytes=21
FETCH #1: e=3651, r=998
WAIT #1: nam='SQL*Net message to client' #bytes=8176
python-oracledb.readthedocs.io/en/latest/us...
For Database-folks: What do you use to draw ERDs ?
(remind me to re-post this on Monday...)
Memento, homo,
quia pulvis es,
et in pulverem reverteris.
What has happened to the 19.29 and 19.30 RUs?
Many of you mailed us asking why AutoUpgrade does not download 19.29 or 19.30 RUs anymore. Others just noticed that the RUs got pulled without further communication visible. And a few people informed me about an issue with the 19.30 RU when you don't…
Playing with OracleDB assertions. Learning new error messages.
ORA-08673: Equijoin "E"."DEPARTMENT_ID"="D"."DEPARTMENT_ID" found does not meet the criteria to do a FAST validation.
Good explanation on docs.oracle.com/en/error-hel...
Stay safe!
🔥
note to self:
in 23.26.1 the GO_FASTER hint is replaced by "LUCK = YES"
It seems there is something in the Docu already:
> ASC | DESC
> ...
> Oracle Database treats descending indexes as if they were function-based indexes.
docs.oracle.com/en/database/...
Probably one of those situations where you first need to find the symptoms before understanding the doc line.
Stop referring to ICE and CBP as law enforcement. They're Violence Workers.
My outlook did not know UTC today.
Reykjavik is equal to UTC right now.
( In fact it's DST to their location, but they prefer it )
The latest #Exadata System Software Updates for 25ai (25.2 and 25.1) are now available. Details on the @exadatapm.bsky.social PM Blog site - blogs.oracle.com/exadata/post...
From now on, I will schedule all (international) meetings in Reykjavik time - offloading the mapping to local timezones to local attendees.
They are trolling Trump in public. 🙂😂💙
Call for Papers für die #DOAGDB26. Jetzt wird es aber Zeit! Wenn ihr mit eurem Vortrag auf der DOAG 2026 Datenbank mit Cloud Infrastructure dabei sein wollt, dann reicht euren Vortrag noch heute bis um 23:59 Uhr MEZ, ein! Wir freuen uns! ➡️ scomp.ly/953Pr5Y
#Datenbank #CloudInfrastructure
A much-liked post by Germany’s satirical newspaper @der-postillon.com with the titles “Vienna Academy of the Arts offers Trump admission as a student” and the caption “They don’t want to get blamed again“
A joke for the history buffs:
Germany’s satirical newspaper @der-postillon.com titles: “Vienna Academy of the Arts offers Trump admission as a student — They don’t want to get blamed again“
2024: can Europe defend itself ALONGSIDE America?
2025: can Europe defend itself WITHOUT America?
2026: can Europe defend itself AGAINST America?
Only one more day to submit for
DOAG 2026 Database with Cloud Infrastructure
CfP ends TOMORROW!
Take this final chance to be part of this event and enter your abstract on https://datenbank.doag.org/en/speakers/.
@doag #DOAGDB26
See all Events and CfPs on www.clocwise.org.
"innerhalb der Schwankungsbreite"
Note to self: when MERGE PARTITION fails due to the partition scheme, consider EXCHANGE PARTITION (via an interim table) to a PARTITION BY SYSTEM table.
Merge there and then do what you planned beforehand.
especially this morning Vienna is covered in ice - it feels the sidewalks even more.
@oraclesean.com if you are still here, just take some more minutes for any walk.
my asmfs can now read Oracle ASM files directly from block devices using x$kffxp (no longer relying on dbms_diskgroup). Following post walks through how it works: using `x$kffxp` to figure out where each extent lives, then reading straight from disk.
blog.srecnik.info/reading-orac...
Today harvest was directly consumed
