Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- GENERAL INFORMATION SECTION
- -------------------------------------------------------------------------------
- Tuning Task Name : UFOS_REF__5puz6u3a9ynn8
- Tuning Task Owner : UFOS_REF
- Workload Type : Single SQL Statement
- Scope : COMPREHENSIVE
- Time Limit(seconds): 1800
- Completion Status : COMPLETED
- Started at : 01/16/2017 16:00:17
- Completed at : 01/16/2017 16:00:34
- -------------------------------------------------------------------------------
- Schema Name: UFOS_REF
- SQL ID : 5puz6u3a9ynn8
- SQL Text : delete from FS_HEADCHANGES_LIST where fieldSetId=:1
- Bind Variables :
- 1 - (NUMBER):1056390667
- -------------------------------------------------------------------------------
- FINDINGS SECTION (1 finding)
- -------------------------------------------------------------------------------
- 1- SQL Profile Finding (see explain plans section below)
- --------------------------------------------------------
- A potentially better execution plan was found for this statement.
- Recommendation (estimated benefit: 99.98%)
- ------------------------------------------
- - Consider accepting the recommended SQL profile. The SQL plan baseline
- corresponding to the plan with the SQL profile will also be updated to an
- accepted plan.
- execute dbms_sqltune.accept_sql_profile(task_name =>
- 'UFOS_REF__5puz6u3a9ynn8', task_owner => 'UFOS_REF', replace =>
- TRUE);
- Validation results
- ------------------
- The SQL profile was tested by executing both its plan and the original plan
- and measuring their respective execution statistics. A plan may have been
- only partially executed if the other could be run to completion in less time.
- Original Plan With SQL Profile % Improved
- ------------- ---------------- ----------
- Completion Status: COMPLETE COMPLETE
- Elapsed Time (s): 13.144688 .000458 99.99 %
- CPU Time (s): 12.990762 .000457 99.99 %
- User I/O Time (s): 0 0
- Buffer Gets: 594799 93 99.98 %
- Physical Read Requests: 0 0
- Physical Write Requests: 0 0
- Physical Read Bytes: 0 0
- Physical Write Bytes: 0 0
- Rows Processed: 1 1
- Fetches: 1 1
- Executions: 1 1
- Notes
- -----
- 1. Statistics for the original plan were averaged over 1 executions.
- 2. Statistics for the SQL profile plan were averaged over 10 executions.
- -------------------------------------------------------------------------------
- EXPLAIN PLANS SECTION
- -------------------------------------------------------------------------------
- 1- Original With Adjusted Cost
- ------------------------------
- Plan hash value: 538461507
- ------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- ------------------------------------------------------------------------------------------
- | 0 | DELETE STATEMENT | | 1 | 13 | 160K (1)| 00:32:11 |
- | 1 | DELETE | FS_HEADCHANGES_LIST | | | | |
- |* 2 | TABLE ACCESS FULL| FS_HEADCHANGES_LIST | 1 | 13 | 160K (1)| 00:32:11 |
- ------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 2 - filter("FIELDSETID"=:1)
- 2- Using SQL Profile
- --------------------
- Plan hash value: 1287463445
- ---------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- ---------------------------------------------------------------------------------------------
- | 0 | DELETE STATEMENT | | 1 | 13 | 1 (0)| 00:00:01 |
- | 1 | DELETE | FS_HEADCHANGES_LIST | | | | |
- |* 2 | INDEX UNIQUE SCAN| PK_FS_HEADCHANGES_LIST | 1 | 13 | 1 (0)| 00:00:01 |
- ---------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 2 - access("FIELDSETID"=:1)
- -------------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement