Disk file operations I/O / Oracle

ReSQL.ru

Мобильная версия Контакт Правила FAQ Помощь

Гость

Войти | Регистрация | Профиль | Очистить

Новые сообщения | Избранное

Форумы | Пользователи | Статистика | Мод. лог | Поиск

Доб. в избранное | Игнор. тему | Прикреп. тему | Пометить прочит. / непрочит. | Фильтр

Форумы / Oracle [игнор отключен] [закрыт для гостей] / Disk file operations I/O

15 сообщений из 15, страница 1 из 1

Disk file operations I/O

#39632536

AlexFF__|

Участник

Сообщения: 2 776

Рейтинг: 0 / 0

Привет всем.

Кто сталкивался с Disk file operations I/O p1=9 (read from snapshot files)?
При вставке в таблицу ожидания db file sequential read и Disk file operations I/O идут нога в ногу.
Как-то так:

WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 9 FileOperation=2 fileno=570 filetype=2 obj#=373115 tim=14742071056574
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 2 FileOperation=2 fileno=570 filetype=2 obj#=373115 tim=14742071056602
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 44 FileOperation=2 fileno=570 filetype=2 obj#=373115 tim=14742071056616
WAIT #11529215044981140888: nam='db file sequential read' ela= 1349 file#=570 block#=3853056 blocks=1 obj#=373115 tim=14742071057991
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 20350 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071078374
WAIT #11529215044981140888: nam='db file sequential read' ela= 111 file#=570 block#=3853100 blocks=1 obj#=373115 tim=14742071078557
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4223 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071082800
WAIT #11529215044981140888: nam='db file sequential read' ela= 285 file#=570 block#=3853116 blocks=1 obj#=373115 tim=14742071083202
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 2662 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071085884
WAIT #11529215044981140888: nam='db file sequential read' ela= 7752 file#=570 block#=3853132 blocks=1 obj#=373115 tim=14742071093684
WAIT #11529215044981140888: nam='db file sequential read' ela= 119 file#=570 block#=3853148 blocks=1 obj#=373115 tim=14742071093859
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3903 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071097781
WAIT #11529215044981140888: nam='db file sequential read' ela= 114 file#=570 block#=3853212 blocks=1 obj#=373115 tim=14742071097962
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 19112 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071117093
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853228 blocks=1 obj#=373115 tim=14742071117260
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4426 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071121705
WAIT #11529215044981140888: nam='db file sequential read' ela= 187 file#=570 block#=3853276 blocks=1 obj#=373115 tim=14742071121947
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 7822 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071129789
WAIT #11529215044981140888: nam='db file sequential read' ela= 114 file#=570 block#=3853292 blocks=1 obj#=373115 tim=14742071129961
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3735 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071133715
WAIT #11529215044981140888: nam='db file sequential read' ela= 94 file#=570 block#=3853069 blocks=1 obj#=373115 tim=14742071133876
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3763 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071137685
WAIT #11529215044981140888: nam='db file sequential read' ela= 88 file#=570 block#=3853085 blocks=1 obj#=373115 tim=14742071137821
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4096 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071141935
WAIT #11529215044981140888: nam='db file sequential read' ela= 1998 file#=570 block#=3853101 blocks=1 obj#=373115 tim=14742071143992
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 2138 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071146150
WAIT #11529215044981140888: nam='db file sequential read' ela= 3610 file#=570 block#=3853149 blocks=1 obj#=373115 tim=14742071149808
WAIT #11529215044981140888: nam='db file sequential read' ela= 109 file#=570 block#=3853181 blocks=1 obj#=373115 tim=14742071150096
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3385 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071153500
WAIT #11529215044981140888: nam='db file sequential read' ela= 102 file#=570 block#=3853197 blocks=1 obj#=373115 tim=14742071153644
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 9612 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071163275
WAIT #11529215044981140888: nam='db file sequential read' ela= 1376 file#=570 block#=3853213 blocks=1 obj#=373115 tim=14742071164700
WAIT #11529215044981140888: nam='db file sequential read' ela= 113 file#=570 block#=3853229 blocks=1 obj#=373115 tim=14742071164856
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 2232 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071167107
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853245 blocks=1 obj#=373115 tim=14742071167252
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1362 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071168633
WAIT #11529215044981140888: nam='db file sequential read' ela= 88 file#=570 block#=3853261 blocks=1 obj#=373115 tim=14742071168761
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 5902 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071174682
WAIT #11529215044981140888: nam='db file sequential read' ela= 87 file#=570 block#=3853293 blocks=1 obj#=373115 tim=14742071174818
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1147 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071175984
WAIT #11529215044981140888: nam='db file sequential read' ela= 115 file#=570 block#=3853309 blocks=1 obj#=373115 tim=14742071176139
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 874 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071177032
WAIT #11529215044981140888: nam='db file sequential read' ela= 98 file#=570 block#=3853070 blocks=1 obj#=373115 tim=14742071177178
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1075 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071178272
WAIT #11529215044981140888: nam='db file sequential read' ela= 70 file#=570 block#=3853086 blocks=1 obj#=373115 tim=14742071178381
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1060 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071179460
WAIT #11529215044981140888: nam='db file sequential read' ela= 94 file#=570 block#=3853102 blocks=1 obj#=373115 tim=14742071179599
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1155 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071180773
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853118 blocks=1 obj#=373115 tim=14742071180926
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1043 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071181988
WAIT #11529215044981140888: nam='db file sequential read' ela= 107 file#=570 block#=3853134 blocks=1 obj#=373115 tim=14742071182135
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1134 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071183303
WAIT #11529215044981140888: nam='db file sequential read' ela= 87 file#=570 block#=3853150 blocks=1 obj#=373115 tim=14742071183431
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 972 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071184422
WAIT #11529215044981140888: nam='db file sequential read' ela= 86 file#=570 block#=3853166 blocks=1 obj#=373115 tim=14742071184548
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 981 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071185547
WAIT #11529215044981140888: nam='db file sequential read' ela= 119 file#=570 block#=3853182 blocks=1 obj#=373115 tim=14742071185715
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1132 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071186866
WAIT #11529215044981140888: nam='db file sequential read' ela= 102 file#=570 block#=3853214 blocks=1 obj#=373115 tim=14742071187040
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1024 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071188084
WAIT #11529215044981140888: nam='db file sequential read' ela= 109 file#=570 block#=3853230 blocks=1 obj#=373115 tim=14742071188245
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1126 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071189391
WAIT #11529215044981140888: nam='db file sequential read' ela= 204 file#=570 block#=3853262 blocks=1 obj#=373115 tim=14742071189649
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1086 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071190757
WAIT #11529215044981140888: nam='db file sequential read' ela= 386 file#=570 block#=3853310 blocks=1 obj#=373115 tim=14742071191195
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 418 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071191643
WAIT #11529215044981140888: nam='db file sequential read' ela= 102 file#=570 block#=3853103 blocks=1 obj#=373115 tim=14742071191802
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1357 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071193179
WAIT #11529215044981140888: nam='db file sequential read' ela= 83 file#=570 block#=3853119 blocks=1 obj#=373115 tim=14742071193310
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1063 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071194392
WAIT #11529215044981140888: nam='db file sequential read' ela= 108 file#=570 block#=3853135 blocks=1 obj#=373115 tim=14742071194547
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 837 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071195403
WAIT #11529215044981140888: nam='db file sequential read' ela= 100 file#=570 block#=3853151 blocks=1 obj#=373115 tim=14742071195615
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1723 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071197358
WAIT #11529215044981140888: nam='db file sequential read' ela= 102 file#=570 block#=3853167 blocks=1 obj#=373115 tim=14742071197522
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4808 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071202350
WAIT #11529215044981140888: nam='db file sequential read' ela= 118 file#=570 block#=3853183 blocks=1 obj#=373115 tim=14742071202573
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 837 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071203433
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853199 blocks=1 obj#=373115 tim=14742071203589
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1219 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071204828
WAIT #11529215044981140888: nam='db file sequential read' ela= 366 file#=570 block#=3853215 blocks=1 obj#=373115 tim=14742071205250
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1398 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071206706
WAIT #11529215044981140888: nam='db file sequential read' ela= 98 file#=570 block#=3853231 blocks=1 obj#=373115 tim=14742071206868
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 992 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071207881
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853247 blocks=1 obj#=373115 tim=14742071208035
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1067 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071209121
WAIT #11529215044981140888: nam='db file sequential read' ela= 96 file#=570 block#=3853279 blocks=1 obj#=373115 tim=14742071209264
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1183 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071210466
WAIT #11529215044981140888: nam='db file sequential read' ela= 98 file#=570 block#=3853295 blocks=1 obj#=373115 tim=14742071210613
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1425 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071212057
WAIT #11529215044981140888: nam='db file sequential read' ela= 94 file#=570 block#=3853311 blocks=1 obj#=373115 tim=14742071212198
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 532 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071212749
WAIT #11529215044981140888: nam='db file sequential read' ela= 88 file#=570 block#=3853072 blocks=1 obj#=373115 tim=14742071212889
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 566 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071213474
WAIT #11529215044981140888: nam='db file sequential read' ela= 103 file#=570 block#=3853088 blocks=1 obj#=373115 tim=14742071213641
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 602 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071214262
WAIT #11529215044981140888: nam='db file sequential read' ela= 148 file#=570 block#=3853104 blocks=1 obj#=373115 tim=14742071214456
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 626 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071215102
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853136 blocks=1 obj#=373115 tim=14742071215246
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 9517 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071224783
WAIT #11529215044981140888: nam='db file sequential read' ela= 122 file#=570 block#=3853152 blocks=1 obj#=373115 tim=14742071225009
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 630 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071225660
WAIT #11529215044981140888: nam='db file sequential read' ela= 131 file#=570 block#=3853168 blocks=1 obj#=373115 tim=14742071225836
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 453 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071226308
WAIT #11529215044981140888: nam='db file sequential read' ela= 113 file#=570 block#=3853232 blocks=1 obj#=373115 tim=14742071226466
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1185 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071227670
WAIT #11529215044981140888: nam='db file sequential read' ela= 190 file#=570 block#=3853248 blocks=1 obj#=373115 tim=14742071227900
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3972 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071231891
WAIT #11529215044981140888: nam='db file sequential read' ela= 108 file#=570 block#=3853264 blocks=1 obj#=373115 tim=14742071232041
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 445 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071232505
WAIT #11529215044981140888: nam='db file sequential read' ela= 83 file#=570 block#=3853280 blocks=1 obj#=373115 tim=14742071232629
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 616 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071233264
WAIT #11529215044981140888: nam='db file sequential read' ela= 134 file#=570 block#=3853296 blocks=1 obj#=373115 tim=14742071233468
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 535 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071234022
WAIT #11529215044981140888: nam='db file sequential read' ela= 82 file#=570 block#=3853073 blocks=1 obj#=373115 tim=14742071234144
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 331 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071234494
WAIT #11529215044981140888: nam='db file sequential read' ela= 103 file#=570 block#=3853105 blocks=1 obj#=373115 tim=14742071234635
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 585 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071235239
WAIT #11529215044981140888: nam='db file sequential read' ela= 98 file#=570 block#=3853121 blocks=1 obj#=373115 tim=14742071235377
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 603 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071235999
WAIT #11529215044981140888: nam='db file sequential read' ela= 83 file#=570 block#=3853137 blocks=1 obj#=373115 tim=14742071236122
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 356 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071236496
WAIT #11529215044981140888: nam='db file sequential read' ela= 109 file#=570 block#=3853153 blocks=1 obj#=373115 tim=14742071236647
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 645 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071237311
WAIT #11529215044981140888: nam='db file sequential read' ela= 99 file#=570 block#=3853169 blocks=1 obj#=373115 tim=14742071237455
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 343 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071237817
WAIT #11529215044981140888: nam='db file sequential read' ela= 85 file#=570 block#=3853185 blocks=1 obj#=373115 tim=14742071237955
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 454 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071238428
WAIT #11529215044981140888: nam='db file sequential read' ela= 97 file#=570 block#=3853201 blocks=1 obj#=373115 tim=14742071238565
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 393 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071238977
WAIT #11529215044981140888: nam='db file sequential read' ela= 100 file#=570 block#=3853217 blocks=1 obj#=373115 tim=14742071239117
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 704 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071239840
WAIT #11529215044981140888: nam='db file sequential read' ela= 100 file#=570 block#=3853265 blocks=1 obj#=373115 tim=14742071239981
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 526 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071240526
WAIT #11529215044981140888: nam='db file sequential read' ela= 95 file#=570 block#=3853281 blocks=1 obj#=373115 tim=14742071240673
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 366 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071241057
WAIT #11529215044981140888: nam='db file sequential read' ela= 83 file#=570 block#=3853297 blocks=1 obj#=373115 tim=14742071241180
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 329 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071241528
WAIT #11529215044981140888: nam='db file sequential read' ela= 106 file#=570 block#=3853058 blocks=1 obj#=373115 tim=14742071241687
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1223 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071242929
WAIT #11529215044981140888: nam='db file sequential read' ela= 75 file#=570 block#=3853074 blocks=1 obj#=373115 tim=14742071243045
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 472 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071243536
WAIT #11529215044981140888: nam='db file sequential read' ela= 95 file#=570 block#=3853090 blocks=1 obj#=373115 tim=14742071243688
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 371 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071244077
WAIT #11529215044981140888: nam='db file sequential read' ela= 95 file#=570 block#=3853106 blocks=1 obj#=373115 tim=14742071244212
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 423 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071244653
WAIT #11529215044981140888: nam='db file sequential read' ela= 109 file#=570 block#=3853122 blocks=1 obj#=373115 tim=14742071244807
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 396 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071245222
WAIT #11529215044981140888: nam='db file sequential read' ela= 101 file#=570 block#=3853138 blocks=1 obj#=373115 tim=14742071245368
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 582 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071245969
WAIT #11529215044981140888: nam='db file sequential read' ela= 95 file#=570 block#=3853154 blocks=1 obj#=373115 tim=14742071246109
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 493 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071246621
WAIT #11529215044981140888: nam='db file sequential read' ela= 82 file#=570 block#=3853170 blocks=1 obj#=373115 tim=14742071246744
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 621 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071247384
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853186 blocks=1 obj#=373115 tim=14742071247527
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 396 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071247942
WAIT #11529215044981140888: nam='db file sequential read' ela= 99 file#=570 block#=3853202 blocks=1 obj#=373115 tim=14742071248080
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 500 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071248598
WAIT #11529215044981140888: nam='db file sequential read' ela= 86 file#=570 block#=3853218 blocks=1 obj#=373115 tim=14742071248730
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 510 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071249258
WAIT #11529215044981140888: nam='db file sequential read' ela= 93 file#=570 block#=3853234 blocks=1 obj#=373115 tim=14742071249396
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 1613 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071251028
WAIT #11529215044981140888: nam='db file sequential read' ela= 97 file#=570 block#=3853250 blocks=1 obj#=373115 tim=14742071251166
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 356 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071251541
WAIT #11529215044981140888: nam='db file sequential read' ela= 97 file#=570 block#=3853266 blocks=1 obj#=373115 tim=14742071251682
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 723 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071252424
WAIT #11529215044981140888: nam='db file sequential read' ela= 101 file#=570 block#=3853282 blocks=1 obj#=373115 tim=14742071252579
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 603 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071253203
WAIT #11529215044981140888: nam='db file sequential read' ela= 996 file#=570 block#=3853059 blocks=1 obj#=373115 tim=14742071254244
WAIT #11529215044981140888: nam='db file sequential read' ela= 75 file#=570 block#=3853075 blocks=1 obj#=373115 tim=14742071254386
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 520 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071254926
WAIT #11529215044981140888: nam='db file sequential read' ela= 95 file#=570 block#=3853091 blocks=1 obj#=373115 tim=14742071255070
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 611 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071255700
WAIT #11529215044981140888: nam='db file sequential read' ela= 97 file#=570 block#=3853107 blocks=1 obj#=373115 tim=14742071255863
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 665 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071256547
WAIT #11529215044981140888: nam='db file sequential read' ela= 84 file#=570 block#=3853123 blocks=1 obj#=373115 tim=14742071256678
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4702 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071261398
WAIT #11529215044981140888: nam='db file sequential read' ela= 442 file#=570 block#=3853139 blocks=1 obj#=373115 tim=14742071262032
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 24505 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071286564
WAIT #11529215044981140888: nam='db file sequential read' ela= 106 file#=570 block#=3853155 blocks=1 obj#=373115 tim=14742071286784
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4174 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071290979
WAIT #11529215044981140888: nam='db file sequential read' ela= 109 file#=570 block#=3853171 blocks=1 obj#=373115 tim=14742071291146
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 14820 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071305985
WAIT #11529215044981140888: nam='db file sequential read' ela= 195 file#=570 block#=3853187 blocks=1 obj#=373115 tim=14742071306255
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 7566 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071313840
WAIT #11529215044981140888: nam='db file sequential read' ela= 118 file#=570 block#=3853203 blocks=1 obj#=373115 tim=14742071314013
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4331 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071318363
WAIT #11529215044981140888: nam='db file sequential read' ela= 153 file#=570 block#=3853235 blocks=1 obj#=373115 tim=14742071318587
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 7136 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071325741
WAIT #11529215044981140888: nam='db file sequential read' ela= 114 file#=570 block#=3853251 blocks=1 obj#=373115 tim=14742071325940
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3936 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071329899
WAIT #11529215044981140888: nam='db file sequential read' ela= 99 file#=570 block#=3853283 blocks=1 obj#=373115 tim=14742071330051
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4301 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071334372
WAIT #11529215044981140888: nam='db file sequential read' ela= 102 file#=570 block#=3853299 blocks=1 obj#=373115 tim=14742071334522
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3560 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071338101
WAIT #11529215044981140888: nam='db file sequential read' ela= 105 file#=570 block#=3853060 blocks=1 obj#=373115 tim=14742071338253
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 104 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071338375
WAIT #11529215044981140888: nam='db file sequential read' ela= 105 file#=570 block#=3853076 blocks=1 obj#=373115 tim=14742071338526
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3916 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071342460
WAIT #11529215044981140888: nam='db file sequential read' ela= 109 file#=570 block#=3853092 blocks=1 obj#=373115 tim=14742071342627
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3808 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071346453
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853140 blocks=1 obj#=373115 tim=14742071346606
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3746 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071350371
WAIT #11529215044981140888: nam='db file sequential read' ela= 134 file#=570 block#=3853172 blocks=1 obj#=373115 tim=14742071350593
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3506 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071354119
WAIT #11529215044981140888: nam='db file sequential read' ela= 103 file#=570 block#=3853188 blocks=1 obj#=373115 tim=14742071354269
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3846 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071358134
WAIT #11529215044981140888: nam='db file sequential read' ela= 115 file#=570 block#=3853204 blocks=1 obj#=373115 tim=14742071358295
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4134 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071362448
WAIT #11529215044981140888: nam='db file sequential read' ela= 108 file#=570 block#=3853220 blocks=1 obj#=373115 tim=14742071362609
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3766 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071366395
WAIT #11529215044981140888: nam='db file sequential read' ela= 113 file#=570 block#=3853236 blocks=1 obj#=373115 tim=14742071366575
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 7260 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071373855
WAIT #11529215044981140888: nam='db file sequential read' ela= 104 file#=570 block#=3853252 blocks=1 obj#=373115 tim=14742071374009
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4141 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071378169
WAIT #11529215044981140888: nam='db file sequential read' ela= 92 file#=570 block#=3853284 blocks=1 obj#=373115 tim=14742071378307
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 11647 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071389973
WAIT #11529215044981140888: nam='db file sequential read' ela= 116 file#=570 block#=3853300 blocks=1 obj#=373115 tim=14742071390144
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 691 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071390854
WAIT #11529215044981140888: nam='db file sequential read' ela= 82 file#=570 block#=3853077 blocks=1 obj#=373115 tim=14742071390986
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 26728 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071417733
WAIT #11529215044981140888: nam='db file sequential read' ela= 125 file#=570 block#=3853093 blocks=1 obj#=373115 tim=14742071417924
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 8317 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071426261
WAIT #11529215044981140888: nam='db file sequential read' ela= 108 file#=570 block#=3853125 blocks=1 obj#=373115 tim=14742071426443
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3756 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071430218
WAIT #11529215044981140888: nam='db file sequential read' ela= 149 file#=570 block#=3853141 blocks=1 obj#=373115 tim=14742071430413
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3826 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071434258
WAIT #11529215044981140888: nam='db file sequential read' ela= 142 file#=570 block#=3853189 blocks=1 obj#=373115 tim=14742071434446
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 3583 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071438048
WAIT #11529215044981140888: nam='db file sequential read' ela= 94 file#=570 block#=3853205 blocks=1 obj#=373115 tim=14742071438188
WAIT #11529215044981140888: nam='Disk file operations I/O' ela= 4055 FileOperation=9 fileno=570 filetype=2 obj#=373115 tim=14742071442263

