Welcome to the World of Query Tuning

Instructions to download and generate tuning data

Download the utility using below Link. (It is a .sql file)
Connect to your Oracle Database using any user that has privilege to read the data dictionary views.
Run the Utility at SQL prompt.
Pass the SQL ID for the query required to tune when prompted.
Utility generates .LST output file in the directory from where SQL*Plus utility connected.
Upon successful generation of Output file please follow below Upload process.

Platform	Download	Remarks
Oracle	Download	Please do not make any modification to Utility and output file to avoid errors.

Instructions to upload and generate the tuning suggestions

Output file generated using Query Tuning Utility, please upload here
Upon successful upload query, site will automatically starts tuning analysis and provide the analysis and suggestions.

Please follow below instructions and proceed to download Utility file (.sql) using download button.

Please provide the Unique Identifier for the query text you wanted to tune.
Please do not give same identifier for more than one query text.
Please provide the SQL Text and follow below instructions:
- Please ensure that SCHEMA prefix you provided for every table
- If you are using different schema, please ensure that you have SELECT privilege on tables you are using in the query.
Upon providing the Unique identifier and SQL Text, click on below Download Utility File button to download Utility File generated by the tool only for the given query.
Connect to your database and run the downloaded Utility file and it will generate an output file.
Once the output file generated successfully proceed to upload the file for tuning analysis.

Instructions to upload and generate the tuning suggestions

Output file generated using Query Tuning Utility, please upload here
Upon successful upload query, site will automatically starts tuning analysis and provide the analysis and suggestions.

DBAce Technologies