File crfclust.bdb for ora.crf service is too big Convertir en PDF Version imprimable Suggérer par mail
Écrit par Sidibe   

On Oracle RAC environment, OS and Cluster statistics are collected by the cluster monitor service ora.crf (Health Monitor Cluster (CHM)).

All collected informations are stored in the file crfclust.bdb.
Sometimes the size of the file crfclust.bdb grows so excessively to reach a size of 30 GB.
To fix the issue you must apply the Oracle patch 10165314.

 

You can also reduce the size using the following workaround.

Lire la suite de File crfclust.bdb for ora.crf service is too big
 
Disable firewall on Oracle Linux 7 Convertir en PDF Version imprimable Suggérer par mail
Écrit par Sidibe   

 

You must disable firewall when installing oracle RAC 11gR2 on Oracle Linux 7. Here is a statement to do that.

Lire la suite de Disable firewall on Oracle Linux 7
 
How to configure UDEV Scsi Rules for ASM in Oracle Linux 7 Convertir en PDF Version imprimable Suggérer par mail
Écrit par Sidibe   

 

Configure ISCI device using UDEV on Linux

Lire la suite de How to configure UDEV Scsi Rules for ASM in Oracle Linux 7
 
Non-indexed Foreign Key Constraints Convertir en PDF Version imprimable Suggérer par mail
Écrit par Sidibe   

 

This script is based on "Oracle Database Transactions and Locking Revealed" by T. Kyte.

It can help to find non-indexed foreign key to resolve lock events due to "on delete cascade" clause on the non-indexed child table.

It's also good for performance to have an index on the foreign key when we join PARENT and CHILD tables.

You must avoid indexing columns with high update frequency.

Lire la suite de Non-indexed Foreign Key Constraints
 
Looking for unused indexes in Oracle database Convertir en PDF Version imprimable Suggérer par mail
Écrit par Sidibe   

 

This script can help to find unused index in a given database

Lire la suite de Looking for unused indexes in Oracle database
 
How to purge Oracle SYSMAN tablespace Convertir en PDF Version imprimable Suggérer par mail
Écrit par Sidibe   

 

Purging Oracle SYSAUX Tablespace

Lire la suite de How to purge Oracle SYSMAN tablespace
 
<< Début < Précédente 1 2 3 4 Suivante > Fin >>

Résultats 1 - 10 sur 33