@usrecnik

Migrating LOBs on Standard Edition with Materialized View Logs

Apr 6 · 7 min read · LOBs can be stored as either BasicFiles or as SecureFiles. While both storage types are still supported in 19c, let me start by a quote from 12.1 documentation: SecureFiles is the default storage mec

The Hidden Cost of Login (Redo)

Feb 17 · 5 min read · I was investigating an issue where there were a lot of user logins to Oracle database via listener due to misconfigured connection pool. This post explains why many logins could be a problem. Most would first think of the cost of process creation, me...

Reading Oracle ASM Files Directly Using x$kffxp

Jan 11 · 5 min read · In a previous post, I explored implementing asmfs using dbms_diskgroup.read(). Since then, asmfs (my open source GitHub project) has gained a new capability: reading files stored in Oracle ASM by directly accessing block devices. Rather than needing ...

utl_recomp and Automatic Statistics Gathering

Dec 3, 2025 · 2 min read · 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...

Legacy Clients on 19c

Nov 10, 2025 · 2 min read · 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...