...

Рейтинг:

0 / 0

18.04.2018, 14:43

| Ответить | Цитировать | Написать

Disk file operations I/O

#39632566

Вячеслав Любомудров

Участник

Откуда: Владивосток

Сообщения: 18 655

Рейтинг: 0 / 0

Как предположение -- в BEGIN BACKUP никто не остался?

...

Рейтинг:

0 / 0

18.04.2018, 15:08

| Ответить | Цитировать | Написать

Disk file operations I/O

#39632589

AlexFF__|

Участник

Сообщения: 2 776

Рейтинг: 0 / 0

Вячеслав ЛюбомудровКак предположение -- в BEGIN BACKUP никто не остался?
Нет )

...

Рейтинг:

0 / 0

18.04.2018, 15:21

| Ответить | Цитировать | Написать

Disk file operations I/O

#39632590

Aliona

Участник

Откуда: Питер

Сообщения: 3 524

Рейтинг: 0 / 0

AlexFF__|,
а чё выдают команды ОС по производительности дисков, например sar -d ?

...

Рейтинг:

0 / 0

18.04.2018, 15:22

| Ответить | Цитировать | Написать

Disk file operations I/O

#39632602

AlexFF__|

Участник

Сообщения: 2 776

Рейтинг: 0 / 0

AlionaAlexFF__|,
а чё выдают команды ОС по производительности дисков, например sar -d ?
Хост будет только завтра, меня просто попросили посмотреть одним глазком, "что у нас происходит, простые запросы встают".
Есть доступ к oracle, правда с весьма широкими полномочиями, типа трейсов и системных представлений.

