API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 7th, 2014
270
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.25 KB | None | 0 0
raw download clone embed print report
  1. SQL Monitoring Report
  2.  
  3. SQL Text
  4. ------------------------------
  5. MERGE /*+ PARALLEL(8) */ INTO ....
  6.  
  7. Global Information
  8. ------------------------------
  9. Status : DONE (ERROR)
  10. Instance ID : 1
  11. Session : TK (139:887)
  12. SQL ID : 386h41yx7xb4n
  13. SQL Execution ID : 16777217
  14. Execution Started : 04/07/2014 09:25:10
  15. First Refresh Time : 04/07/2014 09:25:10
  16. Last Refresh Time : 04/07/2014 09:25:20
  17. Duration : 10s
  18. Module/Action : SQL Workbench/J 116/-
  19. Service : SYS$USERS
  20. Program : SQL Workbench/J 116
  21.  
  22. Global Stats
  23. =====================================================================================================================
  24. | Elapsed | Queuing | Cpu | IO | Concurrency | PL/SQL | Other | Buffer | Read | Read | Write | Write |
  25. | Time(s) | Time(s) | Time(s) | Waits(s) | Waits(s) | Time(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes |
  26. =====================================================================================================================
  27. | 15858 | 0.00 | 15318 | 507 | 2.54 | 4225 | 31 | 93M | 141K | 4GB | 10893 | 3GB |
  28. =====================================================================================================================
  29.  
  30. Parallel Execution Details (DOP=8 , Servers Allocated=16)
  31. ======================================================================================================================================================================================
  32. | Name | Type | Server# | Elapsed | Queuing | Cpu | IO | Concurrency | PL/SQL | Other | Buffer | Read | Read | Write | Write | Wait Events |
  33. | | | | Time(s) | Time(s) | Time(s) | Waits(s) | Waits(s) | Time(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes | (sample #) |
  34. ======================================================================================================================================================================================
  35. | PX Coordinator | QC | | 7.68 | 0.00 | 7.63 | | 0.05 | | | 4M | | . | | . | |
  36. | p000 | Set 1 | 1 | 186 | | 96 | 86 | 0.38 | | 3.67 | 2M | 21585 | 445MB | 870 | 283MB | |
  37. | p001 | Set 1 | 2 | 161 | | 97 | 61 | 0.30 | | 2.77 | 1M | 14567 | 391MB | 887 | 284MB | |
  38. | p002 | Set 1 | 3 | 170 | | 99 | 69 | 0.31 | | 1.45 | 1M | 16745 | 407MB | 875 | 283MB | |
  39. | p003 | Set 1 | 4 | 143 | | 95 | 42 | 0.27 | | 5.33 | 1M | 9976 | 355MB | 887 | 284MB | |
  40. | p004 | Set 1 | 5 | 163 | | 97 | 62 | 0.30 | | 4.18 | 1M | 14270 | 389MB | 876 | 284MB | |
  41. | p005 | Set 1 | 6 | 153 | | 98 | 52 | 0.27 | | 1.72 | 1M | 11521 | 367MB | 883 | 284MB | |
  42. | p006 | Set 1 | 7 | 148 | | 98 | 48 | 0.27 | | 2.13 | 1M | 10297 | 357MB | 881 | 284MB | |
  43. | p007 | Set 1 | 8 | 166 | | 98 | 65 | 0.36 | | 2.67 | 1M | 15138 | 395MB | 878 | 284MB | |
  44. | p008 | Set 2 | 1 | 1829 | | 1825 | 2.65 | 0.00 | 532 | 1.35 | 10M | 329 | 162MB | 482 | 161MB | direct path write temp (1) |
  45. | p009 | Set 2 | 2 | 1851 | | 1847 | 2.65 | 0.01 | 533 | 1.22 | 10M | 778 | 165MB | 482 | 161MB | direct path write temp (1) |
  46. | p010 | Set 2 | 3 | 1844 | | 1841 | 2.66 | 0.00 | 535 | 0.81 | 10M | 322 | 162MB | 482 | 161MB | direct path write temp (1) |
  47. | p011 | Set 2 | 4 | 1828 | | 1824 | 2.67 | 0.01 | 524 | 0.73 | 10M | 3611 | 188MB | 482 | 161MB | direct path write temp (1) |
  48. | p012 | Set 2 | 5 | 1813 | | 1810 | 2.68 | 0.00 | 527 | 0.91 | 10M | 440 | 163MB | 482 | 161MB | direct path write temp (1) |
  49. | p013 | Set 2 | 6 | 1807 | | 1803 | 2.67 | | 531 | 0.73 | 10M | 1160 | 168MB | 482 | 161MB | direct path write temp (1) |
  50. | p014 | Set 2 | 7 | 1786 | | 1782 | 2.98 | 0.00 | 522 | 0.59 | 10M | 18875 | 307MB | 482 | 161MB | direct path write temp (1) |
  51. | p015 | Set 2 | 8 | 1802 | | 1798 | 2.70 | 0.02 | 522 | 0.78 | 10M | 1548 | 171MB | 482 | 161MB | direct path write temp (1) |
  52. ======================================================================================================================================================================================
  53.  
  54. SQL Plan Monitoring Details (Plan Hash Value=3468581875)
  55. ====================================================================================================================================================================================================================================
  56. | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Mem | Temp | Activity | Activity Detail |
  57. | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | (Max) | (Max) | (%) | (# samples) |
  58. ====================================================================================================================================================================================================================================
  59. | 0 | MERGE STATEMENT | | | | | | 1 | | | | | | | | | |
  60. | 1 | MERGE | TARGET_TABLE | | | | | 1 | | | | | | | | | |
  61. | 2 | PX COORDINATOR | | | | | | 17 | | | | | | | | | |
  62. | 3 | PX SEND QC (RANDOM) | :TQ10002 | 4M | 6M | 928 | +1863 | 8 | 4M | | | | | | | | |
  63. | 4 | VIEW | | | | 928 | +1863 | 8 | 4M | | | | | | | | |
  64. | 5 | NESTED LOOPS | | 4M | 6M | 928 | +1863 | 8 | 4M | | | | | | | | |
  65. | 6 | NESTED LOOPS | | 4M | 6M | 928 | +1863 | 8 | 4M | | | | | | | | |
  66. | 7 | VIEW | | 4M | 5M | 928 | +1863 | 8 | 4M | | | | | | | | |
  67. | 8 | SORT GROUP BY | | 4M | 5M | 2779 | +12 | 8 | 4M | 7385 | 2GB | 7037 | 2GB | 69M | 1G | | |
  68. | 9 | PX RECEIVE | | 4M | 5M | 1850 | +12 | 8 | 70M | | | | | | | | |
  69. | 10 | PX SEND HASH | :TQ10001 | 4M | 5M | 1848 | +12 | 8 | 70M | | | | | | | | |
  70. | 11 | NESTED LOOPS | | 4M | 5M | 1848 | +12 | 8 | 70M | | | | | | | | |
  71. | 12 | NESTED LOOPS | | 4M | 5M | 1848 | +12 | 8 | 70M | | | | | | | | |
  72. | 13 | BUFFER SORT | | | | 1858 | +2 | 8 | 4M | 1296 | 1GB | 3856 | 1GB | 64M | 1G | 37.50 | Cpu (1) |
  73. | | | | | | | | | | | | | | | | | direct path write temp (8) |
  74. | 14 | PX RECEIVE | | | | 11 | +2 | 8 | 4M | | | | | | | 20.83 | Cpu (5) |
  75. | 15 | PX SEND ROUND-ROBIN | :TQ10000 | | | 10 | +2 | 1 | 4M | | | | | | | 16.67 | Cpu (4) |
  76. | 16 | TABLE ACCESS BY INDEX ROWID | BASE_TABLE | 4M | 4M | 9 | +2 | 1 | 4M | | | | | | | 16.67 | Cpu (4) |
  77. | 17 | INDEX FULL SCAN | IX_UNQ_BASE_TABLE | 4M | 18796 | 9 | +2 | 1 | 4M | | | | | | | 4.17 | Cpu (1) |
  78. | 18 | PARTITION LIST ITERATOR | | 1 | | 1848 | +12 | 4M | 70M | | | | | | | | |
  79. | 19 | INDEX RANGE SCAN | IDX_UNQ_SALES_TABLE | 1 | | 1848 | +12 | 4M | 70M | 25767 | 201MB | | | | | | |
  80. | 20 | TABLE ACCESS BY LOCAL INDEX ROWID | SALES_TABLE | 1 | | 1848 | +12 | 70M | 70M | | | | | | | | |
  81. | 21 | PARTITION LIST ITERATOR | | 1 | | 928 | +1863 | 4M | 4M | | | | | | | | |
  82. | 22 | INDEX RANGE SCAN | PK_TARGET_TABLE | 1 | | 928 | +1863 | 4M | 4M | 10869 | 85MB | | | | | | |
  83. | 23 | TABLE ACCESS BY LOCAL INDEX ROWID | TARGET_TABLE | 1 | | 928 | +1863 | 4M | 4M | 95845 | 749MB | | | | | | |
  84. ====================================================================================================================================================================================================================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!