Bom dia. Também desconfio que é SQL, tem alguns FTS acontecendo, o resto está normal. Confirme com estes SQLs, por favor, e poste aqui.
SET PAGES 1000 SET LINES 170 COL EVENT FORMAT A60 SELECT SID, EVENT, AVERAGE_WAIT, TOTAL_TIMEOUTS FROM V$SESSION_EVENT WHERE TOTAL_TIMEOUTS > 0 AND EVENT NOT LIKE 'SQL*Net%' ORDER BY TOTAL_TIMEOUTS; SELECT SID, EVENT, AVERAGE_WAIT, TOTAL_TIMEOUTS FROM V$SESSION_EVENT WHERE AVERAGE_WAIT > 0 AND EVENT NOT LIKE 'SQL*Net%' ORDER BY AVERAGE_WAIT; SELECT EVENT, AVERAGE_WAIT, TOTAL_TIMEOUTS FROM V$SYSTEM_EVENT WHERE TOTAL_TIMEOUTS > 0 ORDER BY TOTAL_TIMEOUTS; SELECT EVENT, AVERAGE_WAIT, TOTAL_TIMEOUTS FROM V$SYSTEM_EVENT WHERE AVERAGE_WAIT > 0 ORDER BY AVERAGE_WAIT; - Ricardo Portilho Proni http://portilho.profissionaloracle.com.br Em Sex, 2009-05-08 às 11:57 +0000, Anderson Ferreira Rodrigues escreveu: > > > Bom dia Ricardo, > > segue abaixo o resultado: > > SQL> SET PAGESIZE 1000 > SET LINESIZE 170 > COLUMN EVENT FORMAT A50 > SELECT W.SID, W.EVENT, W.SECONDS_IN_WAIT FROM V$SESSION_WAIT W ORDER > BY > W.SECONDS_IN_WAIT, W.SID;SQL> SQL> SQL> 2 > > SID EVENT SECONDS_IN_WAIT > ---------- -------------------------------------------------- > --------------- > 3 rdbms ipc message 0 > 4 rdbms ipc message 0 > 66 SQL*Net message to client 0 > 152 SQL*Net message from client 0 > 170 SQL*Net more data from client 0 > 173 SQL*Net message from client 0 > 189 SQL*Net message from client 0 > 261 SQL*Net message from client 0 > 17 SQL*Net message from client 1 > 25 SQL*Net message from client 1 > 27 SQL*Net message from client 1 > 43 SQL*Net message from client 1 > 65 SQL*Net message from client 1 > 80 SQL*Net message from client 1 > 92 SQL*Net message from client 1 > 93 SQL*Net message from client 1 > 112 SQL*Net message from client 1 > 197 SQL*Net message from client 1 > 200 SQL*Net message from client 1 > 226 SQL*Net message from client 1 > 229 SQL*Net message from client 1 > 234 SQL*Net message from client 1 > 254 SQL*Net message from client 1 > 276 SQL*Net message from client 1 > 5 rdbms ipc message 2 > 159 SQL*Net message from client 2 > 239 SQL*Net message from client 2 > 142 SQL*Net message from client 3 > 249 SQL*Net message from client 3 > 290 SQL*Net message from client 3 > 267 SQL*Net message from client 4 > 363 SQL*Net message from client 4 > 2 rdbms ipc message 5 > 332 SQL*Net message from client 12 > 154 SQL*Net message from client 13 > 96 SQL*Net message from client 15 > 230 SQL*Net message from client 15 > 13 rdbms ipc message 16 > 352 SQL*Net message from client 19 > 59 SQL*Net message from client 20 > 277 SQL*Net message from client 20 > 257 SQL*Net message from client 24 > 129 SQL*Net message from client 25 > 182 SQL*Net message from client 32 > 6 smon timer 38 > 172 SQL*Net message from client 45 > 178 SQL*Net message from client 48 > 348 SQL*Net message from client 56 > 123 SQL*Net message from client 57 > 139 SQL*Net message from client 57 > 20 SQL*Net message from client 60 > 111 SQL*Net message from client 70 > 244 SQL*Net message from client 126 > 210 SQL*Net message from client 149 > 209 SQL*Net message from client 154 > 24 SQL*Net message from client 163 > 116 rdbms ipc message 197 > 149 SQL*Net message from client 236 > 166 SQL*Net message from client 262 > 320 SQL*Net message from client 282 > 22 SQL*Net message from client 285 > 205 SQL*Net message from client 321 > 354 SQL*Net message from client 401 > 306 SQL*Net message from client 405 > 256 SQL*Net message from client 527 > 67 SQL*Net message from client 529 > 36 SQL*Net message from client 621 > 8 rdbms ipc message 784 > 127 SQL*Net message from client 817 > 324 SQL*Net message from client 993 > 88 SQL*Net message from client 1066 > 225 SQL*Net message from client 2220 > 54 SQL*Net message from client 2869 > 259 SQL*Net message from client 2893 > 160 SQL*Net message from client 2912 > 147 SQL*Net message from client 3190 > 198 SQL*Net message from client 3234 > 14 SQL*Net message from client 3585 > 217 SQL*Net message from client 3898 > 7 rdbms ipc message 9136 > 179 SQL*Net message from client 16161 > 86 SQL*Net message from client 53938 > 275 SQL*Net message from client 53938 > 19 SQL*Net message from client 54040 > 1 pmon timer 54131 > 250 SQL*Net message from client 54576 > 46 SQL*Net message from client 56941 > 155 SQL*Net message from client 56975 > 203 SQL*Net message from client 57451 > 72 SQL*Net message from client 57480 > 184 SQL*Net message from client 58311 > 57 SQL*Net message from client 58427 > 270 SQL*Net message from client 58427 > 10 SQL*Net message from client 64968 > 351 SQL*Net message from client 64970 > 45 SQL*Net message from client 66954 > > 96 rows selected. > > ===================================================================== > > SQL> / > > SID EVENT SECONDS_IN_WAIT > ---------- -------------------------------------------------- > --------------- > 4 rdbms ipc message 0 > 27 SQL*Net message from client 0 > 65 SQL*Net message from client 0 > 66 SQL*Net message to client 0 > 82 SQL*Net message from client 0 > 106 SQL*Net message from client 0 > 111 SQL*Net message from client 0 > 173 SQL*Net message from client 0 > 189 SQL*Net message from client 0 > 229 SQL*Net message from client 0 > 239 SQL*Net message from client 0 > 261 SQL*Net message from client 0 > 267 SQL*Net message from client 0 > 316 SQL*Net message from client 0 > 332 SQL*Net message from client 0 > 17 SQL*Net message from client 1 > 93 SQL*Net message from client 1 > 123 SQL*Net message from client 1 > 159 SQL*Net message from client 1 > 197 SQL*Net message from client 1 > 249 SQL*Net message from client 1 > 254 SQL*Net message from client 1 > 5 rdbms ipc message 2 > 129 SQL*Net message from client 2 > 172 SQL*Net message from client 2 > 290 SQL*Net message from client 2 > 170 SQL*Net message from client 3 > 276 SQL*Net message from client 3 > 3 rdbms ipc message 4 > 19 SQL*Net message from client 4 > 25 SQL*Net message from client 4 > 275 SQL*Net message from client 4 > 354 SQL*Net message from client 4 > 2 rdbms ipc message 5 > 96 SQL*Net message from client 5 > 154 SQL*Net message from client 6 > 277 SQL*Net message from client 6 > 312 SQL*Net message from client 6 > 285 SQL*Net message from client 7 > 244 SQL*Net message from client 10 > 230 SQL*Net message from client 13 > 234 SQL*Net message from client 14 > 238 SQL*Net message from client 14 > 16 SQL*Net message from client 16 > 92 SQL*Net message from client 16 > 139 SQL*Net message from client 18 > 142 SQL*Net message from client 18 > 195 SQL*Net message from client 18 > 348 SQL*Net message from client 23 > 178 SQL*Net message from client 27 > 306 SQL*Net message from client 30 > 22 SQL*Net message from client 35 > 67 SQL*Net message from client 45 > 80 SQL*Net message from client 50 > 13 rdbms ipc message 54 > 182 SQL*Net message from client 57 > 43 SQL*Net message from client 58 > 152 SQL*Net message from client 58 > 20 SQL*Net message from client 62 > 350 SQL*Net message from client 62 > 210 SQL*Net message from client 78 > 256 SQL*Net message from client 118 > 352 SQL*Net message from client 122 > 363 SQL*Net message from client 123 > 8 rdbms ipc message 175 > 320 SQL*Net message from client 222 > 257 SQL*Net message from client 273 > 116 rdbms ipc message 295 > 211 SQL*Net message from client 305 > 102 SQL*Net message from client 326 > 137 SQL*Net message from client 393 > 6 smon timer 436 > 209 SQL*Net message from client 552 > 24 SQL*Net message from client 561 > 149 SQL*Net message from client 634 > 166 SQL*Net message from client 660 > 205 SQL*Net message from client 719 > 36 SQL*Net message from client 1019 > 127 SQL*Net message from client 1215 > 324 SQL*Net message from client 1391 > 88 SQL*Net message from client 1464 > 225 SQL*Net message from client 2618 > 54 SQL*Net message from client 3267 > 259 SQL*Net message from client 3291 > 160 SQL*Net message from client 3310 > 147 SQL*Net message from client 3588 > 198 SQL*Net message from client 3632 > 14 SQL*Net message from client 3983 > 217 SQL*Net message from client 4296 > 7 rdbms ipc message 9534 > 179 SQL*Net message from client 16559 > 86 SQL*Net message from client 54336 > 1 pmon timer 54529 > 250 SQL*Net message from client 54974 > 46 SQL*Net message from client 57339 > 155 SQL*Net message from client 57373 > 203 SQL*Net message from client 57849 > 72 SQL*Net message from client 57878 > 184 SQL*Net message from client 58709 > 57 SQL*Net message from client 58825 > 270 SQL*Net message from client 58825 > 10 SQL*Net message from client 65366 > 351 SQL*Net message from client 65368 > 45 SQL*Net message from client 67352 > > 104 rows selected. > > ===================================================================== > > SQL> / > > SID EVENT SECONDS_IN_WAIT > ---------- -------------------------------------------------- > --------------- > 3 rdbms ipc message 0 > 4 rdbms ipc message 0 > 59 SQL*Net message from client 0 > 66 SQL*Net message to client 0 > 159 SQL*Net message from client 0 > 173 SQL*Net message from client 0 > 197 db file scattered read 0 > 220 SQL*Net message from client 0 > 350 db file sequential read 0 > 82 SQL*Net message from client 1 > 112 SQL*Net message from client 1 > 189 SQL*Net message from client 1 > 229 SQL*Net message from client 1 > 230 SQL*Net message from client 1 > 234 SQL*Net message from client 1 > 261 SQL*Net message from client 1 > 267 SQL*Net message from client 1 > 285 SQL*Net message from client 1 > 2 rdbms ipc message 2 > 5 rdbms ipc message 2 > 25 SQL*Net message from client 2 > 27 SQL*Net message from client 2 > 65 SQL*Net message from client 2 > 96 SQL*Net message from client 2 > 106 SQL*Net message from client 2 > 111 SQL*Net message from client 2 > 17 SQL*Net message from client 3 > 170 SQL*Net message from client 3 > 272 SQL*Net message from client 3 > 290 SQL*Net message from client 3 > 226 SQL*Net message from client 4 > 352 SQL*Net message from client 4 > 20 SQL*Net message from client 5 > 93 SQL*Net message from client 5 > 154 SQL*Net message from client 5 > 178 SQL*Net message from client 6 > 139 SQL*Net message from client 7 > 129 SQL*Net message from client 9 > 254 SQL*Net message from client 10 > 92 SQL*Net message from client 12 > 306 SQL*Net message from client 13 > 43 SQL*Net message from client 14 > 152 SQL*Net message from client 14 > 200 SQL*Net message from client 14 > 239 SQL*Net message from client 15 > 67 SQL*Net message from client 16 > 80 SQL*Net message from client 17 > 13 rdbms ipc message 18 > 172 SQL*Net message from client 18 > 116 rdbms ipc message 20 > 19 SQL*Net message from client 21 > 238 SQL*Net message from client 22 > 277 SQL*Net message from client 22 > 312 SQL*Net message from client 22 > 332 SQL*Net message from client 24 > 123 SQL*Net message from client 25 > 249 SQL*Net message from client 25 > 276 SQL*Net message from client 27 > 275 SQL*Net message from client 28 > 354 SQL*Net message from client 28 > 244 SQL*Net message from client 34 > 16 SQL*Net message from client 40 > 142 SQL*Net message from client 42 > 195 SQL*Net message from client 42 > 348 SQL*Net message from client 47 > 22 SQL*Net message from client 59 > 210 SQL*Net message from client 102 > 256 SQL*Net message from client 142 > 363 SQL*Net message from client 147 > 8 rdbms ipc message 199 > 320 SQL*Net message from client 246 > 257 SQL*Net message from client 297 > 211 SQL*Net message from client 329 > 102 SQL*Net message from client 350 > 137 SQL*Net message from client 417 > 6 smon timer 460 > 209 SQL*Net message from client 576 > 24 SQL*Net message from client 585 > 149 SQL*Net message from client 658 > 166 SQL*Net message from client 684 > 205 SQL*Net message from client 743 > 36 SQL*Net message from client 1043 > 127 SQL*Net message from client 1239 > 324 SQL*Net message from client 1415 > 88 SQL*Net message from client 1488 > 225 SQL*Net message from client 2642 > 54 SQL*Net message from client 3291 > 259 SQL*Net message from client 3315 > 160 SQL*Net message from client 3334 > 147 SQL*Net message from client 3612 > 198 SQL*Net message from client 3656 > 14 SQL*Net message from client 4007 > 217 SQL*Net message from client 4320 > 7 rdbms ipc message 9558 > 179 SQL*Net message from client 16583 > 86 SQL*Net message from client 54360 > 1 pmon timer 54553 > 250 SQL*Net message from client 54998 > 46 SQL*Net message from client 57363 > 155 SQL*Net message from client 57397 > 203 SQL*Net message from client 57873 > 72 SQL*Net message from client 57902 > 184 SQL*Net message from client 58733 > 57 SQL*Net message from client 58849 > 270 SQL*Net message from client 58849 > 10 SQL*Net message from client 65390 > 351 SQL*Net message from client 65392 > 45 SQL*Net message from client 67376 > > 108 rows selected. > > abraços, > > --- Em oracle_br@yahoogrupos.com.br, Ricardo Portilho Proni > <porti...@...> escreveu > > > > Mr Anderson... > > > > Pode executar este SQL durante os picos de CPU, e postar aqui? > > De preferência, execute ele três vezes seguidas. > > > > SET PAGESIZE 1000 > > SET LINESIZE 170 > > COLUMN EVENT FORMAT A50 > > SELECT W.SID, W.EVENT, W.SECONDS_IN_WAIT FROM V$SESSION_WAIT W ORDER > BY > > W.SECONDS_IN_WAIT, W.SID; > > > > - > > Ricardo Portilho Proni > > http://portilho.profissionaloracle.com.br > > > > > > > > Em Qui, 2009-05-07 às 18:36 +0000, Anderson Ferreira Rodrigues > escreveu: > > > > > > > > > Senhores, boa tarde, > > > estou com o seguinte problema, uso o Glance e o TOP para realizar > > > monitoramento das máquinas aqui do trabalho, e tb analiso as > sessões e > > > os bloqueios, caso exista, so q tenho notado q mesmo não existindo > > > bloqueios e e pouco user, a CPU fica em 100%, a memoria fica > abaixo de > > > 50%, e temos uma máquina em termos de hardware muito boa, o q > poderia > > > fazer para monitar o q ta ocorrendo? > > > > > > > > > > > > > > > > > > > > > >
