All articles

Reading Oracle documentation with an ipad – What Steve Jobs doesn’t tell!

The chrismas period is over and it is now time to enjoy the several gifts brought by Santa Claus. Under my Chrismas Tree I discovered this year an iPad.

Huge Pages and AMM is (not) possible with 11.2.0.2!

Running Linux servers configured with Huge Pages was not always adapted when both 10.2 and 11.2 databases had to be started in parallel. Since 11.2.0.2 this situation changed !(…)

Bug while installing Oracle 11.2.0.1 on AIX 6.1 SP2

Last week I encountered the following problem while installing Oracle 11g R2 on AIX 6.1 TL06 SP2. I met all the PreReqs of the installation document, but at the end of the installation process, I got(…)

LOB : Utilisons les SecureFiles

Le stockage des LOB est souvent négligé lors de la création des tables. Hors les choix de stockage ont un impact sur la performance d'accès aux données. nous allons voir rapidement dans cet article l'avantage à utiliser le stockage SecureFiles(…)

Oracle Basics (2) – Data Storage

What is finally the primary objective of a database? Storing Data The question is, how Oracle makes it. For many beginners a confusing topic isto get the picture between physical storage and logical one. So how does it(…)

Getting rid of network acces issues after migrating to Oracle 11.2

Are you experiencing network access issues after a migration to Oracle Database 11g Release 2 (11.2)? If yes, you probably have to allow the concerned PL/SQL packages to access your network again. This posting will show you how.

A test database in one click – with Oracle Data Guard 11g

Are you confronted with  Developper or Application Owner wich want to have very soon a test database available,  to test the new developped code or to validate some code change before to  implement it ? With Data Guard 11g you(…)

Génération de XML : le format des dates

Aprés une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour générer des documents xml est en erreur. Le format des dates a changé qu'a fait le DBA ?(…)

Password Oracle : vos mots de passe sont-ils sécurisés ?

Quelles sont les faiblesses de l’encryption des mots de passe Oracle ? Comment est-ce qu’Oracle crée les clés de hachage afin d’en améliorer la sécurité ? C’est ce que je vous propose de découvrir dans ce post. Le mot de(…)

How to connect to an Oracle database using the perl DBI module and DBD::Oracle “as sysdba”?

Well, I have read many posts about this, but was unable to find a suitable solution up to now … Google was not my friend(…)