Prerequisites for Oracle Monitoring

Before you monitor Oracle, ensure that the following requirements have been met:
  • Oracle Net (part of Oracle Net Services) client software is installed on the machine on which you run Performance Explorer.
  • The Oracle client must be a 32-bit version, must have DB administrator permissions and be able to recognize the targeted database server.
  • The relevant project attributes have been changed accordingly for your Oracle installation (choose Menu Project > Project Attributes ).
  • SQL*Plus is available on the machine on which you want to run Performance Explorer.
  • Log on using the specified user name, password, and server information and perform the query SELECT * FROM V$SYSSTAT.

    If the logon attempt is successful, the environment is most likely set up correctly.

    If the logon attempt fails, you can judge from the error messages generated by SQL*Plus what caused the problem.

Parent topic: Monitoring Oracle Database via V$SYSSTAT