Online Documentation for SQL Manager for Oracle

Defining execution plan

At this step of the wizard you should indicate whether execution plan should be generated.


RadioButton Don't use the EXPLAIN PLAN statement

Use this option if you don't need to generate execution plan.


Decide whether utility should RadioButton Connect to the registered database or to the RadioButton unregistered database.


For the unregistered database you need to define connection parameters: User/Password, Database name and Connection type.


TKProf Wizard - Defining explain plan


CheckBox Explain to

Use this option to insert execution plan data to a table. If the option is disabled the utility generates a file with the data.



Defines schema that contains table where the execution plan data should be inserted.



Defines name of the existing table to insert execution plan into.


Press the Next button to proceed to the Specifying additional options step of the wizard.