Little Snitch for Linux Discover powerful applications such as Little Snitch Mini, Little Snitch, LaunchBar and Micro Snitch.

When I used a Mac, Little snitch was always on my machine.
It's now available for Linux 🎉
obdev.at/products/lit...

Osterkerze der Stadtpfarrkirche Melk

Christus surréxit!
Surréxit vere, allelúja!

It's simply the perfect day:
When the system comes up again, it feels like resurrection; and the admin whispers in relief:
Halleluja!

The Hitchhiker’s Guide to connecting to Oracle from Python Aliens are among us.If you want proof, just try getting a minor software upgrade applied to a server in a large organisation and you will be sure to run into a level of bureaucracy that can only ha…

Want to connect Python to Oracle AI Database?

@antikyte.bsky.social has built a guide of installing & using

cx-Oracle with Python 3.6.8
python-oracledb with Python 3.12

Showing how to

select from a table
execute a packaged procedure
execute a packaged function

You are capable of doing it ad-hoc!
Of course demos need preparation, as well as timing and taking care of completeness.
Enjoy the talk ;)

3️⃣👍😁

you can use it to generate a queueing of "active" sessions.
It just has another definition of "active" than the v$active_session_history.

note to self: when investigating Resource Manager, RTFM!
example: ACTIVE_SESS_POOL_P1 is not so much related to "active session" ( as in "active session history") - instead it's
"Maximum number of calls this consumer group can run concurrently"

input field for a date. in the field, the format mm/dd/yyyy is shown. The comment below mentions TT.MM.JJJJ

🤔

Operational Excellence, Strategic Incompetence The president and his advisers are in the grip of “victory disease.”

“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 25-30 years ago I worked a lot with the Danish developed ERP system called Concorde XAL. It ran on top of a database (choice of several, mos...

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...

ERD example with Mermaid ERD example with Mermaid. GitHub Gist: instantly share code, notes, and snippets.

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)

Enforcing Acyclic Hierarchies With SQL Assertions Introduction Referential integrity constraints have been available since version 7 of the Oracle Database. While these constraints ensure that referenced rows exist, they cannot express more complex i...

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 have OJVM configured but install the OJVM bundle. So, what has happened to the 19.29 and 19.30 RUs??

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.