---
title: "Urh Srecnik (@usrecnik) | Hashnode"
description: "Oracle DBA. Read the latest articles by Urh Srecnik on Hashnode."
url: "https://hashnode.com/@usrecnik"
---

@usrecnik

# Urh Srecnik

@usrecnik · Joined August 2024

Oracle DBA

### [Using ASMFS with NFS and fstab](https://blog.srecnik.info/using-asmfs-with-nfs-and-fstab?utm_source=hashnode&utm_medium=feed)

One of the most interesting use cases for ASMFS seems to be the ability to list/read archivelogs on a remote (physical standby?) server as if they were normal local files. A quick mental image of how

8 min read · [blog.srecnik.info](https://blog.srecnik.info/using-asmfs-with-nfs-and-fstab?utm_source=hashnode&utm_medium=feed)

[Aug 17](https://hashnode.com/posts/using-asmfs-with-nfs-and-fstab/6a835e93ffff8b298d889894)

### [How direct-path inserts and one extra row per loop bloated 18 MB into 8 GB](https://blog.srecnik.info/how-direct-path-inserts-and-one-extra-row-per-loop-bloated-18-mb-into-8-gb?utm_source=hashnode&utm_medium=feed)

I was investigating the code that looked something like this: truncate table t1; for i in 1..300 loop insert /\*+ append \*/ into t1 select 1 from dual connect by level <= p\_connect\_by\_level;

10 min read · [blog.srecnik.info](https://blog.srecnik.info/how-direct-path-inserts-and-one-extra-row-per-loop-bloated-18-mb-into-8-gb?utm_source=hashnode&utm_medium=feed)

[Jul 5](https://hashnode.com/posts/how-direct-path-inserts-and-one-extra-row-per-loop-bloated-18-mb-into-8-gb/6a4a1e03029ce5ae887f504d)

### [Migrating LOBs on Standard Edition with Materialized View Logs](https://blog.srecnik.info/migrating-lobs-on-standard-edition-with-materialized-view-logs?utm_source=hashnode&utm_medium=feed)

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

7 min read · [blog.srecnik.info](https://blog.srecnik.info/migrating-lobs-on-standard-edition-with-materialized-view-logs?utm_source=hashnode&utm_medium=feed)

[Apr 6](https://hashnode.com/posts/migrating-lobs-on-standard-edition-with-materialized-view-logs/69d4276d40c9cabf44931269)

### [The Hidden Cost of Login (Redo)](https://blog.srecnik.info/the-hidden-cost-of-login-redo?utm_source=hashnode&utm_medium=feed)

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

5 min read · [blog.srecnik.info](https://blog.srecnik.info/the-hidden-cost-of-login-redo?utm_source=hashnode&utm_medium=feed)

[Feb 17](https://hashnode.com/posts/the-hidden-cost-of-login-redo/6994833dde0065acf32acefb)

### [Reading Oracle ASM Files Directly Using x$kffxp](https://blog.srecnik.info/reading-oracle-asm-files-directly-using-xkffxp?utm_source=hashnode&utm_medium=feed)

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

5 min read · [blog.srecnik.info](https://blog.srecnik.info/reading-oracle-asm-files-directly-using-xkffxp?utm_source=hashnode&utm_medium=feed)

[Jan 11](https://hashnode.com/posts/reading-oracle-asm-files-directly-using-xkffxp/6963fa277ebb52043a91545a)
