Adding Oracle Counters to Windows Performance Monitor

  1. Open file <Oracle Home>\network\admin\tnsnames.ora and add the connection string to the database you want to monitor.
  2. Start the command line and test the connection with the command sqlplus <user>/<password>@<database>
  3. Configure which database is to be monitored using the operfcfg command: <Oracle Home>\bin\operfcfg [-U username] [-P password] [-D TNS_Alias_for_database]

    If successful, you will receive the message operfcfg: New registry values have been successfully set.

  4. Start Windows Performance Monitor Start > Run > Perfmon.
  5. Oracle Counters for Windows Performance Monitor can now be added via the Add Counters dialog box.
Parent topic: Oracle Database Monitoring Prerequisites