Hi,

We are experiencing from time to time an oracle error : ORA-04031.

We've detected that are %reloads is very high of the BODY namespace . Is there anything we can check what is causing this?

Command:
SELECT NAMESPACE, PINS, PINS-PINHITS LOADS, RELOADS,INVALIDATIONS, 100 * (RELOADS - INVALIDATIONS) / (PINS-PINHITS) "%RELOADS" FROM V$LIBRARYCACHE WHERE PINS >0 ORDER BY NAMESPACE;

NAMESPACE PINS LOADS RELOADS INVALIDATIONS %RELOADS
BODY 694.662 4.176 2.690 0 64
CLUSTER 4.786 86 0 0 0
INDEX 53.067 913 0 0 0
SQL AREA 81.820.418 111.392 23.930 5.143 17
TABLE/PROCEDURE 31.314.703 100.736 25.518 0 25
TRIGGER 2.046.015 6.184 3.355 0 54

Any help is welcome. Thanks.