Database management

Oracle Basics (3) – Database startup and shutdown

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

A brief PowerShell 2.0 overview

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

Pourquoi mettre une base de données Oracle en force logging ?

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

Stop looking for Oracle Fusion and Oracle Grid Control documentation: use the dbi services firefox add-ons!

After my last post title "Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!" Some of you asked me for firefox search add-ons for Oracle Fusion(…)

Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!

Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are(…)

How to debug a Data Pump error

Recently, I had an Oracle error with Data Pump at a Customer, which was not easy to localize. Here is the error I received during a DBIOWNER schema export with Data Pump: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39125: Worker(…)

DBMS compression: determining a table’s compression ratio

According to the Oracle documentation, the dbms_compression procedure allows to determine the compression ratio for a table without creating it. Let's have a look at it.

Bug while installing Oracle 11.2.0.1 on AIX 6.1 SP2

Last week I encountered the following problem while installing Oracle 11g R2 on AIX 6.1 TL06 SP2. I met all the PreReqs of the installation document, but at the end of the installation process, I got(…)

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.

Génération de XML : le format des dates

Aprés une migration de 10gR2 vers 11gR2, une application utilisant les packages DBMS_XMLQUERY pour générer des documents xml est en erreur. Le format des dates a changé qu'a fait le DBA ?(…)