Dynamic Performance (V$) Views, 147 of 179

V$SHARED_POOL_RESERVED

This fixed view lists statistics that help you tune the reserved pool and space within the shared pool.

Column Datatype Description

The following columns of V$SHARED_POOL_RESERVED are valid only if the initialization parameter shared_pool_reserved_size is set to a valid value.
See Also: "SHARED_POOL_RESERVED_SIZE".

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

The following columns of V$SHARED_POOL_RESERVED contain values which are valid even if shared_pool_reserved_size is not set.

REQUEST_FAILURES

NUMBER

Number of times that no memory was found to satisfy a request (that is, the number of times the error ORA-4031 occurred)

LAST_FAILURE_SIZE

NUMBER

Request size of the last failed request (that is, the request size for the last ORA-4031 error)

ABORTED_REQUEST _THRESHOLD

NUMBER

Minimum size of a request which signals an ORA-4031 error without flushing objects

ABORTED_REQUESTS

NUMBER

Number of requests that signalled an ORA-4031 error without flushing objects

LAST_ABORTED_SIZE

NUMBER

Last size of the request that returned an ORA-4031 error without flushing objects from the LRU list

Column	Datatype	Description
The following columns of V$SHARED_POOL_RESERVED are valid only if the initialization parameter shared_pool_reserved_size is set to a valid value. See Also: "SHARED_POOL_RESERVED_SIZE".
`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
The following columns of V$SHARED_POOL_RESERVED contain values which are valid even if shared_pool_reserved_size is not set.
`REQUEST_FAILURES`	`NUMBER`	Number of times that no memory was found to satisfy a request (that is, the number of times the error ORA-4031 occurred)
`LAST_FAILURE_SIZE`	`NUMBER`	Request size of the last failed request (that is, the request size for the last ORA-4031 error)
`ABORTED_REQUEST _THRESHOLD`	`NUMBER`	Minimum size of a request which signals an ORA-4031 error without flushing objects
`ABORTED_REQUESTS`	`NUMBER`	Number of requests that signalled an ORA-4031 error without flushing objects
`LAST_ABORTED_SIZE`	`NUMBER`	Last size of the request that returned an ORA-4031 error without flushing objects from the LRU list