Monitoring Oracle Performance (Perfmon)

  1. Choose Monitor > Add Data Source. The Data Source wizard opens.
  2. Click the Select from predefined Data Sources option button.
  3. Click Next. The System selection page opens.
  4. Expand the Database System folder and the Oracle 9/10/11 (perfmon) folder.
  5. Click the System Statistics ( PERFMON ) node and then click Next. The Connection Parameters page opens.
  6. In the Hostname text box, specify the host on which the Oracle Client and Counters for Windows Performance Monitor are running.
  7. In the User and Password text box, specify the user with administrator permissions on the above specified host.
  8. Optional: In the Alias text box, specify an alias for the host where the Oracle database is running.
  9. Click Next.
  10. The Select displayed measures page opens.
  11. Check the check boxes for those measures that you want to include in the initial monitor view and then click Finish.