Urh Srecnik

@usrecnik

Oracle DBA

Joined August 2024

About

DBA Team Lead and Oracle ACE Pro. Building database tools and helping teams manage Oracle infrastructure.

Available for

My main focus is making sure that Oracle Databases are running smoothly. That includes 24/7 monitoring of production and disaster recovery sites, pro-active work, patching and other, sometimes even mondane tasks. Those kind of services can only be provided with an ever-evolving team of professionals, which I am happy to be a part of, at [Abakus Plus d.o.o.](https://www.abakus.si).

Urh Srecnik's blogs

My Oracle DBA & Sysadmin Blogblog.srecnik.info17 posts

Articles Comments

Recently published

USUrh Srecnikblog.srecnik.infoApr 6 · 7 min read

Migrating LOBs on Standard Edition with Materialized View Logs

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

0

USUrh Srecnikblog.srecnik.infoFeb 17 · 5 min read

The Hidden Cost of Login (Redo)

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

0

USUrh Srecnikblog.srecnik.infoJan 11 · 5 min read

Reading Oracle ASM Files Directly Using x$kffxp

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

0

USUrh Srecnikblog.srecnik.infoDec 3, 2025 · 2 min read

utl_recomp and Automatic Statistics Gathering

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

0

USUrh Srecnikblog.srecnik.infoNov 10, 2025 · 2 min read

Legacy Clients on 19c

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

0

Urh Srecnik

About

Available for

Urh Srecnik's blogs

Recently published

Migrating LOBs on Standard Edition with Materialized View Logs

The Hidden Cost of Login (Redo)

Reading Oracle ASM Files Directly Using x$kffxp

utl_recomp and Automatic Statistics Gathering

Legacy Clients on 19c

Search Hashnode

Urh Srecnik

About

Available for

Urh Srecnik's blogs

Recently published

Migrating LOBs on Standard Edition with Materialized View Logs

The Hidden Cost of Login (Redo)

Reading Oracle ASM Files Directly Using x$kffxp

utl_recomp and Automatic Statistics Gathering

Legacy Clients on 19c