...

Рейтинг:

0 / 0

18.04.2018, 15:31

| Ответить | Цитировать | Написать

Disk file operations I/O

#39632617

Aliona

Участник

Откуда: Питер

Сообщения: 3 524

Рейтинг: 0 / 0

Одним глазком или сразу двумя начинать надо с команд ОС :)
Зачем что-то в оракл анализировать, если диск сдох.

...

Рейтинг:

0 / 0

18.04.2018, 15:46

| Ответить | Цитировать | Написать

Disk file operations I/O

#39632619

AlexFF__|

Участник

Сообщения: 2 776

Рейтинг: 0 / 0

AlionaОдним глазком или сразу двумя начинать надо с команд ОС :)
Зачем что-то в оракл анализировать, если диск сдох.
Ты думаешь, Disk file operations I/O p1=9 (read from snapshot files) - это сигнал к плохим дискам?
Немного сомнительно.
Да, БД несерьезная, никто за ней не следит, но хост мощный, на нем стоят еще несколько БД и если бы что-то было бы с ними - шухер бы поднялся и админы бы приехали.

...

Рейтинг:

0 / 0

18.04.2018, 15:52

| Ответить | Цитировать | Написать

Disk file operations I/O

#39632680

Sayan Malakshinov

Модератор форума

Откуда: Мск

