Infrastructure at your Service

David Hueber

Flying with “Air Oracle”

By | Technology Survey | One Comment

Finally after a 18 hours, doors-to-doors, journey I’m arrived in San Francisco for Oracle OpenWorld 2011. My trip started in Basel, making a stop in Paris and then an 11 hours flight to San Francisco. Even with the on-board movies this kind of flight are still quite boring, but the funny things is that I really though that I was flying with “Air Oracle“…

Read More
Stéphane Haby

SQL Server Tuning: Detect SPARSE columns candidate

By | Application integration & Middleware | 6 Comments

dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.
The property of Spare columns is not the most used in client environment that we have seen.
This article present a script to find the potential columns that can have the sparse property with the usage restrictions to make a space tuning in your database and especially for Data Warehouse (DWH).

The database example that we used, is AdventureWorksDW2008R2.

Read More
Stéphane Haby

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

By | Database management | No Comments

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 Integration Service is installed with the instance “TOTO” and that it is at the end of his life, we’ll see how to transfer information to the second instance “TITI”. We present you a small working method to transfer information correctly.

Only the folders transfert is presented in this article and the  transfert of the SSIS packages are explained at the end.

Read More
Oracle Team

LOB : « enq : HW contention » 

By | Hardware & Storage | No Comments

AprĂ©s le post sur « Utilisons les securefile Â», revenons sur le sujet LOB avec une approche performance, stockage.

 Nous rencontrons parfois des modèles de donnĂ©es Ă©tranges, nous aurions envies en tant que DBA de tout reprendre Ă  zĂ©ro pour refaire un modele relationnel en 3em forme normal (3NF), plus efficace et mieux conçu dans notre « RDBMS Â» favori, mais la rĂ©alitĂ© Ă©tant ce qu’elle est nous devons faire avec et au mieux.

De plus Oracle n’est pas qu’une base de donnĂ©es relationnelle 🙂 on l’oublie trop souvent.

Read More
Yann Neuhaus

Oracle space management & recycle bin

By | Database management | One Comment

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 relates and explains an issue (ORA-01652) observed on pre 11.2 Oracle releases (targets) concerning the tablespace/datafile space management and the recycle bin. First of all, a simple example: let’s check the used and available space…

Read More
Stéphane Haby

Diving into Databases

By | Database Administration & Monitoring | 3 Comments

By dbi services, we are a few poeples passionate by diving.
We take this opportunity to let you dive into the two databases lakes Oracle and SQL server and see their similarities and differences. For this first level of diving (named ODD), we will not going too deep and not have narcosis or

databases toxicity.
As always, we’ll start with a short briefing to present the environment and the different themes.
Have a nice dive !



Read More
Oracle Team

Inside Grid Control

By | Database management | No Comments

Lors de mon activitĂ© de consultant, et suite Ă  un bug qui n’affiche pas correctement le nombre de CPU (OMS, agent et linux x86_64), je me suis intĂ©ressĂ© Ă  la manière dont Oracle Enterprise Manager Grid Control (OEM GC) rĂ©cupĂ©rait les informations de mĂ©moire et de cpu sur les diffĂ©rents hĂ´tes surveillĂ©s par ce dernier.

Read More