connect / drop table t; create table t ( x int ); alter session set events '10046 trace name context forever, level 12'; begin for i in 1 .. 100000 loop insert into t values (i); commit work write immediate wait; end loop; end; / alter session set events '10046 trace name context off Line 103: WAIT #10: nam='log file sync' ela= 341 buffer#=266 p2=0 p3=0 obj#=49449 tim=38464948 Line 114: WAIT #10: nam='log file sync' ela= 356 buffer#=268 p2=0 p3=0 obj#=49449 tim=38466758 Line 125: WAIT #10: nam='log file sync' ela= 338 buffer#=270 p2=0 p3=0 obj#=49449 tim=38468550 Line 136: WAIT #10: nam='log file sync' ela= 361 buffer#=272 p2=0 p3=0 obj#=49449 tim=38470450 Line 147: WAIT #10: nam='log file sync' ela= 367 buffer#=274 p2=0 p3=0 obj#=49449 tim=38472908 Line 158: WAIT #10: nam='log file sync' ela= 356 buffer#=276 p2=0 p3=0 obj#=49449 tim=38474722 Line 169: WAIT #10: nam='log file sync' ela= 341 buffer#=278 p2=0 p3=0 obj#=49449 tim=38475671 Line 180: WAIT #10: nam='log file sync' ela= 341 buffer#=280 p2=0 p3=0 obj#=49449 tim=38476351 Line 191: WAIT #10: nam='log file sync' ela= 324 buffer#=282 p2=0 p3=0 obj#=49449 tim=38477007 Line 202: WAIT #10: nam='log file sync' ela= 323 buffer#=284 p2=0 p3=0 obj#=49449 tim=38477650 Line 213: WAIT #10: nam='log file sync' ela= 342 buffer#=286 p2=0 p3=0 obj#=49449 tim=38478319 Line 224: WAIT #10: nam='log file sync' ela= 323 buffer#=288 p2=0 p3=0 obj#=49449 tim=38478966
如何产生Log File Sync
最新推荐文章于 2022-04-17 18:42:47 发布