Database management SQL Server 2012 ‘Denali’: a new panel of DMVs 17.11.2011 by Stéphane Haby Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.Since few months, I test the future new version SQL Server 2012 codename Denali and(…)
Database management Oracle RunInstaller crashes while installing Cloud Control 12c on OEL 5.7 07.11.2011 by Yann Neuhaus 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.
Database management Database space management issue with Grid Control 11g 19.09.2011 by Yann Neuhaus 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(…)
Database management Changing the reference instance for SQL Server Integration Service (SSIS) 02.09.2011 by Stéphane Haby 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(…)
Database management Take care while upgrading your Oracle DB with “DBUA” 11.08.2011 by Hervé Schweitzer 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.
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 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(…)
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(…)
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(…)