Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In Data Source Explorer, right click on the data source you want to profile and select Profile As from the menu, and then choose Data Source 1.
  2. In the Profile Configurations dialog, select the configuration to use for this profiling session. If you haven’t already created a profile, see Building Profiling Configurationsprofiling configurations for a description of the profiling configuration options you can choose.
    The profiling session begins. Alternatively, clicking the Profiling icon on the Toolbar automatically runs a profiling session for the last data source you selected.
    Once a profiling session launches, it runs until you stop it. When a session has run for a length of time, you can then interpret and analyze the results. See Working with Session Resultssession results.

To stop a profiling session

You can stop a profiling session at any time by clicking the Stop button [] in the upper left-hand side of the Profile Session screen of by clicking the Stop button in the Progress Window.

Executing a

...

session from the Command Line

Info

This is not supported when using SQL Query Tuner DB Optimizer InstantOn.

You can launch a profiling session from the command line using the following syntax:

...

In the above command, the user has specified ROM*L*ABORCL10G_1 as the data source, and indicates a profiling session of 20 minutes. The tofile variable specifies the directory and name of the file to which the profiling session will be saved.


Scroll pdf ignore
Automate SQL tuning and profiling with DB Optimizer. Learn more > >