When recompiling invalid objects—often after patches, upgrades, or invalid dependency chains—you might call utl_recomp.recomp_serial. Since it's a serial procedure, one could reasonably expect it to avoid any parallel or background job interaction. B...

We've just migrated one of the last databases to 19c. The main area of concern for the client was that they were using rather old embedded devices, which had 11g client libraries and connect strings baked into their firmware. Here's the list of the m...

Today I learned that Oracle can disable the Flashback Database feature by itself automatically. Here's the reason - an excerpt from the alert log: ORA-38886: WARNING: Flashback database was disabled due to error when writing flashback database logs. ...

Here's what I've learned while trying to implement an ASMFS (which is an open-source GitHub project) and where my implementation fell short of my initial expectations. Initial Expectations I can access v$asm_file and v$asm_alias, which provide a comp...

On Standard Edition

Finally, I encountered a case that couldn't be solved using traditional Oracle Database tools. I've been experimenting with eBPF for some time, and this is a real-world scenario from an Exadata environment where I needed eBPF to help me truly underst...

Remember those MYAPP/MYAPP@MYDB logons? With all the security buzz and auditors out there, I thought of those as a thing of the past. This blog won't preach about the importance of strong passwords. Instead, I'll explain which capabilities of Oracle ...

As I come across environments where SQL*Net is not encrypted I sometimes also notice that there are two common misconceptions about it: First, some are afraid that certificates must be involved and consequently maintaining a PKI infrastructure is de...

Lateral join joins a subquery, which is executed as many times as there are rows in the leading table. Consider it as a kind of for-each loop. Most of, if not all, the problems it solves, can also be solved without lateral join (e.g. using analytic f...

on Standard Edition