Setting Up PersonPB

Once you have successfully installed Silk Performer, the PersonPB application is located in the SampleApp subdirectory. For more details on how to install Silk Performer, refer to the installation help.

The PersonPB application provides a number of settings to specify the application behavior. Since these settings affect the SQL statements rather than the user interface, you need to record the database traffic using the Silk Performer API Recorder for the differences to become visible.

To set up the application parameters:

From the PersonPB menu bar, click File > Parameter.
Specify the Static Bind setting. If this option is checked, each select-list item is defined separately. Otherwise, all select-list items are described using a single operation.
Specify the Disable Bind setting. If this option is checked, parameters within SQL statements are replaced with constants rather than being bound to the corresponding program variables.
Enter the number of Rows to fetch per iteration. Only the specified number of rows is available after a fetch operation.
Specify the SQL cache size. This setting determines the maximum number of database cursors used by the application.
Click OK to save your changes.
In the Customer OCI window, select either the Serializable option or the Read Committed option. See the Oracle documentation for an exact isolation level description. The isolation level determines how transactions modifying the database are handled.
Note: To replay a test script using multiple virtual users, the isolation level of the traffic-generating application has to be set to Read Committed.