Databases Reference
In-Depth Information
In the following screenshot, you can observe the results obtained on our test database:
In step 6, we query the
V$ROWCACHE
dynamic performance view to obtain Dictionary Cache
statistics, also calculating the Hit Ratio.
In the following screenshot, you can observe the output: