API tools faq
paste
Advertisement
Guest User

dt

a guest
Feb 25th, 2009
254
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.61 KB | None | 0 0
raw download clone embed print report
  1. It takes 1 minute to insert 100,000 records into empty table.
  2.  
  3.  
  4.  
  5.  
  6. [oracle@engdb2 dba]$ dstat -t -c -d -m -n
  7. -----time----- ----total-cpu-usage---- -dsk/total- ------memory-usage----- -net/total-
  8. date/time |usr sys idl wai hiq siq| read writ| used buff cach free| recv send
  9. 25-02 18:00:29| 0 0 100 0 0 0|2946B 48k| 458M 15M 1311M 15M| 0 0
  10. 25-02 18:00:30| 1 1 98 0 0 0| 0 0 | 458M 15M 1311M 15M| 120B 284B
  11. 25-02 18:00:31| 0 0 100 0 0 0| 0 0 | 458M 15M 1311M 15M| 60B 182B
  12. 25-02 18:00:32| 1 0 99 0 0 0| 0 52k| 458M 15M 1311M 15M|1367B 236B
  13. 25-02 18:00:33| 45 5 50 0 0 0| 0 5144k| 459M 15M 1311M 15M| 60B 182B
  14. 25-02 18:00:34| 50 5 45 0 0 0| 32k 5972k| 460M 15M 1311M 13M| 120B 182B
  15. 25-02 18:00:35| 53 4 43 0 0 0| 24k 5708k| 459M 15M 1311M 14M| 60B 182B
  16. 25-02 18:00:36| 47 3 47 3 0 0| 0 6660k| 459M 15M 1312M 14M|1422B 182B
  17. 25-02 18:00:37| 49 12 34 4 1 0| 0 7620k| 459M 15M 1314M 12M| 180B 182B
  18. 25-02 18:00:38| 52 11 36 0 0 0| 0 8000k| 459M 15M 1305M 20M| 60B 182B
  19. 25-02 18:00:39| 50 4 34 13 0 1| 0 9488k| 459M 15M 1308M 18M| 950B 979B
  20. 25-02 18:00:40| 48 3 41 8 0 0| 0 8080k| 459M 15M 1309M 17M| 60B 182B
  21. 25-02 18:00:41| 46 5 12 37 0 0|4096B 9968k| 461M 15M 1310M 14M| 152B 182B
  22. 25-02 18:00:42| 44 8 34 15 0 0|4096B 7552k| 460M 15M 1311M 14M| 244B 182B
  23. 25-02 18:00:43| 44 6 20 30 0 0| 0 8844k| 460M 15M 1313M 12M| 240B 182B
  24. 25-02 18:00:44| 58 11 10 22 0 0| 196k 9664k| 465M 15M 1303M 17M| 120B 224B
  25. 25-02 18:00:45| 76 9 1 13 2 0| 160k 9104k| 466M 15M 1305M 14M| 60B 182B
  26. 25-02 18:00:46| 19 3 33 47 0 0| 244k 5424k| 466M 15M 1308M 11M| 180B 182B
  27. 25-02 18:00:47| 25 12 29 35 0 0| 96k 5808k| 459M 15M 1304M 21M| 60B 182B
  28. 25-02 18:00:48| 36 3 11 50 0 0| 0 8120k| 459M 15M 1306M 19M| 60B 182B
  29. 25-02 18:00:49| 47 4 0 50 0 0| 0 9168k| 459M 15M 1309M 17M| 60B 182B
  30. 25-02 18:00:50| 47 5 0 48 0 0| 0 9276k| 459M 15M 1311M 15M| 212B 182B
  31. 25-02 18:00:51| 49 3 19 30 0 0| 0 8772k| 459M 15M 1311M 14M| 60B 182B
  32. 25-02 18:00:52| 47 3 48 2 0 0| 0 5896k| 459M 15M 1312M 13M| 707B 182B
  33. 25-02 18:00:53| 44 8 34 14 0 0| 0 8468k| 459M 15M 1314M 11M| 60B 182B
  34. 25-02 18:00:54| 47 2 41 9 0 0| 0 7464k| 459M 15M 1310M 16M| 60B 182B
  35. 25-02 18:00:55| 44 6 18 33 0 0| 0 8676k| 459M 15M 1312M 13M| 120B 182B
  36. 25-02 18:00:56| 38 4 23 35 0 0| 0 8044k| 459M 15M 1314M 11M|1422B 182B
  37. 25-02 18:00:57| 49 3 28 21 0 0| 0 9368k| 459M 15M 1312M 14M| 60B 182B
  38. 25-02 18:00:58| 45 5 45 6 0 0| 0 7284k| 459M 15M 1313M 12M| 60B 182B
  39. 25-02 18:00:59| 47 3 36 14 0 0| 0 8332k| 459M 15M 1309M 17M| 60B 182B
  40. 25-02 18:01:00| 48 2 39 11 0 0| 0 11M| 459M 15M 1312M 14M| 60B 182B
  41. 25-02 18:01:01| 46 4 22 28 0 0| 0 11M| 459M 15M 1314M 11M| 120B 182B
  42. 25-02 18:01:02| 44 7 49 0 0 0| 0 7056k| 459M 15M 1310M 16M| 120B 182B
  43. 25-02 18:01:03| 44 6 50 0 0 0| 0 8960k| 459M 15M 1313M 13M| 120B 182B
  44. 25-02 18:01:04| 46 4 50 0 0 0| 0 8528k| 459M 15M 1309M 16M| 60B 182B
  45. 25-02 18:01:05| 46 4 50 1 0 0| 0 9.9M| 459M 15M 1312M 14M| 120B 182B
  46. 25-02 18:01:06| 43 7 50 0 0 0| 0 8128k| 459M 15M 1309M 17M| 60B 182B
  47. 25-02 18:01:07| 46 4 50 0 1 0| 0 9508k| 459M 15M 1310M 16M| 120B 182B
  48. 25-02 18:01:08| 46 4 50 0 0 0| 0 7976k| 459M 15M 1312M 14M| 60B 182B
  49. 25-02 18:01:09| 45 5 50 0 0 0| 0 10M| 459M 15M 1309M 16M| 60B 182B
  50. 25-02 18:01:10| 44 6 50 0 0 0| 0 7280k| 459M 15M 1311M 14M| 587B 182B
  51. 25-02 18:01:11| 45 5 50 0 0 0|4096B 8620k| 460M 15M 1313M 12M| 460B 182B
  52. 25-02 18:01:12| 45 5 50 0 1 0| 0 8804k| 459M 15M 1309M 17M| 152B 182B
  53. 25-02 18:01:13| 45 6 50 0 0 0| 0 7952k| 459M 15M 1311M 15M| 552B 182B
  54. 25-02 18:01:14| 46 4 50 0 0 0|4096B 9364k| 459M 15M 1313M 12M| 498B 236B
  55. 25-02 18:01:15| 42 3 50 4 0 0| 0 8272k| 459M 15M 1309M 16M|1726B 182B
  56. 25-02 18:01:16| 45 5 50 0 0 0|4096B 6680k| 459M 15M 1311M 14M| 180B 182B
  57. 25-02 18:01:17| 48 3 49 1 0 0| 0 9676k| 459M 15M 1313M 12M| 60B 182B
  58. 25-02 18:01:18| 47 4 50 0 0 0|4096B 8864k| 459M 15M 1310M 16M| 60B 182B
  59. 25-02 18:01:19| 45 4 50 0 0 0| 0 8708k| 459M 15M 1311M 14M| 587B 182B
  60. 25-02 18:01:20| 46 4 50 0 0 0|4096B 9716k| 459M 15M 1314M 11M| 120B 182B
  61. 25-02 18:01:21| 48 3 50 0 0 0|4096B 8032k| 460M 15M 1310M 15M|5100B 182B
  62. 25-02 18:01:22| 47 3 50 0 1 0| 0 8572k| 459M 15M 1312M 14M| 60B 182B
  63. 25-02 18:01:23| 47 3 50 0 0 0|4096B 9272k| 459M 15M 1314M 11M| 120B 182B
  64. 25-02 18:01:24| 45 5 50 0 0 0| 0 9420k| 459M 15M 1311M 15M| 60B 182B
  65. 25-02 18:01:25| 40 4 50 5 0 0| 0 9448k| 459M 15M 1313M 13M| 120B 182B
  66. 25-02 18:01:26| 22 2 72 4 0 0|4096B 5568k| 460M 15M 1314M 12M| 440B 602B
  67. 25-02 18:01:27| 0 0 100 0 0 0| 0 40k| 459M 15M 1314M 12M| 180B 182B
  68. 25-02 18:01:28| 0 0 100 0 0 0| 0 0 | 459M 15M 1314M 12M| 120B 182B
  69. 25-02 18:01:29| 0 0 100 0 0 0| 0 48k| 459M 15M 1314M 12M| 120B 182B
  70. 25-02 18:01:30| 0 0 100 0 0 0| 0 0 | 459M 15M 1314M 12M| 120B 182B
  71.  
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!