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“…
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.
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 my last post about the free space management in a tablespace in relation to the recycle bin management.
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.
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.
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.
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.
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…
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
As always, we’ll start with a short briefing to present the environment and the different themes.
Have a nice dive !
During the last weeks, I was confronted to an uncommon bug during the database upgrade from security sensibledatabases.
The upgrade was sticking for hours on the script c1101000.sql. which tried to fill the column DBID with the database DBID of the tables AUD$ and/or FGA_LOG$.
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 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.
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 the starting point of this case. The following error is found in the RMAN Backup log file: allocated channel: ch1 channel ch1: sid=25 devtype=DISK Starting backup at 27-APR-11 channel ch1: starting incremental level 0 datafile backupset channel ch1: specifying…