Сообщения: 5 731

Рейтинг: 0 / 0

AlexFF__|,

сталкивался с такой фигней где-то полгода назад, но точных параметров не помню, на виндовом сервачке из-за работающего Commvault clbackup

...

Рейтинг:

0 / 0

18.04.2018, 16:54

| Ответить | Цитировать | Написать

Период между сообщениями больше года.

Disk file operations I/O

#39880056

mlc

Участник

Откуда: Asus Winter Cup

Сообщения: 468

Рейтинг: 0 / 0

апну тему.
Вменяемый запрос долго висит на Disk file operations I/O:

Код: plsql

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.

SESSION EVENT                         WAIT_CLASS               CNT    PERCENT
------- ----------------------------- ----------------- ---------- ----------
WAITING Disk file operations I/O      User I/O                   5         83
WAITING db file scattered read        User I/O                   1         17

2 rows selected. 

EVENT                          P1TEXT                         P1 P1VALUE                       P2TEXT               P2 P3TEXT                   P3 P3VALUE                                                                                   
------------------------------ ---------------------- ---------- ----------------------------- ------------ ---------- ---------------- ---------- -------------
Disk file operations I/O       FileOperation                   9 read from snapshot files      fileno              395 filetype                  2 Data File                                                                                 
Disk file operations I/O       FileOperation                   9 read from snapshot files      fileno              395 filetype                  2 Data File                                                                                 
Disk file operations I/O       FileOperation                   9 read from snapshot files      fileno              391 filetype                  2 Data File                                                                                 
Disk file operations I/O       FileOperation                   9 read from snapshot files      fileno                2 filetype                  2 Data File                                                                                 
Disk file operations I/O       FileOperation                   9 read from snapshot files      fileno                2 filetype                  2 Data File                                                                                 
db file scattered read         file#                           2                               block#          1588032 blocks                    8                                                                                           

