SQL Optimizer can retrieve trace statistics each time you execute a SQL statement in Optimize SQL or Optimize Indexes. The Oracle SQL tracing function writes the statistics to a log file on the server. You must set up the file access method for retrieving the statistics from the log file before viewing this information.
Notes:
Your user account must have ALTER SESSION privileges to enable the trace function in Oracle.
To set trace setup options
Click in the main menu.
Select General | Trace Setup.
Review the following for additional information:
Trace Setup Options |
Description |
Select database connection for Oracle trace log |
Click to select a connection for the trace setup. Tip: Click to open the Connection Manager to create a new connection. See Connect to the Database for more information. |
Access Method |
Description |
Select the access method |
Select one of the following:
|
To set execution plan options
Click in the main menu.
Select General | Execution Plan.
Specify options for the display of execution plans. Review the following for additional information:
TABLE ACCESS FULL warning threshold | Specify a table size threshold at which the TABLE ACCESS FULL operation is highlighted in red. |
Color |
Select the color for individual items in the execution plan. |
Font | Select the font settings fthe individual items in the execution plan. |
Note: The execution plan displays in several panes. Use this page to specify color and font options to apply globally to all Execution Plan panes. To customize display options for individual panes, right-click the execution plan and select Plan Options . |
To set test for scalability options
Click in the main menu.
Select General | Test for Scalability.
Review the following for additional information:
Minimum number of virtual users |
Enter the minimum number of virtual users to use for scalability testing. Range: 1 to 1,000,000,000 |
Maximum number of virtual users |
Enter the maximum number of virtual users to use for scalability testing. Range: 1 to 1,000,000,000 |
Step value of virtual users |
Enter the number of virtual users to increase by for each step of scalability testing. Range: 1 to 1,000,000,000 |
Distribution Model |
Select a latency think time distribution model:
|
Duration (milliseconds) |
Enter a duration in milliseconds. Note: How SQL Optimizer uses the value you enter depends on the distribution model selected. |
Execute Each SQL Statement by |
Select one of the following:
|
To set directory setup options
Click in the main menu.
Select General | Directory Setup.
Specify data directory location or locations. Review the following for additional information:
Group / Option | Description |
---|---|
Application Data Directory |
Select a location for the SQL Optimizer application data directory which stores connection profiles, layout files, log files, and other data. Use this area to store all data directories in one location. Each module's data files are grouped by sub-directory. Note: The default location is in the user's Roaming directory. Use default—Resets the location to the primary default location, which is in the user's Roaming directory. Use local default—Sets the location to the optional default location, which is in the user's Local directory. Note: If you change the location of the application data directory, you must restart SQL Optimizer for the change to take effect. |
Data Directories |
Use this area to specify data directory locations for each module, individually. Note: Click Show Details to display the options. Use Application Data Directory—Select this option to use the location specified above under Application Data Directory. After selecting this option, the text boxes for individual data directories are disabled. |
Optimize SQL data directory |
Select the directory to store data files created using Optimize SQL. Default: C:\Users\<user>\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle\<version>\Optimize SQL Data\ |
Batch Optimize SQL data directory |
Select the directory to store data files created using Batch Optimize SQL. Default: C:\Users\<user>\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle\<version>\Batch Optimize SQL Data |
Scan SQL data directory |
Select the directory to store data files created using Scan SQL. Default: C:\Users\<user>\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle\<version>\Scan SQL Data |
Inspect SGA data directory |
Select the directory to store data files created using Inspect SGA. Default: C:\Users\<user>\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle\<version>\Inspect SGA Data |
Analyze Impact data directory |
Select the directory to store data files created using Analyze Impact. Default: C:\Users\<user>\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle\<version>\Analyze Impact Data |
Optimize Indexes data directory |
Select the directory to store data files created using Optimize Indexes. Default: C:\Users\<user>\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle\<version>\Optimize Indexes Data |
Note:
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center