Skip to content

DBD::Oracle

Improve Oracle Insert Performance with BULKCOLLECT and FORALL

As specified by Steven Feuerstein into the Oracle Blog Website the bulk processing features of PL/SQL are designed specifically to reduce the number of context switches required to communicate from the PL/SQL engine to the SQL engine. Using BULK COLLECT plus FORALL instead of standard Insert statement to insert data improve performance dramatically, let’s me show you : Here is… 

From Oracle Standard Auditing to Oracle Unified Auditing

In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in a multitenant environment Oracle 12c – RMAN and Unified Auditing – Does it really work ? Purging Unified Audit Trail in 12cR2… 

Create and configure an Oracle linked server in SQL Server Instance

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit hard. For exemple moving some data from an Oracle database to a SQL Server database is not easy. A linked… 

Install oracle database client

Install Oracle instant client and perl DBD::Oracle @ Mac OS X Yosemite

Recently, I tried to install and connect to Oracle databases directly from my new Mac Book using perl  (Yes, perl is still one of the most friendly programming language for DBAs). What first seemed to be easy was in reality quite difficult and long. Alone, the huge quantity of  hits on the WorldWideWeb was impressive. However none of the hits…