Database management Oracle space management & recycle bin 04.08.2011 by Yann Neuhaus 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(…)
Database Administration & Monitoring Diving into Databases 25.07.2011 by Stéphane Haby 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(…)
Application integration & Middleware Oracle 11g R2: catupgrd.sql running for hours 20.07.2011 by Jérôme Witt 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(…)
Database management Inside Grid Control 07.07.2011 by Oracle Team 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(…)
Hardware & Storage RMAN backup is failing due to “corrupt blocks” 29.06.2011 by Hervé Schweitzer 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(…)
Operating systems A preview of Windows 8 – codename Chidori 16.06.2011 by Stéphane Haby With the first video from Windows 8 the 02/06/2011 on YouTube, dbi services must talk about it to present you some information about Windows 8.
Database management Oracle Basics (3) – Database startup and shutdown 26.05.2011 by David Hueber It's already quite a while that I posted my last article on the Oracle basis, so I decided to take some times in the train to continue this small serie.This time, I'm going to speak about one of the(…)
Database management A brief PowerShell 2.0 overview 25.05.2011 by Stéphane Haby SQL server 2008 has PowerShell and at the end of this article, I speak of this topic but to use correctly Powershell, you must have a basic notion about this technologie. In microsoft Techdays in Basel, Marc van Orsouw presents(…)
Application integration & Middleware How to retrieve previous table statistics using Oracle dbms_stats 16.05.2011 by Yann Neuhaus Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis or because the execution plan changed. Oracle offers two methods: statistics restore or statistics export. Both are in the dbms_stats package.
Database management Pourquoi mettre une base de données Oracle en force logging ? 06.05.2011 by Oracle Team Certaines requêtes DDL offrent la possibilité de ne pas générer des enregistrements dans les redo log via la clause NOLOGGING. Le mode nologging permet donc dans certains cas d'accélérer des traitements, ceux-ci pouvant facilement être récupérables à travers des mécanismes(…)