Here we will discuss about the procedure of monitoring oracle using windows perfmon.By using perfmon, you can collect Oracle data as well as OS data that might be important to your overall performance monitoring plan. By consolidating your data collection, you will find it easier to analyze data.
The Oracle Counters for Windows Performance Monitor package is not installed by default. In order to install them when you install Oracle, select the custom install option. You can also install this option later via the Oracle installer. Select custom installation and select the Oracle for Windows Performance option under Oracle Windows Interfaces. This will install this package.
Once Oracle Counters has been installed into the Windows Perfmon, you must perform one more piece of setup. The Oracle performance counters are set up to monitor one Oracle instance. Information about this instance must be configured in the registry. In order to do this, from a command prompt run orafcfg.exe with a username, password and Oracle net service name as follows:
operfcfg –U system –P password –D orcl
This will update the registry. You should now be able to monitor Oracle via perfmon. Some of the things that you can monitor are:
* The Oracle Buffer Cache. Here you can see the cache miss ratio.
* Shared Pool Stats. This collection includes the data dictionary cache, and the library cache.
Log Buffer. Provides information on log space requests.
* Database Data Files. This object provides physical read and write per second counters.
* DBWR stats. Provides information on the DB Writer processes.
* Miscellaneous. Other statistics include dynamic space management, free lists and dynamic sorts.
No comments:
Post a Comment