Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 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.