All articles

Oracle RunInstaller crashes while installing Cloud Control 12c on OEL 5.7

A few days ago I downloaded the Cloud Control 12c binaries for Linux x86_64 from the Oracle Technet. My friend, Hervé Schweitzer, configured an OEL 5.7 VM for test purpose and I was quite eager to install this new software.

Partition exchange preview in MySQL 5.6

MySQL 5.6 proposes improved partition maintenance through "partition exchange". Even if not yet available, dbi services performed some tests on the MySQL Community Edition5.6.2 m5 release (still under Development).

SQL Server 2012 ‘Denali’ : AlwaysOn High Availability – Restore is blocked

During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the restoring of databases of the secondary cluster node. In this article, we will just explain you(…)

Windows Server 8 Hyper-V 3.0: a real step forward in virtualization

As we are on Microsoft Connection Days 2011 in Lausanne yesterday, we have a presentation of Windows Server 8 and specifically of Hyper-V 3.0.I take this opportunity to introduce some news about this.

SQL Server Tuning: Detect SPARSE columns candidate

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(…)

Database space management issue with Grid Control 11g

My colleague Hervé Schweitzer reported a very interesting issue to me. It is about the usage of Grid Control 11g while monitoring the available space on an Oracle database – in our case a 10.2.0.3 target database. This post continues(…)

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(…)

Compression advisor: excessive redo log file generation

Last week by a customer, we experienced an excessive redo log generation filling up rapidly the FRA (Flash/Fast Recovery Area) with archivelog files which caused the database to crash.

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.

LOB : « enq : HW contention » 

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 à(…)