6 rows selected.

Кто сталкивался?

...

Рейтинг:

0 / 0

22.10.2019, 17:10

| Ответить | Цитировать | Написать

Disk file operations I/O

#39880125

Vivat!San

Участник

Откуда: Москва

Сообщения: 527

Рейтинг: 0 / 0

Ждёт ресайз файла, проверь файлы с автоинкрементом на слишком маленький инкремент.

...

Рейтинг:

0 / 0

22.10.2019, 20:55

| Ответить | Цитировать | Написать

Disk file operations I/O

#39880214

Elic

Участник

Сообщения: 30 360

Рейтинг: 0 / 0

mlcзапросVivat!SanЖдёт ресайз файлаС логикой не раздружился?

...

Рейтинг:

0 / 0

23.10.2019, 07:36

| Ответить | Цитировать | Написать

Disk file operations I/O

#39880327

mlc

Участник

Откуда: Asus Winter Cup

Сообщения: 468

Рейтинг: 0 / 0

Elic,

нет идей с чем може быть связано?

...

Рейтинг:

0 / 0

23.10.2019, 11:06

| Ответить | Цитировать | Написать

Disk file operations I/O

#39880351

Vivat!San

Участник

Откуда: Москва

Сообщения: 527

Рейтинг: 0 / 0

