ORA-04031
A simple question : if I get an ORA-04031 on a database, which Metrics should I verify to try and find the cause of this error ?
OEM is nicely reporting the ORA-04031 when it occurs, but the next step is to go back in time, and to check which Metric (if any) will show behaviour linked to the cause of the error.
Stated differently, which Metric can be or actually is the indicator for this error.
I do know causes of this error can be diverse, but there are also lots of Metrics, right ?