|
Column |
Description |
|
SQL_ADDRESS |
Address to identify the associated
SQL statement |
|
SQL_HASH_VALUE |
Hash Value to identify the
associated SQL statement |
|
SQL_ID |
SQL identifier of the associated
statement |
|
QCSID |
Session identifier for parallel
coordinator |
Table 7.1 -
v$session_longops view
To view the results of the task execution,
use the report_tuning_task_function:
SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK(
‘dba_tuning_task_v1’) FROM DUAL;
This report contains all the results and
recommendations of the automatic SQL tuning. For each proposed
recommendation,
the rationale and advantages
can be found, along with the SQL commands
needed to implement the changes.
