ускорить insert + кусок трэйса

тобобетобор
Дата: 26.11.2009 10:29:33
есть тормозной процесс, на первое место в трэйсе вылезло вот это
INSERT INTO T1
VALUES
 (:B1 ,:B2 ,:B3 ,:B4 ,:B5 ,:B6 ,:B7 ,:B8 ,:B9 ,:B10 ,:B11 ) 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      289      0.01       0.01          0          0          0           0
Execute 202739     77.38     698.04       2808     214631    8687766      202739
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   203028     77.39     698.05       2808     214631    8687766      202739

Misses in library cache during parse: 1
Optimizer mode: CHOOSE
Parsing user id: 67     (recursive depth: 1)

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  buffer busy waits                            9532        0.82         78.23
  db file sequential read                      2805        1.02        317.58
  enqueue                                      2916        2.93        188.48
  latch free                                    352        0.03          3.55
  buffer deadlock                               303        0.09          1.07
  log file sync                                  41        0.71          5.88
  log buffer space                                2        0.03          0.06
  log file switch completion                     21        0.59          4.59
  control file sequential read                   24        0.66          1.82
  async disk IO                                 386        0.00          0.00
  db file single write                            2        0.00          0.01
  control file parallel write                     4        0.02          0.05
  rdbms ipc reply                                 2        0.01          0.01
********************************************************************************
необходимо ускорить процесс в 5 раз. Какие будут рекомендации ?
Вячеслав Любомудров
Дата: 26.11.2009 10:33:45
Как минимум, избавится от других вставляющих данные и некоммитищихся сразу сессий -- выигрыш будет за счет enqueue
Ну и скорость доступа к диску (db file sequential read)
тобобетобор
Дата: 26.11.2009 10:39:48
Вячеслав Любомудров
Как минимум, избавится от других вставляющих данные и некоммитищихся сразу сессий
в смысле избавиться ? процесс специально был разбит на несколько параллельных потоков (диапазоны) - расчет был на то что это немного ускорят дело...
wurdu
Дата: 26.11.2009 10:43:28
тобобетобор
Вячеслав Любомудров
Как минимум, избавится от других вставляющих данные и некоммитищихся сразу сессий
в смысле избавиться ? процесс специально был разбит на несколько параллельных потоков (диапазоны) - расчет был на то что это немного ускорят дело...
Это затормозит дело. Лучше использовать bulk insert (если нет возможности direct path insert). Если задача позволяет, можно удалить в начале индексы, а затем построить заново.
тобобетобор
Дата: 26.11.2009 11:13:41
wurdu
Это затормозит дело.
обосновать можно ? процесс инсертит данные нерегулярно - сделав несколько параллельных процессов, мы более полно используем ресурсы БД
wurdu
Лучше использовать bulk insert (если нет возможности direct path insert). Если задача позволяет, можно удалить в начале индексы, а затем построить заново.
к сожалению не прокатывает в нашем случае...
wurdu
Дата: 26.11.2009 11:36:04
тобобетобор
wurdu
Это затормозит дело.
обосновать можно ? процесс инсертит данные нерегулярно - сделав несколько параллельных процессов, мы более полно используем ресурсы БД
wurdu
Лучше использовать bulk insert (если нет возможности direct path insert). Если задача позволяет, можно удалить в начале индексы, а затем построить заново.
к сожалению не прокатывает в нашем случае...
Возникает конкуренция и связанные с этим ожидания, что мы и видим в трэйсе. Хотя если нарисовать initrans правильный и freelists (если не ASSM), то наверное можно ускорить. Почему bulk нельзя использовать? Ну и ожидания db file sequential read какие-то запредельно большие. Должны быть примерно в 10 раз меньше на современных дисках.
andrey_anonymous
Дата: 26.11.2009 11:42:26
тобобетобор
к сожалению не прокатывает в нашем случае...

