Databases Reference
In-Depth Information
In step 4, we have used the
SIZES
procedure of
DBMS_SHARED_POOL
to show objects that
are larger than the size given in the shared pool, as shown in the following screenshot:
In step 5, querying the
V$SHARED_POOL_RESERVED
dynamic performance view, we inspect
the statistics about the use of reserved space in the Shared Pool. Our goal is to minimize the
REQUEST_MISSES
and
REQUEST_FAILURES
, similar to the Library Cache. If the number of
failed requests is increasing, we need to expand the Reserved Pool (and probably also the
Shared Pool).
To size the Reserved Pool, we use the
SHARED_POOL_RESERVED_SIZE
initialization parameter. The value of this parameter cannot exceed 50
percent of the
SHARED_POOL_SIZE
parameter.