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.
To save a profiling session as a .OAR file
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.
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.
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.