This chapter describes the how to work with Oracle Load Testing session data. The following session actions are available:
Attach to and detach from sessions that are running on the Oracle Load Testing server. This enables a tester to share real-time test results and to collaborate with team members during testing.
Export specific session data from and import session data to any Oracle Load Testing instance. This enable users to share session data stored on one instance of Oracle Load Testing with other users running another instance of Oracle Load testing without having to export and import an entire Oracle Load Testing database. The user importing the session data can then generate reports for the data using their own Oracle Load Testing instance.
The Session options lets you rename sessions, delete sessions, purge VU logs, and import/export session data.
To use sessions options:
Select Options from the User menu.
Expand Options and select Sessions in the Manage group.
This dialog box lets you manage session data in the database.
Edit - displays the Edit Session dialog box for changing the name and status of the session.
Delete - deletes the entire selected session data from the database. To select more than one session hold down the CTRL key.
Purge VU Logs - deletes the Virtual User logs for the selected session. To select more than one session hold down the CTRL key.
Import - opens a dialog box for selecting the session archive (.osd) file to upload.
Export - saves the selected session to an archive (.osd) file.
Refresh - refreshes the session list from the database.
Session - the names of the virtual user sessions run by Oracle Load Testing. Oracle Load Testing lets you specify a name for the session data when you start the session to play back virtual users.
Start Time - shows the date and time of day the virtual user session was started.
End Time - shows the date and time of day the virtual user session ended.
Status - shows the status of the session. One of the following status entries may appear:
end of session - the session data was stored to the database successfully.
start of session - the session database is currently being accessed by an Oracle Load Testing session.
saving data - session data is being saved.
Result - shows the result for this session: No result|Passed|Failed.
Logs - indicates whether VU log data was saved for this session.
Select the session you want to manage.
Click an option on the toolbar to manage the session.
When editing a session, change the Name, Status, and Result settings as needed.
.Click OK.
You can export Oracle Load Testing session data to an external file which can than be imported into another instance of Oracle Load Testing installed elsewhere.
To export Oracle Load Testing session data:
Select Options from the User menu.
Expand Options and select Sessions in the Manage group.
Select the session to export and click Export.
Click Save when the File Download dialog box appears.
Specify the location and file name and click Save.
The default name of the file is the same as the session name. The filename can be changed to any other name. The data is not affected.
The exported file has a .osd (OLT Session Data) file extension. The file is in .zip compression format. You can change the extension to .zip and open the file in any ZIP utility to access the raw data. However, the file extension must be .osd to import the file into another Oracle Load Testing instance. The file structure is as follows:
Session Data\
db\
sessionRun.csv
scenarioReports.csv
counterHDR.csv
counterRun.csv
awrInfo.csv
vulog.csv
metadata.csv
All the Database related data is stored in /Session Data/db/. The db folder contains comma-separated-value (.csv) files which represent corresponding tables and their session related data in the database. Each .csv file contains the column names as their first row and the values on subsequent lines. All the .csv files are encoded in UTF-8 format.
You can import Oracle Load Testing session data that has been previously exported from another Oracle Load Testing instance as an Oracle Session Data (.osd) file.
To import Oracle Load Testing session data:
Select Options from the User menu.
Expand Options and select Sessions in the Manage group.
Click Import.
Click Browse.
Select the session .osd file and click Open.
Click Upload. The imported session will now appear in the Session Lists of the current Oracle Load Testing instance.
Click the Reports tab and select the imported session name to generate reports from the session data.