Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2014
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.57 KB | None | 0 0
  1. total_threads=16
  2.  
  3. echo ""
  4. echo "Running Web Exclusive Item updates ... "
  5. echo "Total Number of threads = " $total_threads
  6. for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
  7. do
  8. echo "Running Thread $i .. "
  9. ./run_upd_web_excl_items.sh $i $total_threads &
  10. done
  11. wait
  12. echo "Done."
  13.  
  14.  
  15. echo ""
  16. echo "Committing data ... "
  17. output_val=`$ORACLE_HOME/bin/sqlplus -S $UP <<endofsql
  18. whenever sqlerror exit 2
  19. whenever oserror exit 3
  20. SET HEADING OFF
  21. SET FEEDBACK OFF
  22. SET ECHO OFF
  23. set serverout on
  24. commit;
  25. /
  26. exit
  27. endofsql`
  28. echo "Done."
  29.  
  30. ~> . ./run_upd_web_excl_items_mitctrl.sh
  31.  
  32. Running Web Exclusive Item updates ...
  33. Total Number of threads = 16
  34. Running Thread 1 ..
  35. Running Thread 2 ..
  36. Running Thread 3 ..
  37. Running Thread 4 ..
  38. Running Thread 5 ..
  39. Running Thread 6 ..
  40. Running Thread 7 ..
  41. Running Thread 8 ..
  42. Running Thread 9 ..
  43. Running Thread 10 ..
  44. Running Thread 11 ..
  45. Running Thread 12 ..
  46. Running Thread 13 ..
  47. Running Thread 14 ..
  48. Running Thread 15 ..
  49. Running Thread 16 ..
  50. Total time for Thread 3 : 0 minute(s), 22.5 second(s).
  51. Total time for Thread 2 : 0 minute(s), 23.3 second(s).
  52. Total time for Thread 12 : 0 minute(s), 24.3 second(s).
  53. Total time for Thread 8 : 0 minute(s), 24.8 second(s).
  54. Total time for Thread 7 : 0 minute(s), 29.9 second(s).
  55. Total time for Thread 1 : 0 minute(s), 30 second(s).
  56. [1] Done ./run_upd_web_excl_items.sh $i $total_threads
  57. [2] Done ./run_upd_web_excl_items.sh $i $total_threads
  58. [3] Done ./run_upd_web_excl_items.sh $i $total_threads
  59. [7] Done ./run_upd_web_excl_items.sh $i $total_threads
  60. [8] Done ./run_upd_web_excl_items.sh $i $total_threads
  61. [12] Done ./run_upd_web_excl_items.sh $i $total_threads
  62. Total time for Thread 16 : 0 minute(s), 32.1 second(s).
  63. Total time for Thread 4 : 0 minute(s), 32.8 second(s).
  64. [4] Done ./run_upd_web_excl_items.sh $i $total_threads
  65. [16]+ Done ./run_upd_web_excl_items.sh $i $total_threads
  66. Total time for Thread 10 : 0 minute(s), 33.2 second(s).
  67. Total time for Thread 13 : 0 minute(s), 33.7 second(s).
  68. Total time for Thread 5 : 0 minute(s), 33.8 second(s).
  69. [5] Done ./run_upd_web_excl_items.sh $i $total_threads
  70. [10] Done ./run_upd_web_excl_items.sh $i $total_threads
  71. [13] Done ./run_upd_web_excl_items.sh $i $total_threads
  72. Total time for Thread 14 : 0 minute(s), 35.6 second(s).
  73. Total time for Thread 6 : 0 minute(s), 36.8 second(s).
  74. [6] Done ./run_upd_web_excl_items.sh $i $total_threads
  75. [14]- Done ./run_upd_web_excl_items.sh $i $total_threads
  76. Total time for Thread 11 : 0 minute(s), 37.7 second(s).
  77. Total time for Thread 9 : 0 minute(s), 37.8 second(s).
  78. [9] Done ./run_upd_web_excl_items.sh $i $total_threads
  79. [11]- Done ./run_upd_web_excl_items.sh $i $total_threads
  80. Total time for Thread 15 : 0 minute(s), 38.8 second(s).
  81. [15]+ Done ./run_upd_web_excl_items.sh $i $total_threads
  82. Done.
  83.  
  84. Committing data ...
  85. Done.
  86.  
  87. ~> ./run_upd_web_excl_items_mitctrl.sh
  88.  
  89. Running Web Exclusive Item updates ...
  90. Total Number of threads = 16
  91. Running Thread 1 ..
  92. Running Thread 2 ..
  93. Running Thread 3 ..
  94. Running Thread 4 ..
  95. Running Thread 5 ..
  96. Running Thread 6 ..
  97. Running Thread 7 ..
  98. Running Thread 8 ..
  99. Running Thread 9 ..
  100. Running Thread 10 ..
  101. Running Thread 11 ..
  102. Running Thread 12 ..
  103. Running Thread 13 ..
  104. Running Thread 14 ..
  105. Running Thread 15 ..
  106. Running Thread 16 ..
  107. Total time for Thread 1 : 0 minute(s), 26.5 second(s).
  108. Total time for Thread 10 : 0 minute(s), 27.1 second(s).
  109. Total time for Thread 2 : 0 minute(s), 27.5 second(s).
  110. Total time for Thread 6 : 0 minute(s), 27.9 second(s).
  111. Total time for Thread 3 : 0 minute(s), 27.9 second(s).
  112. Total time for Thread 15 : 0 minute(s), 27.9 second(s).
  113. Total time for Thread 9 : 0 minute(s), 28 second(s).
  114. Total time for Thread 5 : 0 minute(s), 28 second(s).
  115. Total time for Thread 16 : 0 minute(s), 28.1 second(s).
  116. Total time for Thread 8 : 0 minute(s), 30.5 second(s).
  117. Total time for Thread 12 : 0 minute(s), 31 second(s).
  118. Total time for Thread 11 : 0 minute(s), 31.5 second(s).
  119. Total time for Thread 7 : 0 minute(s), 31.9 second(s).
  120. Total time for Thread 14 : 0 minute(s), 32 second(s).
  121. Total time for Thread 13 : 0 minute(s), 32.7 second(s).
  122. Total time for Thread 4 : 0 minute(s), 34.8 second(s).
  123. Done.
  124.  
  125. Committing data ...
  126. Done.
  127.  
  128. [13] Done ./run_upd_web_excl_items.sh $i $total_threads
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement