Database management

Changing the reference instance for SQL Server Integration Service (SSIS)

In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services. When(…)

Take care while upgrading your Oracle DB with “DBUA”

Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.

Oracle space management & recycle bin

This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace/datafile) in Grid Control 11g. It also(…)

Inside Grid Control

Lors de mon activité de consultant, et suite à un bug qui n'affiche pas correctement le nombre de CPU (OMS 10.2.0.5, agent 10.2.0.5 et linux x86_64), je me suis intéressé à la manière dont Oracle(…)

Oracle Basics (3) – Database startup and shutdown

It's already quite a while that I posted my last article on the Oracle basis, so I decided to take some times in the train to continue this small serie.This time, I'm going to speak about one of the(…)

A brief PowerShell 2.0 overview

SQL server 2008 has PowerShell and at the end of this article, I speak of this topic but to use correctly Powershell, you must have a basic notion about this technologie. In microsoft Techdays in Basel, Marc van Orsouw presents(…)

Pourquoi mettre une base de données Oracle en force logging ?

Certaines requêtes DDL offrent la possibilité de ne pas générer des enregistrements dans les redo log via la clause NOLOGGING. Le mode nologging permet donc dans certains cas d'accélérer des traitements, ceux-ci pouvant facilement être récupérables à travers des mécanismes(…)

Stop looking for Oracle Fusion and Oracle Grid Control documentation: use the dbi services firefox add-ons!

After my last post title "Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!" Some of you asked me for firefox search add-ons for Oracle Fusion(…)

Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!

Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are(…)

How to debug a Data Pump error

Recently, I had an Oracle error with Data Pump at a Customer, which was not easy to localize. Here is the error I received during a DBIOWNER schema export with Data Pump: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39125: Worker(…)