ElicС логикой не раздружился?
нет
нет идей с чем може быть связано?

...

Рейтинг:

0 / 0

23.10.2019, 11:43

| Ответить | Цитировать | Написать

Disk file operations I/O

#39880352

Vivat!San

Участник

Откуда: Москва

Сообщения: 527

Рейтинг: 0 / 0

mlc
нет идей с чем може быть связано?

На Оракл Саппорт ходил или сразу сюда по привычке?

...

Рейтинг:

0 / 0

23.10.2019, 11:44

| Ответить | Цитировать | Написать

Disk file operations I/O

#39880367

mlc

Участник

Откуда: Asus Winter Cup

Сообщения: 468

Рейтинг: 0 / 0

Vivat!San,

Ушел на саппорт.

...

Рейтинг:

0 / 0

23.10.2019, 11:55

| Ответить | Цитировать | Написать

15 сообщений из 15, страница 1 из 1

Форумы / Oracle [игнор отключен] [закрыт для гостей] / Disk file operations I/O

Цитировать

Написать

Автор*:

Ввести пароль для входа

Тема*:

Сообщение

Данное сообщение тематическое

Сообщение содержит картинки или видео 18+

Автор:

ВНИМАНИЕ! На данном подфоруме действуют строгие правила. Удостоверьтесь, что ваше сообщение соответствует им!

Форум или тема закрыты для гостей. Необходима авторизация!

Загрузить последнюю сохраненную версию

Вложение:

Вставить как галерею

Максимальный размер вложений: 4,0 МБ, аудио/видео: 8,0 МБ. Картинки большего размера ужимаются, если возможно.

Введите код, изображенный на картинке. Если код нечитаемый, кликните картинку, чтобы загрузить другой вариант.

Отправляя сообщение, я выражаю свое согласие с правилами форума и принимаю пользовательское соглашение.

Читали тему (0):

Читали форум (0):

Пользователи онлайн (0):

start [/forum/topic.php?fid=52&msg=39632619&tid=1881946]:	0ms
get settings:	10ms
get forum list:	13ms
check forum access:	3ms
check topic access:	3ms
track hit:	69ms
get topic data:	10ms
get forum data:	2ms
get page messages:	48ms
get tp. blocked users:	1ms
others:	259ms

total:	418ms