Use the Profile Repositories preferences to register and unregister supported version of Oracle data sources as profiling repositories. A data source must be added to the list of DB Optimizer Managed Data Sources before it can be used as a repository.
To access the Profile Repositories Preferences
Select Preferences > Profile Repositories.
Register a profile repository
To register a new profile repository
- In the Profile Repositories Preferences dialog, click Register. The Register a data source as a repository dialog appears and displays the managed data sources that may be used.
- Select the data source you want to register as a profile repository, and then click OK.
- Click OK again.
A data source registered as a profile repository appears in the Profiling Repositories node of the Data Source Explorer and also has a Profile Repository child node in under its entry in the Managed Data Sources folder. Profiling sessions are saved in the repository under a name that is comprised of the date, time, and duration of the profiling session.
When you next choose to profile a data source, using the Profile As > Profiling Configurations option, you can specify the profile repository in which you want to save the profiling session data. You can also access the Profile Repository Preferences from this dialog.
Unregister a profiling repository
To unregister a profiling repository
In the Profile Repositories Preferences dialog, select a profile repository from the list, and then click Unregister. Unregistering a data source prompts you to optionally delete all sessions on the repository.
If you choose not to delete the profiling sessions, they will still be available from either the Profiling Repository node in the data source entry in Managed Data Sources or from the Profiling Repositories node. You will not be able to save profiling sessions to the unregistered repository until you register it.