为了保证一致性,数据库在做日志切换的时候是不能做任何DML操作的。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~切换日志时虽然不能进DML操作,但这个动作应该是非常快的呀。
提供部分awr事件以便分析:
1.Top 5 Timed Events
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
CPU time 10,090 76.9
db file sequential read 5,215,788 6,486 1 49.4 User I/O
log file sync 1,278,839 1,335 1 10.2 Commit
log file parallel write 956,228 482 1 3.7 System I/O
library cache pin 719 381 531 2.9 Concurrency
2.Time Model Statistics:
Statistic Name Time (s) % of DB Time
sql execute elapsed time 11,044.83 84.14
DB CPU 10,089.72 76.86
repeated bind elapsed time 66.52 0.51
3.Wait Class:
Wait Class Waits %Time-outs Total Wait Time(s) Avg wait(ms) Waits /tx
User I/O 5,217,848 0.00 6,489 1 4.14
Commit 1,278,839 0.00 1,335 1 1.01
System I/O 971,234 0.00 622 1 0.77
4.Wait Events:
vent Waits %Time-outs Total Wait Time(s) Avg wait(ms) Waits /txn
db file sequential read 5,215,788 0.00 6,486 1 4.14
log file sync 1,278,839 0.00 1,335 1 1.01
log file parallel write 956,228 0.00 482 1 0.76
5.Background Wait Events:
Event Waits %Time-outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 956,228 0.00 482 1 0.76
db file parallel write 12,708 0.00 138 11 0.01
events in waitclass Other 141,312 0.00 3 0 0.11