这是我用select * from v$system_event看了一下的结果
VENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------------------------------------------------------- ----------- -------------- ----------- ------------ -----------------
latch free 912 197 97 0 969900
pmon timer 48068 48066 19061833 397 1.9062E+11
process startup 2 0 1 0 7470
rdbms ipc reply 100 1 335 3 3346408
rdbms ipc message 196390 187260 85794502 437 8.5795E+11
enqueue 2 0 1 0 5267
async disk IO 5 0 6 1 64512
reliable message 1 0 1 1 11151
control file sequential read 18559 0 31395 2 313950808
control file parallel write 45645 0 199099 4 1990994318
refresh controlfile command 1 0 6 6 61540
control file heartbeat 1 1 410 410 4095691
free buffer waits 15 15 1534 102 15342596
checkpoint completed 1 0 89 89 890671
buffer busy waits 10722 0 13913 1 139132866
recovery read 2 0 0 0 6
log file sequential read 22 0 33 2 334009
log file single write 17 0 32 2 316543
log file parallel write 18048 12317 52846 3 528464329
LGWR wait for redo copy 276 0 0 0 3618
log buffer space 894 0 6640 7 66399850
log file switch completion 13 0 287 22 2868085
log file sync 391 15 3095 8 30950401
db file sequential read 157184 0 75959 0 759589715
db file scattered read 57834661 0 66614360 1 6.6614E+11
db file single write 41 0 101 2 1011081
db file parallel write 11698 5784 73593 6 735926034
db file parallel read 51 0 298 6 2977178
direct path read 1449 0 2498 2 24981675
direct path write 375 0 287 1 2872353
undo segment extension 306 305 0 0 2844
instance state change 2 0 0 0 42
smon timer 479 451 18181219 37957 1.8181E+11
PX Deq: Txn Recovery Start 6 0 172 29 1719929
wait for stopper event to be increased 10 6 79 8 791058
row cache lock 3 0 8 3 80743
library cache pin 13 0 165 13 1646366
library cache load lock 8 2 744 93 7435115
virtual circuit status 4739 4739 18971744 4003 1.8972E+11
dispatcher timer 2369 2369 18883350 7971 1.8883E+11
jobq slave wait 15503 15019 7676857 495 7.6769E+10
PX Idle Wait 587 592 120349 205 1203488038
PX Deq: Join ACK 2 0 0 0 376
PX Deq: Signal ACK 4 0 1 0 11149
SQL*Net message to client 585188 0 44 0 435391
SQL*Net more data to client 151469 0 187 0 1868533
SQL*Net message from client 585184 0 8088459 14 8.0885E+10
SQL*Net more data from client 11 0 0 0 108
SQL*Net break/reset to client 12 0 27 2 268194
wakeup time manager 4477 4475 18518252 4136 1.8518E+11
VENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------------------------------------------------------- ----------- -------------- ----------- ------------ -----------------
latch free 912 197 97 0 969900
pmon timer 48068 48066 19061833 397 1.9062E+11
process startup 2 0 1 0 7470
rdbms ipc reply 100 1 335 3 3346408
rdbms ipc message 196390 187260 85794502 437 8.5795E+11
enqueue 2 0 1 0 5267
async disk IO 5 0 6 1 64512
reliable message 1 0 1 1 11151
control file sequential read 18559 0 31395 2 313950808
control file parallel write 45645 0 199099 4 1990994318
refresh controlfile command 1 0 6 6 61540
control file heartbeat 1 1 410 410 4095691
free buffer waits 15 15 1534 102 15342596
checkpoint completed 1 0 89 89 890671
buffer busy waits 10722 0 13913 1 139132866
recovery read 2 0 0 0 6
log file sequential read 22 0 33 2 334009
log file single write 17 0 32 2 316543
log file parallel write 18048 12317 52846 3 528464329
LGWR wait for redo copy 276 0 0 0 3618
log buffer space 894 0 6640 7 66399850
log file switch completion 13 0 287 22 2868085
log file sync 391 15 3095 8 30950401
db file sequential read 157184 0 75959 0 759589715
db file scattered read 57834661 0 66614360 1 6.6614E+11
db file single write 41 0 101 2 1011081
db file parallel write 11698 5784 73593 6 735926034
db file parallel read 51 0 298 6 2977178
direct path read 1449 0 2498 2 24981675
direct path write 375 0 287 1 2872353
undo segment extension 306 305 0 0 2844
instance state change 2 0 0 0 42
smon timer 479 451 18181219 37957 1.8181E+11
PX Deq: Txn Recovery Start 6 0 172 29 1719929
wait for stopper event to be increased 10 6 79 8 791058
row cache lock 3 0 8 3 80743
library cache pin 13 0 165 13 1646366
library cache load lock 8 2 744 93 7435115
virtual circuit status 4739 4739 18971744 4003 1.8972E+11
dispatcher timer 2369 2369 18883350 7971 1.8883E+11
jobq slave wait 15503 15019 7676857 495 7.6769E+10
PX Idle Wait 587 592 120349 205 1203488038
PX Deq: Join ACK 2 0 0 0 376
PX Deq: Signal ACK 4 0 1 0 11149
SQL*Net message to client 585188 0 44 0 435391
SQL*Net more data to client 151469 0 187 0 1868533
SQL*Net message from client 585184 0 8088459 14 8.0885E+10
SQL*Net more data from client 11 0 0 0 108
SQL*Net break/reset to client 12 0 27 2 268194
wakeup time manager 4477 4475 18518252 4136 1.8518E+11
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货