A profiling session can be saved to a file with a .oar suffix that contains the name of the data source. When profiling Oracle data sources, you can alternatively save the session data to the Profiling Repository. This enables you to open the file at a later time for analysis.

Save a Profiling Session as a .OAR File

To save a profiling session as a .OAR file

  1. Select the profiling session and then choose File > Save As.
  2. Specify the project location where you want to save the file, and then modify the file name as needed.
  3. Click OK. The project is added to SQL Project Explorer.

Once you save a profiling session, it appears in the SQL Project Explorer under the name you saved it as. It can be opened again by double-clicking the project name.

Saving a Profiling Session in the Profiling Repository

You can also have the session saved automatically as a Profiling Repository file in an Oracle data source. This allows you to profile your data source for a longer period of time, for days or even weeks.

  1. Right-click the data source you want to profile and select Profile As > Profile Configurations.
  2. In the Profile Configurations dialog, select Save to data source, and then select the data source where you want to save the profile sessions.

The saved session file, named using the date and time when the profiling session was stopped, can be viewed from the Data Source Explorer and thus available to share with other DB Optimizer users.