Databases Reference
In-Depth Information
See also
F
The
V$SGAINFO
section in this appendix
V$SGAINFO
This view displays detailed information about the SGA components.
Fields
The most relevant view fields are as follows:
F
NAME
: The name of the SGA component
F
BYTES
: The size in bytes
F
RESIZEABLE
: This indicates whether the component is resizable (
YES
) or not (
NO
)
See also
The
V$SGA
section in this appendix
V$SHARED_POOL_RESERVED
This view displays statistics useful in tuning the shared pool.
Fields
The most relevant view fields are as follows:
F
FREE_SPACE
: The amount of free space on the reserved list
F
USED_SPACE
: The amount of used memory on the reserved list
F
REQUESTS
: The number of times that the reserved list was searched
for a free piece of memory
F
REQUEST_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 list
F
REQUEST_FAILURES
: The number of times that no memory was found to satisfy
a request