Oracle Database Discussions

Hi,

According to the documentation the REQUEST_FAILURES from v$shared_pool_reserved view means this

Number of times that no
memory was found to satisfy a request (that is, the number of times the error ORA-04031 occurred)^{Foot 2}

SQL> select free_space, avg_free_size, free_count, max_free_size, request_misses, request_failures
  2  from v$shared_pool_reserved;

                          AVERAGE                                            REQUEST          REQUEST
      TOTAL FREE       CHUNK SIZE            COUNT    LARGEST CHUNK           MISSES         FAILURES
---------------- ---------------- ---------------- ---------------- ---------------- ----------------
     983,386,912        2,452,336              333        3,358,536                0          138,504

So, according to the above definition we’ve got 138504 ORA-04031.

The Alert log files doesn't show such a very high number of ORA-04031

What do you think? Is the documentation wrong in this case?

Thanks