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 list
`AVG_FREE_SIZE`	`NUMBER`	Average size of the free memory on the reserved list¹
`FREE_COUNT`	`NUMBER`	Number of free pieces of memory on the reserved list¹
`MAX_FREE_SIZE`	`NUMBER`	Size of the largest free piece of memory on the reserved list¹
`USED_SPACE`	`NUMBER`	Total amount of used memory on the reserved list¹
`AVG_USED_SIZE`	`NUMBER`	Average size of the used memory on the reserved list¹
`USED_COUNT`	`NUMBER`	Number of used pieces of memory on the reserved list¹
`MAX_USED_SIZE`	`NUMBER`	Size of the largest used piece of memory on the reserved list¹
`REQUESTS`	`NUMBER`	Number of times that the reserved list was searched for a free piece of memory¹
`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 list¹
`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 list¹
`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 list¹
`REQUEST_FAILURES`	`NUMBER`	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.
`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.²
`ABORTED_REQUEST_THRESHOLD`	`NUMBER`	Minimum size of a request which signals an `ORA-04031` error without flushing objects²
`ABORTED_REQUESTS`	`NUMBER`	Number of requests that signalled an `ORA-04031` error without flushing objects²
`LAST_ABORTED_SIZE`	`NUMBER`	Last size of the request that returned an `ORA-04031` error without flushing objects from the LRU list²
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

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

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