DBA

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

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

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

SQL Developer 3.0 : prêt pour les DBA

La nouvelle version d'Oracle SQL Developer (version 3.0.03.45) est prête pour les administrateurs de base de données/DBA (voici une vidéo sur cette version). Elle s'est vue agrémentée d'outils nécessaires aux tâches d'administration. Les tests ci-dessous vous présentent, à travers(…)

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.

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

Automatic Storage Management (ASM) : pourquoi pas ?

Depuis la sortie de la version Oracle 11g R2, il y a désormais de nombreuses raisons d'utiliser ASM (Automatic Storage Management) pour gérer l'espace disque des bases de données Oracle. Souvent, je/on m'interroge sur les avantages de ce choix. Je(…)