Databases Reference
In-Depth Information
How it works...
In step 1, we connect to the database as
SYSDBA
. In step 2, we query the
V$LIBRARYCACHE
dynamic performance view to obtain details about the current use of Library Cache. You can
observe the output in the following screenshot:
In step 3, we calculate the Library Cache Hit Ratio, an important parameter to evaluate
the use of Library Cache—the result should be around 99.9 percent, as can be seen in
the following screenshot:
