EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO EVENT_ID WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS
---------------------------------------------------------------- ----------- -------------- ----------- ------------ ----------------- ---------- ------------- ----------- ----------------------------------------------------------------
log file switch completion 196 10 3390 17.3 33902312 3834950329 3290255840 2 Configuration
log file sync 258891 14 134182 0.52 1341818537 1328744198 3386400367 5 Commit
db file sequential read 8073889 0 767440 0.1 7674399749 2652584166 1740759767 8 User I/O
db file scattered read 22309757 0 1153637 0.05 11536371092 506183215 1740759767 8 User I/O
db file single write 7 0 6 0.88 61559 1307477558 1740759767 8 User I/O
db file parallel read 7444 0 50066 6.73 500662788 834992820 1740759767 8 User I/O
direct path read 2024315 0 1426 0 14263788 3926164927 1740759767 8 User I/O
direct path read temp 165443 0 97 0 967235 861319509 1740759767 8 User I/O
direct path write 9582 0 3 0 26953 885859547 1740759767 8 User I/O
direct path write temp 54713 0 25 0 250575 38438084 1740759767 8 User I/O
enq: HW - contention 2 0 1 0.28 5571 1645217925 3290255840 2 Configuration
enq: TX - row lock contention 2 0 1 0.27 5401 310662678 4217450380 1 Application
enq: TX - index contention 2 0 3 1.26 25205 1035026728 3875070507 4 Concurrency
smon timer 11991 8889 263676750 21989.55 2636767501611 1403232821 2723168908 6 Idle
latch: In memory undo latch 1 0 1 1.1 10970 1394127552 3875070507 4 Concurrency
latch: row cache objects 190 0 377 1.98 3770220 1117386924 3875070507 4 Concurrency
row cache lock 9 0 6 0.65 58386 1714089451 3875070507 4 Concurrency
latch: shared pool 1518 0 658 0.43 6575421 2696347763 3875070507 4 Concurrency
latch: library cache 3819 0 5466 1.43 54655543 589947255 3875070507 4 Concurrency
latch: library cache lock 29 0 67 2.32 672239 2032051689 3875070507 4 Concurrency
latch: library cache pin 72 0 16 0.22 159017 1242501677 3875070507 4 Concurrency
---------------------------------------------------------------- ----------- -------------- ----------- ------------ ----------------- ---------- ------------- ----------- ----------------------------------------------------------------
log file switch completion 196 10 3390 17.3 33902312 3834950329 3290255840 2 Configuration
log file sync 258891 14 134182 0.52 1341818537 1328744198 3386400367 5 Commit
db file sequential read 8073889 0 767440 0.1 7674399749 2652584166 1740759767 8 User I/O
db file scattered read 22309757 0 1153637 0.05 11536371092 506183215 1740759767 8 User I/O
db file single write 7 0 6 0.88 61559 1307477558 1740759767 8 User I/O
db file parallel read 7444 0 50066 6.73 500662788 834992820 1740759767 8 User I/O
direct path read 2024315 0 1426 0 14263788 3926164927 1740759767 8 User I/O
direct path read temp 165443 0 97 0 967235 861319509 1740759767 8 User I/O
direct path write 9582 0 3 0 26953 885859547 1740759767 8 User I/O
direct path write temp 54713 0 25 0 250575 38438084 1740759767 8 User I/O
enq: HW - contention 2 0 1 0.28 5571 1645217925 3290255840 2 Configuration
enq: TX - row lock contention 2 0 1 0.27 5401 310662678 4217450380 1 Application
enq: TX - index contention 2 0 3 1.26 25205 1035026728 3875070507 4 Concurrency
smon timer 11991 8889 263676750 21989.55 2636767501611 1403232821 2723168908 6 Idle
latch: In memory undo latch 1 0 1 1.1 10970 1394127552 3875070507 4 Concurrency
latch: row cache objects 190 0 377 1.98 3770220 1117386924 3875070507 4 Concurrency
row cache lock 9 0 6 0.65 58386 1714089451 3875070507 4 Concurrency
latch: shared pool 1518 0 658 0.43 6575421 2696347763 3875070507 4 Concurrency
latch: library cache 3819 0 5466 1.43 54655543 589947255 3875070507 4 Concurrency
latch: library cache lock 29 0 67 2.32 672239 2032051689 3875070507 4 Concurrency
latch: library cache pin 72 0 16 0.22 159017 1242501677 3875070507 4 Concurrency
解决方案 »
- 有关oracle的更新语句，求教！在线等
- oracle 11g 为什么安装到9%就没反应。
- Oracle 10 express edition 新建的表，为什么用sql语句没法查询
- 在线等 oracle 数据库树型表的模糊查询
- EditPlus 2的配置,及监控API对Oracle的操作，记录SQL语句的原理！
- 100分请教在ORACLE9I中怎么启用分区特性,小弟急用在线等待.......
- 关于ALL_OBJECTS的奇怪问题
- 求教！关于双游标嵌套使用
- 关于update语句的优化
- 各位高手，能不能把下面三句SELECT语句合为一句
- 存储过程
- 现在需要把一个表中的行变成列，如果写一个函数的话，这个函数应该怎么写？
---------------------------------------------------------------- ----------- -------------- ----------- ------------ ----------------- ---------- ------------- ----------- ----------------------------------------------------------------
library cache pin 147 0 956 6.5 9558385 2802704141 3875070507 4 Concurrency
library cache lock 9 0 221 24.52 2206563 916468430 3875070507 4 Concurrency
library cache load lock 18 0 117 6.5 1169884 2952162927 3875070507 4 Concurrency
virtual circuit status 93058 93057 271717253 2919.87 2717172532946 3618703989 2723168908 6 Idle
dispatcher timer 46529 46529 270785714 5819.72 2707857144553 4090013609 2723168908 6 Idle
jobq slave wait 864396 860477 252584082 292.21 2525840822284 782339817 2723168908 6 Idle
SQL*Net message to client 235863566 0 52118 0 521179082 2067390145 2000153315 7 Network
SQL*Net more data to client 24008406 0 160353 0.01 1603528679 554161347 2000153315 7 Network
SQL*Net message from client 235863450 0 1435262339 6.09 14352623388442 1421975091 2723168908 6 Idle
SQL*Net more data from client 1742076 0 3172 0 31722017 3530226808 2000153315 7 Network
SQL*Net break/reset to client 754 0 65 0.09 651785 1963888671 4217450380 1 Application
Streams AQ: waiting for time management or cleanup tasks 35519 21609 238233186 6707.2 2382331861545 3702640206 2723168908 6 Idle
Streams AQ: qmn coordinator idle wait 200825 101539 271787516 1353.35 2717875161090 989870553 2723168908 6 Idle
Streams AQ: qmn slave idle wait 99551 0 271784981 2730.11 2717849809326 1830121438 2723168908 6 Idle
latch free 2089 0 3444 1.65 34440432 3474287957 1893977003 0 Other
latch: session allocation 213 0 259 1.22 2590377 2900750527 1893977003 0 Other
enq: PR - contention 3 0 13 4.42 132526 3733307663 1893977003 0 Other
latch: messages 34 0 0 0.01 4292 1973577887 1893977003 0 Other
rdbms ipc reply 2268 0 1300 0.57 13002368 2587381521 1893977003 0 Other
latch: enqueue hash chains 34 0 7 0.21 72842 1847483002 1893977003 0 Other
reliable message 123 0 14 0.11 136041 906644781 1893977003 0 OtherEVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO EVENT_ID WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS
---------------------------------------------------------------- ----------- -------------- ----------- ------------ ----------------- ---------- ------------- ----------- ----------------------------------------------------------------
SGA: allocation forcing component growth 114 20 116 1.02 1160252 3493282803 1893977003 0 Other
control file heartbeat 1 1 390 390.4 3904002 40893507 1893977003 0 Other
enq: CF - contention 2 0 88 43.8 875970 1494394835 1893977003 0 Other
buffer exterminate 93 59 6839 73.54 68388701 2332720660 1893977003 0 Other
latch: cache buffers lru chain 1518 0 816 0.54 8162938 3401628503 1893977003 0 Other
latch: checkpoint queue latch 1 0 0 0 31 22066106 1893977003 0 Other
latch: object queue header operation 59 0 9 0.16 94345 295718413 1893977003 0 Other
LGWR wait for redo copy 22318 1442 2393 0.11 23933818 4266849434 1893977003 0 Other
latch: redo allocation 491 0 41 0.08 413198 266850936 1893977003 0 Other
latch: undo global data 6 0 16 2.67 160203 2221529869 1893977003 0 Other
instance state change 2 0 0 0.13 2543 1525267497 1893977003 0 Other
kksfbc child completion 1 1 5 4.79 47867 2679325 1893977003 0 Other
Streams AQ: qmn coordinator waiting for slave to start 2 1 489 244.35 4887078 1565566389 1893977003 0 Other
enq: JS - queue lock 12 0 57 4.78 573235 306423829 1893977003 0 Other76 rows selectedSQL>