Have you ever noticed strange figures while collecting the Oracle optimizer system statistics ? If so, you need to provide the optimizer with the correct number. In this posting, I will show you how.
Oracle 11g Archives - Page 8 of 8 - Blog dbi services
You have recently migrated to Oracle Database 11g Release 1 (11.1) and have had some issues with so called “mutexes”? Don’t worry, these nasty sounding mutexes (not mutants) can be handled quite easily as I will show in my post. But first of all, what are mutexes?
The Metalink note 949858.1 describes problems with 10.2.0.5 agents monitoring 11g databases – this might be the case if you have an “old” 10.2.0.5 Grid Infrastructure you did not want to upgrade yet. The 11g databases are generating errors in both the alert.log and the log.xml file. The agent 10.2.0.5 agent seems to have problem with this. This posting will show you what to do.
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 vais donc essayer de faire le tour des situations ou il y a avantage à utiliser cet outil.
While beginning to work with Oracle, one of the most common confusion is between Oracle database and Oracle instance. At most of the time the term Oracle Database is used to designate the whole Oracle RDBMS architecture. However looking deeper in what is an Oracle RDBMS Server, we can see that it is compose of 2 entities, the database and the instance.
So lets have a look to the difference between database and instance.