You can create an SQL TUNING TASK manually adhoc with the following simple steps.

Step1: Find the sql_id of the oracle session you would like to analyze. Usually the AWR has the top sql_ids.
In case this is a current sql running use the v$session.

Step2: Login as SYSTEM (or any other user) at sqlplus and create the tuning task:

Step3: Run the SQL TUNING TASK

Step4: You can monitor the processing of the tuning task with the statement

Step5: When the task has a status=COMPLETED, then run:

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.