V$SHARED_POOL_RESERVED
This view displays statistics useful in tuning the shared pool.
Fields
The most relevant view fields are as follows:
FREE_SPACE
: The amount of free space on the reserved listUSED_SPACE
: The amount of used memory on the reserved listREQUESTS
: The number of times that the reserved list was searched for a free piece of memoryREQUEST_MISSES
: The 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 listREQUEST_FAILURES
: The number of times that no memory was found to satisfy a request
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.