Что конкретно из перечисленного "не прокатывает"?
тобобетобор
Дата: 26.11.2009 11:43:23
wurdu
Возникает конкуренция и связанные с этим ожидания, что мы и видим в трэйсе. Хотя если нарисовать initrans правильный и freelists (если не ASSM) то наверное можно ускорить.
ASSM
wurdu
Почему bulk нельзя использовать?
требует переписывания неких стандартных процедур - на это пока не идут, большие трудозатраты
wurdu
Ну и ожидания db file sequential read какие-то запредельно большие. Должны быть примерно в 10 раз меньше на современных дисках.
с этого места поподробнее плиз, вот выборка из сырого трэйса:
+
WAIT #71: nam='db file sequential read' ela= 11827 p1=1 p2=347 p3=1
WAIT #107: nam='db file sequential read' ela= 7033 p1=1 p2=187 p3=1
WAIT #107: nam='db file sequential read' ela= 3205 p1=1 p2=179 p3=1
WAIT #108: nam='db file sequential read' ela= 2123 p1=1 p2=371 p3=1
WAIT #109: nam='db file sequential read' ela= 4730 p1=1 p2=827 p3=1
WAIT #110: nam='db file sequential read' ela= 5060 p1=1 p2=41181 p3=1
WAIT #11: nam='db file sequential read' ela= 199007 p1=9 p2=2070218 p3=1
WAIT #11: nam='db file sequential read' ela= 162383 p1=9 p2=2118999 p3=1
WAIT #62: nam='db file sequential read' ela= 263100 p1=9 p2=2079063 p3=1
WAIT #11: nam='db file sequential read' ela= 27945 p1=9 p2=2050571 p3=1
WAIT #11: nam='db file sequential read' ela= 22869 p1=9 p2=2070346 p3=1
WAIT #11: nam='db file sequential read' ela= 285632 p1=9 p2=2069451 p3=1
WAIT #62: nam='db file sequential read' ela= 7906 p1=9 p2=2079127 p3=1
WAIT #11: nam='db file sequential read' ela= 159111 p1=9 p2=2050827 p3=1
WAIT #11: nam='db file sequential read' ela= 20769 p1=9 p2=2119063 p3=1
WAIT #11: nam='db file sequential read' ela= 449064 p1=9 p2=2069707 p3=1
WAIT #11: nam='db file sequential read' ela= 8314 p1=9 p2=2050891 p3=1
WAIT #11: nam='db file sequential read' ela= 5374 p1=9 p2=2069899 p3=1
WAIT #62: nam='db file sequential read' ela= 2361 p1=9 p2=2079191 p3=1
WAIT #109: nam='db file sequential read' ela= 327673 p1=1 p2=39267 p3=1
WAIT #110: nam='db file sequential read' ela= 23772 p1=1 p2=36768 p3=1
WAIT #112: nam='db file sequential read' ela= 35881 p1=1 p2=1002 p3=1
WAIT #112: nam='db file sequential read' ela= 59896 p1=1 p2=622 p3=1
WAIT #112: nam='db file sequential read' ela= 12083 p1=1 p2=1010 p3=1
WAIT #112: nam='db file sequential read' ela= 44821 p1=1 p2=1026 p3=1
WAIT #112: nam='db file sequential read' ela= 687466 p1=1 p2=41224 p3=1
WAIT #112: nam='db file sequential read' ela= 118250 p1=1 p2=43589 p3=1
WAIT #112: nam='db file sequential read' ela= 14019 p1=1 p2=43571 p3=1
WAIT #60: nam='db file sequential read' ela= 31486 p1=1 p2=39767 p3=1
WAIT #60: nam='db file sequential read' ela= 387996 p1=1 p2=41963 p3=1
WAIT #112: nam='db file sequential read' ela= 382962 p1=1 p2=1615 p3=1
WAIT #112: nam='db file sequential read' ela= 13490 p1=1 p2=43535 p3=1
WAIT #60: nam='db file sequential read' ela= 16092 p1=1 p2=1579 p3=1
WAIT #60: nam='db file sequential read' ela= 26288 p1=1 p2=43683 p3=1
WAIT #98: nam='db file sequential read' ela= 13875 p1=1 p2=37715 p3=1
WAIT #98: nam='db file sequential read' ela= 15459 p1=1 p2=41933 p3=1
WAIT #98: nam='db file sequential read' ela= 5052 p1=1 p2=44273 p3=1
WAIT #98: nam='db file sequential read' ela= 11656 p1=1 p2=39154 p3=1
WAIT #112: nam='db file sequential read' ela= 48437 p1=1 p2=43590 p3=1
WAIT #112: nam='db file sequential read' ela= 10338 p1=1 p2=43575 p3=1
WAIT #60: nam='db file sequential read' ela= 4907 p1=1 p2=43742 p3=1
WAIT #60: nam='db file sequential read' ela= 11838 p1=1 p2=43749 p3=1
WAIT #112: nam='db file sequential read' ela= 11789 p1=1 p2=44000 p3=1
WAIT #98: nam='db file sequential read' ela= 21393 p1=1 p2=39422 p3=1
WAIT #98: nam='db file sequential read' ela= 5634 p1=1 p2=44261 p3=1
WAIT #98: nam='db file sequential read' ela= 3590 p1=1 p2=44258 p3=1
WAIT #113: nam='db file sequential read' ela= 4331 p1=1 p2=44186 p3=1
WAIT #109: nam='db file sequential read' ela= 2338 p1=1 p2=43627 p3=1
WAIT #110: nam='db file sequential read' ela= 2704 p1=1 p2=41178 p3=1
WAIT #108: nam='db file sequential read' ela= 25590 p1=1 p2=46028 p3=1
WAIT #109: nam='db file sequential read' ela= 12337 p1=1 p2=43628 p3=1
WAIT #32: nam='db file sequential read' ela= 10423 p1=10 p2=633168 p3=1
WAIT #108: nam='db file sequential read' ela= 15351 p1=1 p2=46029 p3=1
WAIT #107: nam='db file sequential read' ela= 5112 p1=1 p2=14160 p3=1
WAIT #108: nam='db file sequential read' ela= 3132 p1=1 p2=190 p3=1
WAIT #108: nam='db file sequential read' ela= 4730 p1=1 p2=41136 p3=1
WAIT #113: nam='db file sequential read' ela= 5122 p1=1 p2=39759 p3=1
WAIT #112: nam='db file sequential read' ela= 3948 p1=1 p2=43576 p3=1
WAIT #98: nam='db file sequential read' ela= 27557 p1=1 p2=39316 p3=1
WAIT #98: nam='db file sequential read' ela= 37967 p1=1 p2=191 p3=1
WAIT #98: nam='db file sequential read' ela= 11394 p1=1 p2=43913 p3=1
WAIT #98: nam='db file sequential read' ela= 6948 p1=1 p2=39262 p3=1
WAIT #115: nam='db file sequential read' ela= 17354 p1=1 p2=41884 p3=1
WAIT #98: nam='db file sequential read' ela= 9252 p1=1 p2=12539 p3=1
WAIT #98: nam='db file sequential read' ela= 8499 p1=1 p2=39282 p3=1
WAIT #107: nam='db file sequential read' ela= 2505 p1=1 p2=43914 p3=1
WAIT #107: nam='db file sequential read' ela= 4180 p1=1 p2=43919 p3=1
WAIT #113: nam='db file sequential read' ela= 5492 p1=1 p2=39760 p3=1
WAIT #109: nam='db file sequential read' ela= 8060 p1=1 p2=39272 p3=1
WAIT #110: nam='db file sequential read' ela= 3563 p1=1 p2=36765 p3=1
WAIT #113: nam='db file sequential read' ela= 4969 p1=1 p2=39754 p3=1
WAIT #112: nam='db file sequential read' ela= 14720 p1=1 p2=43585 p3=1
WAIT #112: nam='db file sequential read' ela= 16930 p1=1 p2=43529 p3=1
WAIT #112: nam='db file sequential read' ela= 5738 p1=1 p2=43586 p3=1
WAIT #112: nam='db file sequential read' ela= 11297 p1=1 p2=43603 p3=1
WAIT #116: nam='db file sequential read' ela= 8183 p1=1 p2=37716 p3=1
WAIT #116: nam='db file sequential read' ela= 10121 p1=1 p2=41931 p3=1
WAIT #116: nam='db file sequential read' ela= 2078 p1=1 p2=41926 p3=1
WAIT #113: nam='db file sequential read' ela= 3321 p1=1 p2=39198 p3=1
WAIT #112: nam='db file sequential read' ela= 6015 p1=1 p2=1616 p3=1
WAIT #112: nam='db file sequential read' ela= 1713 p1=1 p2=1598 p3=1
WAIT #98: nam='db file sequential read' ela= 1811 p1=1 p2=1580 p3=1
WAIT #98: nam='db file sequential read' ela= 19126 p1=1 p2=43417 p3=1
WAIT #98: nam='db file sequential read' ela= 11120 p1=1 p2=43548 p3=1
WAIT #109: nam='db file sequential read' ela= 19316 p1=1 p2=43626 p3=1
WAIT #108: nam='db file sequential read' ela= 18925 p1=1 p2=43916 p3=1
WAIT #112: nam='db file sequential read' ela= 10779 p1=1 p2=1614 p3=1
WAIT #112: nam='db file sequential read' ela= 17849 p1=1 p2=1599 p3=1
WAIT #98: nam='db file sequential read' ela= 11507 p1=1 p2=43413 p3=1
WAIT #98: nam='db file sequential read' ela= 52036 p1=1 p2=43414 p3=1
WAIT #40: nam='db file sequential read' ela= 37257 p1=4 p2=12117 p3=1
WAIT #116: nam='db file sequential read' ela= 17330 p1=1 p2=37718 p3=1
WAIT #116: nam='db file sequential read' ela= 514304 p1=1 p2=39165 p3=1
WAIT #113: nam='db file sequential read' ela= 145869 p1=1 p2=39193 p3=1
WAIT #108: nam='db file sequential read' ela= 49794 p1=1 p2=41134 p3=1
WAIT #113: nam='db file sequential read' ela= 14616 p1=1 p2=39758 p3=1
WAIT #98: nam='db file sequential read' ela= 3870 p1=1 p2=43781 p3=1
WAIT #98: nam='db file sequential read' ela= 1771 p1=1 p2=43692 p3=1
WAIT #116: nam='db file sequential read' ela= 6699 p1=1 p2=46017 p3=1
WAIT #112: nam='db file sequential read' ela= 13837 p1=1 p2=45990 p3=1
WAIT #98: nam='db file sequential read' ela= 9281 p1=1 p2=47625 p3=1
WAIT #98: nam='db file sequential read' ela= 5792 p1=1 p2=44808 p3=1
WAIT #116: nam='db file sequential read' ela= 5474 p1=1 p2=44278 p3=1
WAIT #116: nam='db file sequential read' ela= 4124 p1=1 p2=41934 p3=1
WAIT #112: nam='db file sequential read' ela= 4677 p1=1 p2=44212 p3=1
WAIT #112: nam='db file sequential read' ela= 6655 p1=1 p2=45987 p3=1
WAIT #85: nam='db file sequential read' ela= 4953 p1=1 p2=39219 p3=1
WAIT #85: nam='db file sequential read' ela= 3470 p1=1 p2=39222 p3=1
WAIT #108: nam='db file sequential read' ela= 6969 p1=1 p2=41135 p3=1
WAIT #98: nam='db file sequential read' ela= 9246 p1=1 p2=43804 p3=1
WAIT #98: nam='db file sequential read' ela= 10982 p1=1 p2=43797 p3=1
WAIT #98: nam='db file sequential read' ela= 6276 p1=1 p2=44757 p3=1
WAIT #106: nam='db file sequential read' ela= 4628 p1=1 p2=39307 p3=1
WAIT #106: nam='db file sequential read' ela= 1794 p1=1 p2=39368 p3=1
WAIT #106: nam='db file sequential read' ela= 3484 p1=1 p2=43420 p3=1
WAIT #106: nam='db file sequential read' ela= 10231 p1=1 p2=43419 p3=1
WAIT #71: nam='db file sequential read' ela= 18870 p1=1 p2=39392 p3=1
WAIT #108: nam='db file sequential read' ela= 4383 p1=1 p2=39221 p3=1
WAIT #108: nam='db file sequential read' ela= 1406 p1=1 p2=39164 p3=1
WAIT #108: nam='db file sequential read' ela= 2485 p1=1 p2=39456 p3=1
WAIT #108: nam='db file sequential read' ela= 6198 p1=1 p2=44257 p3=1
WAIT #109: nam='db file sequential read' ela= 43200 p1=1 p2=39270 p3=1
WAIT #71: nam='db file sequential read' ela= 17836 p1=1 p2=47680 p3=1
WAIT #71: nam='db file sequential read' ela= 501 p1=1 p2=43439 p3=1
WAIT #71: nam='db file sequential read' ela= 464 p1=1 p2=43421 p3=1
WAIT #71: nam='db file sequential read' ela= 4500 p1=1 p2=43422 p3=1
WAIT #53: nam='db file sequential read' ela= 14511 p1=10 p2=839394 p3=1
WAIT #106: nam='db file sequential read' ela= 383285 p1=1 p2=43601 p3=1
WAIT #90: nam='db file sequential read' ela= 116492 p1=1 p2=39373 p3=1
WAIT #104: nam='db file sequential read' ela= 14077 p1=1 p2=39259 p3=1
WAIT #104: nam='db file sequential read' ela= 16341 p1=1 p2=39286 p3=1
WAIT #107: nam='db file sequential read' ela= 5726 p1=1 p2=41922 p3=1
WAIT #108: nam='db file sequential read' ela= 16882 p1=1 p2=39199 p3=1
WAIT #109: nam='db file sequential read' ela= 102358 p1=1 p2=35576 p3=1
WAIT #56: nam='db file sequential read' ela= 32261 p1=1 p2=36764 p3=1
WAIT #106: nam='db file sequential read' ela= 58296 p1=1 p2=1611 p3=1
WAIT #106: nam='db file sequential read' ela= 23807 p1=1 p2=43607 p3=1
WAIT #104: nam='db file sequential read' ela= 116117 p1=1 p2=39135 p3=1
WAIT #108: nam='db file sequential read' ela= 235280 p1=1 p2=39196 p3=1
WAIT #109: nam='db file sequential read' ela= 15353 p1=1 p2=35575 p3=1
WAIT #56: nam='db file sequential read' ela= 16925 p1=1 p2=36763 p3=1
WAIT #101: nam='db file sequential read' ela= 493758 p1=1 p2=2306 p3=1
WAIT #101: nam='db file sequential read' ela= 7977 p1=1 p2=2309 p3=1
WAIT #101: nam='db file sequential read' ela= 55942 p1=1 p2=35063 p3=1
WAIT #22: nam='db file sequential read' ela= 11124 p1=1 p2=2338 p3=1
WAIT #22: nam='db file sequential read' ela= 162234 p1=1 p2=2341 p3=1
WAIT #22: nam='db file sequential read' ela= 90557 p1=1 p2=46065 p3=1
WAIT #42: nam='db file sequential read' ela= 64295 p1=1 p2=2370 p3=1
WAIT #42: nam='db file sequential read' ela= 15801 p1=1 p2=35470 p3=1
WAIT #42: nam='db file sequential read' ela= 18146 p1=1 p2=38800 p3=1
WAIT #89: nam='db file sequential read' ela= 793791 p1=1 p2=2434 p3=1
WAIT #89: nam='db file sequential read' ela= 269745 p1=1 p2=2437 p3=1
WAIT #89: nam='db file sequential read' ela= 92374 p1=1 p2=39107 p3=1
WAIT #106: nam='db file sequential read' ela= 656670 p1=1 p2=1597 p3=1
WAIT #33: nam='db file sequential read' ela= 73458 p1=1 p2=43697 p3=1
WAIT #33: nam='db file sequential read' ela= 7373 p1=1 p2=47702 p3=1
WAIT #33: nam='db file sequential read' ela= 3026 p1=1 p2=47701 p3=1
WAIT #33: nam='db file sequential read' ela= 573601 p1=1 p2=47700 p3=1
WAIT #33: nam='db file sequential read' ela= 6335 p1=1 p2=47626 p3=1
WAIT #33: nam='db file sequential read' ela= 10606 p1=1 p2=47688 p3=1
WAIT #33: nam='db file sequential read' ela= 6140 p1=1 p2=43409 p3=1
WAIT #33: nam='db file sequential read' ela= 8466 p1=1 p2=43408 p3=1
WAIT #33: nam='db file sequential read' ela= 174534 p1=1 p2=47632 p3=1
WAIT #71: nam='db file sequential read' ela= 27228 p1=1 p2=39393 p3=1
WAIT #105: nam='db file sequential read' ela= 31770 p1=1 p2=39284 p3=1
WAIT #106: nam='db file sequential read' ela= 353837 p1=1 p2=1613 p3=1
WAIT #71: nam='db file sequential read' ela= 9519 p1=1 p2=43511 p3=1
WAIT #71: nam='db file sequential read' ela= 7325 p1=1 p2=43518 p3=1
WAIT #71: nam='db file sequential read' ela= 41169 p1=1 p2=1572 p3=1
WAIT #105: nam='db file sequential read' ela= 281226 p1=1 p2=39389 p3=1
WAIT #105: nam='db file sequential read' ela= 26218 p1=1 p2=39395 p3=1
WAIT #58: nam='db file sequential read' ela= 528659 p1=7 p2=514752 p3=1
WAIT #58: nam='db file sequential read' ela= 7611 p1=10 p2=400940 p3=1
WAIT #67: nam='db file sequential read' ela= 7034 p1=4 p2=253934 p3=1
WAIT #74: nam='db file sequential read' ela= 7386 p1=9 p2=738600 p3=1
WAIT #74: nam='db file sequential read' ela= 7070 p1=7 p2=1042250 p3=1
WAIT #74: nam='db file sequential read' ela= 208868 p1=10 p2=432386 p3=1
WAIT #87: nam='db file sequential read' ela= 535104 p1=4 p2=9763 p3=1
WAIT #87: nam='db file sequential read' ela= 381914 p1=4 p2=904464 p3=1
WAIT #93: nam='db file sequential read' ela= 32714 p1=10 p2=972181 p3=1
WAIT #109: nam='db file sequential read' ela= 19105 p1=1 p2=39756 p3=1
WAIT #106: nam='db file sequential read' ela= 564478 p1=1 p2=43591 p3=1
WAIT #106: nam='db file sequential read' ela= 248317 p1=1 p2=43574 p3=1
WAIT #46: nam='db file sequential read' ela= 190073 p1=9 p2=2033315 p3=1
WAIT #106: nam='db file sequential read' ela= 17630 p1=1 p2=43592 p3=1
WAIT #106: nam='db file sequential read' ela= 9478 p1=1 p2=43994 p3=1
WAIT #90: nam='db file sequential read' ela= 8811 p1=1 p2=44695 p3=1
WAIT #90: nam='db file sequential read' ela= 21809 p1=1 p2=43885 p3=1
WAIT #106: nam='db file sequential read' ela= 13679 p1=1 p2=43997 p3=1
WAIT #90: nam='db file sequential read' ela= 4482 p1=1 p2=43878 p3=1
WAIT #90: nam='db file sequential read' ela= 40531 p1=1 p2=47717 p3=1
WAIT #106: nam='db file sequential read' ela= 438964 p1=1 p2=43573 p3=1
WAIT #90: nam='db file sequential read' ela= 164888 p1=1 p2=43738 p3=1
WAIT #90: nam='db file sequential read' ela= 11131 p1=1 p2=44696 p3=1
WAIT #90: nam='db file sequential read' ela= 10593 p1=1 p2=43737 p3=1
WAIT #90: nam='db file sequential read' ela= 40911 p1=1 p2=43704 p3=1
WAIT #90: nam='db file sequential read' ela= 28494 p1=1 p2=44708 p3=1
WAIT #90: nam='db file sequential read' ela= 13170 p1=1 p2=43734 p3=1
WAIT #90: nam='db file sequential read' ela= 509542 p1=1 p2=43741 p3=1
WAIT #105: nam='db file sequential read' ela= 19728 p1=1 p2=39223 p3=1
WAIT #106: nam='db file sequential read' ela= 26314 p1=1 p2=44211 p3=1
WAIT #106: nam='db file sequential read' ela= 8507 p1=1 p2=43570 p3=1
WAIT #90: nam='db file sequential read' ela= 17283 p1=1 p2=41988 p3=1
WAIT #90: nam='db file sequential read' ela= 26075 p1=1 p2=43709 p3=1
WAIT #90: nam='db file sequential read' ela= 5603 p1=1 p2=43710 p3=1
WAIT #90: nam='db file sequential read' ela= 4180 p1=1 p2=43713 p3=1
WAIT #111: nam='db file sequential read' ela= 211522 p1=10 p2=971050 p3=1
WAIT #92: nam='db file sequential read' ela= 270157 p1=1 p2=41133 p3=1
WAIT #19: nam='db file sequential read' ela= 30523 p1=7 p2=851853 p3=1
WAIT #19: nam='db file sequential read' ela= 19038 p1=4 p2=683272 p3=1
WAIT #19: nam='db file sequential read' ela= 60141 p1=4 p2=816145 p3=1
WAIT #19: nam='db file sequential read' ela= 310213 p1=9 p2=782072 p3=1
WAIT #19: nam='db file sequential read' ela= 42823 p1=4 p2=816273 p3=1
WAIT #19: nam='db file sequential read' ela= 60250 p1=9 p2=782200 p3=1
WAIT #106: nam='db file sequential read' ela= 5922 p1=1 p2=43572 p3=1
WAIT #55: nam='db file sequential read' ela= 495940 p1=1 p2=43948 p3=1
WAIT #55: nam='db file sequential read' ela= 29732 p1=1 p2=41964 p3=1
WAIT #55: nam='db file sequential read' ela= 9640 p1=1 p2=39305 p3=1
WAIT #55: nam='db file sequential read' ela= 30550 p1=1 p2=12547 p3=1
WAIT #47: nam='db file sequential read' ela= 385134 p1=9 p2=2119127 p3=1
WAIT #51: nam='db file sequential read' ela= 44536 p1=9 p2=2079255 p3=1
WAIT #105: nam='db file sequential read' ela= 66738 p1=9 p2=2125784 p3=1
WAIT #47: nam='db file sequential read' ela= 19238 p1=9 p2=2070349 p3=1
WAIT #51: nam='db file sequential read' ela= 431991 p1=9 p2=2060564 p3=1
WAIT #51: nam='db file sequential read' ela= 6388 p1=9 p2=2079319 p3=1
WAIT #47: nam='db file sequential read' ela= 12392 p1=9 p2=2069518 p3=1
WAIT #47: nam='db file sequential read' ela= 24752 p1=9 p2=2050893 p3=1
WAIT #47: nam='db file sequential read' ela= 90871 p1=9 p2=2119191 p3=1
WAIT #51: nam='db file sequential read' ela= 30199 p1=9 p2=2012683 p3=1
WAIT #47: nam='db file sequential read' ela= 322581 p1=9 p2=2041300 p3=1
WAIT #105: nam='db file sequential read' ela= 64989 p1=9 p2=1978301 p3=1
WAIT #47: nam='db file sequential read' ela= 342522 p1=9 p2=2119255 p3=1
WAIT #105: nam='db file sequential read' ela= 4636 p1=9 p2=1622252 p3=1
WAIT #105: nam='db file sequential read' ela= 4435 p1=9 p2=1978250 p3=1
WAIT #105: nam='db file sequential read' ela= 20716 p1=9 p2=1848616 p3=1
WAIT #105: nam='db file sequential read' ela= 20129 p1=9 p2=1978139 p3=1
WAIT #105: nam='db file sequential read' ela= 424562 p1=9 p2=1622207 p3=1
WAIT #51: nam='db file sequential read' ela= 6071 p1=9 p2=2079383 p3=1
WAIT #105: nam='db file sequential read' ela= 54402 p1=9 p2=1978491 p3=1
WAIT #47: nam='db file sequential read' ela= 95086 p1=9 p2=2041364 p3=1
WAIT #105: nam='db file sequential read' ela= 195697 p1=9 p2=1978155 p3=1
WAIT #105: nam='db file sequential read' ela= 84077 p1=9 p2=1978729 p3=1
WAIT #47: nam='db file sequential read' ela= 55050 p1=9 p2=2069902 p3=1
WAIT #105: nam='db file sequential read' ela= 21789 p1=9 p2=1848747 p3=1
WAIT #105: nam='db file sequential read' ela= 436414 p1=9 p2=1978803 p3=1
WAIT #105: nam='db file sequential read' ela= 92008 p1=9 p2=1622175 p3=1
WAIT #105: nam='db file sequential read' ela= 11206 p1=7 p2=910309 p3=1
WAIT #105: nam='db file sequential read' ela= 26311 p1=9 p2=1978583 p3=1
WAIT #105: nam='db file sequential read' ela= 5279 p1=9 p2=1978819 p3=1
WAIT #105: nam='db file sequential read' ela= 50150 p1=9 p2=1978518 p3=1
WAIT #105: nam='db file sequential read' ela= 30341 p1=9 p2=1978599 p3=1
WAIT #105: nam='db file sequential read' ela= 160974 p1=9 p2=1978456 p3=1
WAIT #105: nam='db file sequential read' ela= 330604 p1=7 p2=910453 p3=1
WAIT #47: nam='db file sequential read' ela= 55395 p1=9 p2=2050318 p3=1
WAIT #105: nam='db file sequential read' ela= 385893 p1=9 p2=1978649 p3=1
WAIT #105: nam='db file sequential read' ela= 7390 p1=9 p2=1978548 p3=1
WAIT #47: nam='db file sequential read' ela= 18405 p1=9 p2=2127223 p3=1
WAIT #105: nam='db file sequential read' ela= 46244 p1=9 p2=1978371 p3=1
WAIT #105: nam='db file sequential read' ela= 10693 p1=9 p2=1978501 p3=1
WAIT #105: nam='db file sequential read' ela= 699578 p1=9 p2=1978387 p3=1
WAIT #105: nam='db file sequential read' ela= 74558 p1=9 p2=1978778 p3=1
WAIT #47: nam='db file sequential read' ela= 6551 p1=9 p2=2127303 p3=1
WAIT #105: nam='db file sequential read' ela= 18404 p1=9 p2=1978436 p3=1
WAIT #47: nam='db file sequential read' ela= 13642 p1=9 p2=2069391 p3=1
WAIT #105: nam='db file sequential read' ela= 87531 p1=9 p2=1978857 p3=1
WAIT #105: nam='db file sequential read' ela= 29632 p1=9 p2=1978597 p3=1
WAIT #105: nam='db file sequential read' ela= 326072 p1=9 p2=1978851 p3=1
WAIT #105: nam='db file sequential read' ela= 19490 p1=9 p2=1978454 p3=1
WAIT #105: nam='db file sequential read' ela= 22328 p1=9 p2=1978755 p3=1
WAIT #105: nam='db file sequential read' ela= 742990 p1=9 p2=1978745 p3=1
WAIT #51: nam='db file sequential read' ela= 481494 p1=9 p2=2060692 p3=1
WAIT #105: nam='db file sequential read' ela= 139766 p1=4 p2=632175 p3=1
andrey_anonymous
Дата: 26.11.2009 11:49:10
тобобетобор
вот выборка из сырого трэйса:

Это вырезка или grep?
Если не grep, то почему курсоры скачут? Триггеры небось?
тобобетобор
Дата: 26.11.2009 11:49:48
andrey_anonymous
Это вырезка или grep?
grep