V$SHARED_POOL_RESERVED
This view displays statistics useful in tuning the shared pool.
Fields
The most relevant view fields are as follows:
FREE_SPACE
: The amount of free space on the reserved listUSED_SPACE
: The amount of used memory on the reserved listREQUESTS
: The number of times that the reserved list was searched for a free piece of memoryREQUEST_MISSES
: The number of times the reserved list did not have a free piece of memory to satisfy the request, and started flushing objects from the LRU listREQUEST_FAILURES
: The number of times that no memory was found to satisfy a request