Reading List – August 2025 #4
📰 💡 Using a modern database? You might not need that ORM anymore – Anders Swanson shares his thoughts on […]
Code
Oracle Database Materialized Columns – a closer look
My recent blog post about Oracle Database 23.7 has generated significant interest in one particular feature: materialized columns. In this
Reading List – August 2025 #2
📰 Were you aware of the two hidden columns in CDB-Views? – Mike Dietrich shares some interesting insights regarding the
Reading List – August 2025 #1
📖 UUID() Function in Oracle Database 23ai – Oracle Base demonstrates the new UUID function 📰 You don’t have to
Reading List – July 2025 #4
📰 Idle Chatter – David Fitzjarrell shows how DBAs can use user profiles to limit the number of idle sessions
Technology
Loading data fast – DML error logging performance
In the last post of my “Loading data fast” series I showed how DML error logging can be used to
Technology
Loading data fast – Batch inserts and errors (DML error logging)
In the last post of my series “Loading data fast” I showed how batch inserts can actually make a huge
Technology
Loading data fast – regular insert vs. bulk insert
In my last post I talked about how persisting data can become the bottleneck on large high scale systems nowadays.
Technology
Loading data fast
Today more and more applications have the requirement to load data fast. While this requirement isn’t new in IT, nowadays
Uncategorized
Easy way to write SYS.XMLTYPE into a file using JAVA
It has been a while since my last post and I’m very sorry for that but I’m currently very busy
Misc
11g and the new SecureFILE LOB data type (simple quick test)
As I had to run some comparison test Oracle 10g and 11g I also did a little test with the
Misc
Prepared statement in batch mode vs. FORALL in PL/SQL
A few days ago I had a nice discussion with one of our developers here in the office. The subject: