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
Code
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:
Uncategorized
The beauty of Java stored procedures
Since 8i you can write stored procedures also in Java. But what is the advantage of writing a procedure in
Misc
BULK COLLECT & FORALL vs. CURSOR & FOR LOOP
After more and more reads about BULK COLLECT and FORALL and their performance improvements I decided to have a closer