Databases Reference
In-Depth Information
In step 8, we query and alter the size of the
KEEP
and
RECYCLE
buffer pools, setting them
both to 16 Megabytes. The following screenshot shows the corresponding output:
In step 9 and step 10, we query the size, expressed in database blocks, of the
CUSTOMERS
table in the
SH
schema and of two indexes,
CUSTOMERS_YOB_BIX
and
CUSTOMERS_PK
, to
be sure that they can be stored inside the
KEEP
Buffer Cache.
In step 11, we move the objects queried earlier to the
KEEP
Buffer Cache. In the following
screenshot, we can see the output of these executions: