Toad World® Forums

Batch Optimize SQL


#1
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