👤
vector

Download SQL ID Based Query Tune Utility

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.

Upload Query Tune Utility Output file

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.
Upload Query Tuning Output File here

Download SQL Text Based Query Tune Utility

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.





Upload Query Tune Utility Output file

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.
Upload Query Tuning Output File here
Analysis


Tuning Suggestions


Download Detailed Report


Analysis


Tuning Suggestions


Download Detailed Report


Platform Download Remarks
Tuning Suggestion Download This file contains tuning suggestion data. Do not modify the contents.
*** Upon successful upload of output file, analysis and suggestions will display below:
Tuning Suggestions for SQL ID:
SQL TEXT

Plan Hash Value:

EXECUTION PLAN
TABLE STATISTICS
INDEX STATISTICS
COLUMN STATISTICS
QUERY ANALYSIS
    TUNING SUGGESTIONS

      A Product By

      DBAce Technologies

      ..
      QR Code