Benchmark Factory allows you to specify statistics collection options for each Oracle connection.
To specify statistics collection options for an Oracle connection
AWR and ADDM Options—Collect database-wide performance statistics using the optional Oracle Enterprise Manager (OEM) “Diagnostic Pack” Automatic Workload Repository (AWR).
Note: A valid licenses is required to use the optional OEM Diagnostics Pack.
Tip: You can specify default values for Oracle performance collection and reporting options in Edit | Settings | Oracle.
Clustering is the process of using two or more computer systems that work together. Multiple servers are linked to handle variable workloads or to provide continued operation in the event one fails. Computers may be multiprocessor systems. A cluster of four computers with four CPUs each provides a total of sixteen CPUs processing at one time.
Use the Clustering tab in the Connection dialog of an Oracle connection to enable clustering. This allows you to perform Oracle Real Application (RAC) Testing.
To enable clustering for an Oracle connection
Oracle uses clustering to allow one database to span multiple resources. Benchmark Factory can simulate user activity on these systems.
Performing Oracle RAC testing in Benchmark Factory requires the following steps:
The remaining Net Service Names must be named with the root and a number. In this example, MyTNS is the root and MyTNS1, MyTNS2, and MyTNS3 will be used when the test is run. The "MyTNS" and "MyTNS1" connections are duplicates and are required for Benchmark Factory to perform load testing. “MyTNS2” and “MyTNS3” are for the other two machines in the cluster.
The following provides an example of a tnsnames.ora file set up for a three node cluster.
Enter the connection information. See Create Oracle Connection for more information.
Note: The Net Service Name reflects the same entry as the first entry in the tnsnames.ora file.