Urh Srečnik

♠️ Oracle ACE Associate | DBA Team Lead @ Abakus Plus d.o.o. | OCP | Sym42

[Urh Srečnik @usrecnik]

Wrote up an approach for migrating BasicFile LOBs to SecureFile on Oracle Standard Edition using materialized view logs. Nothing groundbreaking - just one way to avoid the long table lock when ALTER TABLE MOVE isn't practical on large tables.

https://t.co/TzKT2VsxSj

[Urh Srečnik @usrecnik]

I dug into what happens during a regular Oracle login — LogMiner, redo dumps, and an undocumented parameter. Turns out every login generates a transaction.

https://t.co/pNYfe1Rqhe

[Urh Srečnik @usrecnik]

asmfs is my *experimental* project, available on GitHub:

https://t.co/7W5u4PXDrw

[Urh Srečnik @usrecnik]

my asmfs can now read Oracle ASM files directly from block devices using x$kffxp. Following post walks through how it works: using `x$kffxp` to figure out where each extent lives, then reading straight from disk.

https://t.co/eqjoUDYW4I

[Urh Srečnik @usrecnik]

Ever had utl_recomp.recomp_serial fail because it couldn't gather statistics concurrently? 🤔

Turns out recompilation still calls dbms_stats.gather_table_stats—which honors global concurrent stats preference.

Details:
https://t.co/UxKk9ehOhd

[Urh Srečnik @usrecnik]

USE_SID_AS_SERVICE - or rather, don't unless you need to; here's a scenario from 11g upgrade when this came in handy (embedded devices with hardcoded connection strings).

https://t.co/AC97MOSJw4

[Urh Srečnik @usrecnik]

Oracle Flashback Database can apparently auto-disable itself on I/O errors. I did a few quick test cases about it as I didn't expect this behavior initially. You can read about my findings here:

https://t.co/KwjRSGuUaU

[Urh Srečnik @usrecnik]

I tried implementing ASM filesystem using dbms_diskgroup.read() and found some quirks.
Here's what I learned: https://t.co/kOLbWy4Ow6

[Urh Srečnik @usrecnik]

Ever had to navigate multiple incarnations on a physical standby database — on Standard Edition?

Here’s how to handle RESETLOGS and make the right incarnation visible (and usable) on standby.

https://t.co/de2YY4ci0h

[Urh Srečnik @usrecnik]

Ever seen Oracle sessions get "stuck" because their dedicated server process is in STOPPED state?
Here's how I traced such behavior - not to Oracle itself, but to a third-party library hooking into the DB process.

Full story: https://t.co/oTKZRgVB2r

[Daniele Bocciolini @dbocciolini]

@usrecnik for the last session of the day at #itougtd2025 SQL*Net Encryption and Authentication 🧐

[Oracle ACE Program @oracleace]

Join ITOUG Tech Day 2025 this week in Milan. The streams will include Database, APEX, and Analytics & AI.
Register for free and hear from many great ACE speakers ♠️ 👉
https://t.co/OSDYXnwQuY
#OracleACE @IT_OUG

[Urh Srečnik @usrecnik]

I’m honored to be recognized as an Oracle ACE Associate in the @oracleace community.

Looking forward to continuing this journey and sharing more insights on Oracle technologies with all of you.

Big thanks to @monika_mitura for the nomination!

[Urh Srečnik @usrecnik]

In my latest blog post, I explore how to streamline user management with Proxy Users and Schema-Only Accounts in Oracle Database.
If database security and schema design are on your radar, take a look:

https://t.co/IyS9aRfrVB

[Urh Srečnik @usrecnik]

Did you know Oracle Native Network Encryption is available in all licensed editions of Oracle Database?
Here’s a quick how-to: https://t.co/xrEF7ul7iv

[Urh Srečnik @usrecnik]

You can read about "Introduction to JOIN LATERAL on Oracle" on my blog. It's sometimes overlooked feature which is available in Oracle since version 12c.

https://t.co/9odkrVLO8Z

[Urh Srečnik @usrecnik]

Collecting SQL Plan Baselines
on Standard Edition:
https://t.co/BXhWV8hLUm

[Urh Srečnik @usrecnik]

ddlfs-3.0-RC1 (beta release) is now released with native support for Windows 10/11. You can download installers from https://t.co/StBsEVom1m
or read more about a specific use case (git/mercurial) on my new blog https://t.co/MLBGFl6gUL .

[Andrej Grlica @AndrejGrlica]

#HrOUG2024 @usrecnik
Explains Optimizer 🚀

[Urh Srečnik @usrecnik]

@HeliFromFinland you're welcome to come along :)

[Urh Srečnik @usrecnik]

@HeliFromFinland we have a van with a lot of space. 5 seats are currently empty i think and we're also heading to ljubljana to tomorrow.