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 |
NUMBE |
Number of times that no memory was found to satisfy a request. If an internal flush (used to free up memory) does not meet a memory need, then the error ORA-04031 occurs.Foot 2 |
LAST_FAILURE_SIZE |
NUMBER |
Request size of the last failed request. If an internal flush (used to free up memory) does not meet a memory need, then the error ORA-04031 occurs.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.