We are evaluating LoadRunner (11.52 Patch1) for performance testing here at Croatia osiguranje d.d. and are having trouble replaying Oracle 2 tier scripts.
It seems that Correlation/Async studio isn't available for that protocol, and the approach suggested by the documentation (11.50 VuGen User Manual), i.e. using Snapshot Pane isn't very usable.
To illustrate the problem on a simple example, we have a SELECT statement on a sequence (for a primary key) prior to inserting new data. The actual retreival of the sequence value isn't recorded (no lrd_ora8_fetch call), and there is no data grid with the respective value in the Snapshot Pane (for manual correlation using GUI). However, the value is used for the next SQL statement (it's bound to a statement parameter). Of course, the script fails to replay due to unique constraint on the database.
We managed to correlate the script manually. This involved inserting lrd_ora8_bind_col, lrd_ora8_attr_set, lrd_ora8_save_col and lrd_ora8_fetch calls, and declaring additional variables in vdf.h (which by default isn't even visible in the Solution Explorer). While this proof-of-concept gives us hope, we feel that this should be much easier to accomplish in VuGen. Could we be doing something wrong?
We are using Oracle 11g database and the application is accessing the DB using 11g client.