This Tool/Procedure	Enables You To...
Performance Monitor	Monitor and optimize database performance.
Event Viewer	Display warnings and errors about database functionality.
Trace Files	Record occurrences and exceptions of database operations.
Alert Files	Record important messages about error messages and exceptions during database operations.
Error Message Logging	Redirect Oracle7 Utility error messages to a file.

If Using...	Then...
Windows NT 3.51	Choose the Performance Monitor icon from the Accessories Group in Program Manager.
Windows NT 4.0	Go to Start->Programs->Administrative Tools (Common)-> Performance Monitor.

Follow these procedures to access the Performance Monitor.

Object	Counter	Description
Oracle7 Library Cache	Reloads/Pins %	The percentage of SQL statements, PL/SQL blocks, and object definitions that required re-parsing. Total Reloads must be near 0. If the ratio of Reloads to Pins is greater than 1%, then reduce the library cache misses. This value is not time-derived.
Oracle7 Data Dictionary Cache	Get Misses/Gets %	The value of this counter must be less than 10 or 15% for frequently accessed data dictionary caches. 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. This value is not time-derived.
Oracle7 Redo Log Buffer	Redo Log Space Request	The value of this counter must be near 0. If this value increments consistently, processes have had to wait for space in the redo log buffer. In this case, it may be necessary to increase the size of the redo log buffer.
Oracle7 Buffer Cache	Phyrds/Gets %	The percentage of Phyrds/Gets is calculated as a Miss ratio. If the Miss counter is higher than 30% to 40%, increase the number of buffers in the buffer cache to improve performance. To make the buffer cache larger, increase the value of the DB_BLOCK_BUFFERS initialization parameter. This value is not time-derived.
Oracle7 Data Files	Phyrds/Sec Phywrts/Sec	Disk contention occurs when multiple processes try to access the same disk simultaneously. There are many ways of reducing disk contention, depending on the results from monitoring disk activity. Some corrective actions include: distributing I/O separating data files and redo log files separating tables and indexes striping table data These values are time-derived.
Oracle7 Dynamic Space Management	Recursive/Calls Per Second	Dynamic extension causes Oracle7 to execute SQL statements in addition to those SQL statements issued by user processes. These SQL statements are called recursive calls. If Oracle7 makes excessive recursive calls while an application is running, it may be necessary to determine the cause. Examine the recursive calls statistic through the dynamic performance table V$SYSSTAT.
Oracle7 Tuning Sorts	Sorts in Memory/Sec Sorts on Disk/Sec	The default sort area size is adequate to hold all the data for most sorts. However, if your application often performs large sorts on data that does not fit into the sort area, then you may want to increase the sort area size.
Oracle7 Free Lists	FreelistWaits/ Requests %	Contention for free lists is reflected by contention for free data blocks in the buffer cache. You can determine if contention for free lists is reducing performance by querying V$WAITSTAT. If the number of freelist waits for free blocks is greater than 1% of the total number of requests, consider adding more free lists to reduce contention.

.

Modifying Values

Using Event Viewer

Trace Files