Connection Page
Description
Connection
Click to select a previously created database connection.
Tips:
Click to open the Connection Manager to create a new connection.
You can select an alternative connection for executing the SQL statement alternatives Batch Optimize generates.
Database Objects Page
Description
Database objects
Select a schema, database object type, or individual database object, and then click to add the object.
Tip:
Click to browse for database objects.
Your database privileges determine if you can scan all selected database objects.
Execute using schema
Click and select an alternative schema for executing the SQL statement alternatives.
Source Code Page
Description
Source code type
Select Text/Binary files, Oracle SQL *Plus Script, or COBOL programming source code to indicate the source code type for the file or directory you want to scan.
Add by file
Click and browse to the files you want to add.
Add by directory
Click and browse to the directories you want to add.
Note: Select the Include Sub-directory checkbox to scan sub-directories.
Scan using schema
Click and select a schema to scan.
Execute using schema
Click and select an alternative schema for executing the SQL statement alternatives.
SQL Text Page
Description
SQL text
Enter SQL statement text.
Scan using schema
Click and select a schema to scan.
Execute using schema
Click and select an alternative schema for executing the SQL statement alternatives.
Scan SQL Page
Description
Group
Select the Scanner group that contains the SQL statements you want to scan.
Scan using schema
Click and select a schema to scan.
Execute using schema
Click and select an alternative schema for executing the SQL statement alternatives.
Inspect SGA Page
Description
Group
Select the Inspector group that contains the SQL statements you want to scan.
Scan using schema
Click and select a schema to scan.
Execute using schema
Click and select an alternative schema for executing the SQL statement alternatives.
Foglight Performance Analysis for Oracle Page
Description
Select a database to search for the repository used to store captured SQL
Click to select a previously created database connection, and then click Check for PA Repository to locate the repository.
Tip: Click to open the Connection Manager to create a new connection.
Note: Batch Optimize helps you manage jobs by organizing them into batches. Use the Batch Info page to create a new batch or to add the current job to an existing batch.
This is a companion discussion topic for the original entry at https://blog.toadworld.com/batch-optimize-sql