Create an Oracle SQL TUNING TASK with DBMS_SQLTUNE

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. select sql_id from v$session where sid = 😡 Step2: Login […]

Read More