Hardware & Storage

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

RMAN backup is failing due to “corrupt blocks”

Last week, I was not able to complete a backup because of the ORA-19566 error: “exceeded limit of 0 corrupt blocks”. Here is what you can do to fix it. Starting Point: backup error Here is(…)

VMware Tools auf Oracle Enterprise Linux 5.6 Guests installieren

Wenn Sie einen Oracle Datenbank Server auf VMware ESX betreiben, sollten Sie die VMware Tools nicht unterschätzen. Sie sind nicht nur sinnvoll bei Copy-Paste-Aktionen oder für bessere Grafiken, sondern liefern ebenfalls High-Performance-Network, Storage Adapter (PVSCI), Treiber, etc. Auf Linux Guests(…)

Saving time and increasing service availability with MySQL Enterprise Monitor 2.3

Nowadays MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is no more available. In order(…)

NetBackup – OpsCenter patch fails due to space requirements…

I was upgrading Netbackup yesterday to version 7.0.1 and faced a quite "funny" issue with the OpsCenter. The installation failed on pre-requirements checks saying that no space was available. Nothing strange at this point...except that we still had about 79GB(…)

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

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

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

NetBackup command lines – Tips

NetBackup provides a pretty nice Web Interface, OpsCenter, to monitor and check the basic configuration. However after working a while with it, you may find that some information can be quit boring to find out. Good news! Symantec didn’t forget(…)