Oracle A423961 Manual Do Utilizador

4 – 3

Getting the Most out of Integration with Windows NT

   For more information on the

Performance Monitor, see your operating system
documentation.

   For more information on the meaning

of Windows NT Performance Monitor results, and what you can
do about your database performance, see Oracle7 Server Tuning
and your operating system documentation.

Performance Monitor objects are detailed below.

Memory Allocation Objects

The Library Cache object contains one counter, the reloads/pins
percentage counter.

This value is not time derived.

The reloads/pins is the percent of SQL statements, PL/SQL blocks and
object definitions which required re–parsing. This percentage should be
near ZERO. If the percentage is greater than 1%, then you should reduce
the library cache misses. See Reducing Library Cache Misses in Oracle7
Server Tuning.

The Data Dictionary Cache object contains one counter, the get
misses/gets percentage counter.

This value is not time derived.

For frequently accessed dictionary caches, the value of this counter
should be less than 10–15%. If the ratio continues to increase above this
threshold while your application is running, increase the amount of
memory available to the data dictionary cache. See Reducing Data
Dictionary Cache Misses in Oracle7 Server Tuning.

The Buffer Cache object contains one counter, the phyreads/gets
percentage counter.

This value is not time derived.

If the Miss counter is high (higher than 30% – 40%), increase the number
of buffers in the cache to improve performance. See Reducing  Buffer
Cache Misses in Oracle7 Server Tuning.