Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.74 KB | None | 0 0
  1. GENERAL INFORMATION SECTION
  2. -------------------------------------------------------------------------------
  3. Tuning Task Name : UFOS_REF__5puz6u3a9ynn8
  4. Tuning Task Owner : UFOS_REF
  5. Workload Type : Single SQL Statement
  6. Scope : COMPREHENSIVE
  7. Time Limit(seconds): 1800
  8. Completion Status : COMPLETED
  9. Started at : 01/16/2017 16:00:17
  10. Completed at : 01/16/2017 16:00:34
  11.  
  12. -------------------------------------------------------------------------------
  13. Schema Name: UFOS_REF
  14. SQL ID : 5puz6u3a9ynn8
  15. SQL Text : delete from FS_HEADCHANGES_LIST where fieldSetId=:1
  16. Bind Variables :
  17. 1 - (NUMBER):1056390667
  18.  
  19. -------------------------------------------------------------------------------
  20. FINDINGS SECTION (1 finding)
  21. -------------------------------------------------------------------------------
  22.  
  23. 1- SQL Profile Finding (see explain plans section below)
  24. --------------------------------------------------------
  25. A potentially better execution plan was found for this statement.
  26.  
  27. Recommendation (estimated benefit: 99.98%)
  28. ------------------------------------------
  29. - Consider accepting the recommended SQL profile. The SQL plan baseline
  30. corresponding to the plan with the SQL profile will also be updated to an
  31. accepted plan.
  32. execute dbms_sqltune.accept_sql_profile(task_name =>
  33. 'UFOS_REF__5puz6u3a9ynn8', task_owner => 'UFOS_REF', replace =>
  34. TRUE);
  35.  
  36. Validation results
  37. ------------------
  38. The SQL profile was tested by executing both its plan and the original plan
  39. and measuring their respective execution statistics. A plan may have been
  40. only partially executed if the other could be run to completion in less time.
  41.  
  42. Original Plan With SQL Profile % Improved
  43. ------------- ---------------- ----------
  44. Completion Status: COMPLETE COMPLETE
  45. Elapsed Time (s): 13.144688 .000458 99.99 %
  46. CPU Time (s): 12.990762 .000457 99.99 %
  47. User I/O Time (s): 0 0
  48. Buffer Gets: 594799 93 99.98 %
  49. Physical Read Requests: 0 0
  50. Physical Write Requests: 0 0
  51. Physical Read Bytes: 0 0
  52. Physical Write Bytes: 0 0
  53. Rows Processed: 1 1
  54. Fetches: 1 1
  55. Executions: 1 1
  56.  
  57. Notes
  58. -----
  59. 1. Statistics for the original plan were averaged over 1 executions.
  60. 2. Statistics for the SQL profile plan were averaged over 10 executions.
  61.  
  62. -------------------------------------------------------------------------------
  63. EXPLAIN PLANS SECTION
  64. -------------------------------------------------------------------------------
  65.  
  66. 1- Original With Adjusted Cost
  67. ------------------------------
  68. Plan hash value: 538461507
  69.  
  70. ------------------------------------------------------------------------------------------
  71. | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
  72. ------------------------------------------------------------------------------------------
  73. | 0 | DELETE STATEMENT | | 1 | 13 | 160K (1)| 00:32:11 |
  74. | 1 | DELETE | FS_HEADCHANGES_LIST | | | | |
  75. |* 2 | TABLE ACCESS FULL| FS_HEADCHANGES_LIST | 1 | 13 | 160K (1)| 00:32:11 |
  76. ------------------------------------------------------------------------------------------
  77.  
  78. Predicate Information (identified by operation id):
  79. ---------------------------------------------------
  80.  
  81. 2 - filter("FIELDSETID"=:1)
  82.  
  83. 2- Using SQL Profile
  84. --------------------
  85. Plan hash value: 1287463445
  86.  
  87. ---------------------------------------------------------------------------------------------
  88. | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
  89. ---------------------------------------------------------------------------------------------
  90. | 0 | DELETE STATEMENT | | 1 | 13 | 1 (0)| 00:00:01 |
  91. | 1 | DELETE | FS_HEADCHANGES_LIST | | | | |
  92. |* 2 | INDEX UNIQUE SCAN| PK_FS_HEADCHANGES_LIST | 1 | 13 | 1 (0)| 00:00:01 |
  93. ---------------------------------------------------------------------------------------------
  94.  
  95. Predicate Information (identified by operation id):
  96. ---------------------------------------------------
  97.  
  98. 2 - access("FIELDSETID"=:1)
  99.  
  100. -------------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement