V$SHARED_POOL_RESERVED

V$SHARED_POOL_RESERVED displays statistics that help you tune the reserved pool and space within the shared pool.

Column Datatype Description
FREE_SPACE NUMBER Total amount of free space on the reserved listFoot 1 
AVG_FREE_SIZE NUMBER Average size of the free memory on the reserved listFootref 1
FREE_COUNT NUMBER Number of free pieces of memory on the reserved listFootref 1
MAX_FREE_SIZE NUMBER Size of the largest free piece of memory on the reserved listFootref 1
USED_SPACE NUMBER Total amount of used memory on the reserved listFootref 1
AVG_USED_SIZE NUMBER Average size of the used memory on the reserved listFootref 1
USED_COUNT NUMBER Number of used pieces of memory on the reserved listFootref 1
MAX_USED_SIZE NUMBER Size of the largest used piece of memory on the reserved listFootref 1
REQUESTS NUMBER Number of times that the reserved list was searched for a free piece of memoryFootref 1
REQUEST_MISSES NUMBER 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 listFootref 1
LAST_MISS_SIZE NUMBER Request size of the last request miss, when the reserved list did not have a free piece of memory to satisfy the request and started flushing objects from the LRU listFootref 1
MAX_MISS_SIZE NUMBER Request size of the largest request miss, when the reserved list did not have a free piece of memory to satisfy the request and started flushing objects from the LRU listFootref 1
REQUEST_FAILURES NUMBER 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 
LAST_FAILURE_SIZE NUMBER Request size of the last failed request (that is, the request size for the last ORA-04031 error)Footref 2
ABORTED_REQUEST_THRESHOLD NUMBER Minimum size of a request which signals an ORA-04031 error without flushing objectsFootref 2
ABORTED_REQUESTS NUMBER Number of requests that signalled an ORA-04031 error without flushing objectsFootref 2
LAST_ABORTED_SIZE NUMBER Last size of the request that returned an ORA-04031 error without flushing objects from the LRU listFootref 2

Footnote 1 These columns are valid only if the initialization parameter SHARED_POOL_RESERVED_SIZE is set to a valid value.

Footnote 2 These columns contain values which are valid even if SHARED_POOL_RESERVED_SIZE is not set.