9.40 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 |
---|---|---|
|
|
Total amount of free space on the reserved list in bytesFoot 1 |
|
|
Average size of the free memory on the reserved list in bytesFootref 1 |
|
|
Number of free pieces of memory on the reserved listFootref 1 |
|
|
Size of the largest free piece of memory on the reserved list in bytesFootref 1 |
|
|
Total amount of used memory on the reserved list in bytesFootref 1 |
|
|
Average size of the used memory on the reserved list in bytesFootref 1 |
|
|
Number of used pieces of memory on the reserved listFootref 1 |
|
|
Size of the largest used piece of memory on the reserved list in bytesFootref 1 |
|
|
Number of times that the reserved list was searched for a free piece of memoryFootref 1 |
|
|
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 |
|
|
Request size of the last request miss in bytes, 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 size of the largest request miss in bytes, 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 |
|
|
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 |
|
|
Request size of the last failed request in bytes. If an internal flush (used to free up memory) does not meet a memory need, then the error |
|
|
Minimum size of a request in bytes which signals an |
|
|
Number of requests that signalled an |
|
|
Last size of the request in bytes that returned an |
|
|
The ID of the container to which the data pertains. Possible values include:
|
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.