Adding Oracle Database sources

To capture resource monitoring data from Oracle Database, you must configure the data source.

Before you begin

Before you can capture resource monitoring data from Oracle Database, you must specify the path to the Oracle Database client file, ojdbc6.jar on the Oracle Database Client Preferences page. The Oracle Database client file is provided with Oracle Database, not with Test Performance. The version of the Oracle Database client file must match the version of Oracle Database that is running on the server under test.

Procedure

  1. On the Location page, specify the connection and authentication information for the server that runs Oracle Database. If you have to change the port that is used to communicate with the server, change the information in Connection. Typically, your Oracle Database system administrator specifies this information.
  2. In Database Name, type the name of the database to monitor.
  3. On the Resource page, select the type of data to capture. The tree view shows the counter groups and counters that are available from the application server. Be selective; monitoring all possible resource data requires substantial amounts of memory. Hold your mouse pointer over a counter to see details about what that counter measures.
  4. Configure the options on the Options page.
    1. In Polling Interval, specify in seconds the interval for collecting resource data. For example, if you accept the default setting of 5 seconds, counter information is collected at 5-second intervals from the specified host during the schedule run.
    2. In Timeout Interval, type a time value in seconds. If the resource monitoring host does not respond within this amount of time during a schedule run, an error is logged.
    3. Clear the Keep cursors open during runtime check box to allow database cursors to close while tests run. By default, Keep cursors open during runtime is selected, which prevents database cursors from being closed while tests run.
  5. Click the Cloud Options tab, and then select the Location In Public Cloud checkbox to collect the resource monitoring data for the system under test that is in the public cloud.
  6. Click Next.
  7. Enter a name for the location in the Name field, and then click Finish.