For effective load testing, it is recommended that parameterized input data be assigned to SQL statements so that values are submitted each time database tests are run. Otherwise, identical recorded input parameter values will be sent with each test run, which is not a realistic simulation of real-world user activity. TrueLog Explorer enables you to visually generate code in your test scripts that substitutes recorded input parameter values with customized input parameters.
You can use Customer OCI, the sample database application, to experiment with the customization of user-input data. Scripts that replay simple recorded business transactions can be customized with variables that input randomized data into otherwise constant data fields. Input-data values may be constant values, random values, or values drawn from preconfigured data files, such as CSV files.