Automatic SQL Tuning in Oracle Database(五)
PX SEND HASH | :TQ10001 | 10M| 124M| | 1272 (0)| 71:55:35 | Q1,01 | P->P | HASH |
| 12 | PX BLOCK ITERATOR | | 10M| 124M| | 1272 (0)| 71:55:35 | Q1,01 | PCWC | |
| 13 | TABLE ACCESS FULL| T | 10M| 124M| | 1272 (0)| 71:55:35 | Q1,01 | PCWP | |
--------------------------------------------------------------------------------
-
------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
5 - access("T"."OBJECT_ID"="T1"."OBJECT_ID")
-------------------------------------------------------------------------------
5.删除任务
EXEC DBMS_SQLTUNE.DROP_TUNING_TASK('tuning_sql_test');