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
Rational® Performance Tester. The version of the Oracle Database client file must match
the version of Oracle Database that is running on the server under
test.
Procedure
- 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.
- In Database Name, type the name
of the database to monitor.
- 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.
- Configure the options on the Options page.
- 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.
- In Timeout Interval, specify
in seconds the time to wait for a response. If the resource monitoring
host does not respond within this amount of time during a schedule
run, an error is logged.
- 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.
- To collect the resource monitoring data for the system under test that is in the cloud, in the
Cloud Options tab, click the Location in Public Cloud
check box.
- Click Next.
- Specify a location and name and click Finish.