Log file sync caused by more commit(二)
2. event: 'SQL*Net message to client'
time waited: 0.000002 sec
wait id: 1775 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #2 and #3: 0.000646 sec
3. event: 'SQL*Net message from client'
time waited: 0.000828 sec
wait id: 1774 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
}
and is blocked by
=> Oracle session identified by:
{
instance: 2 (cedb.cedb2)
os id: 11611
process id: 28, oracle@db42 (LGWR)
session id: 1653
session serial #: 1
}
which is waiting for 'log file parallel write' with wait info:
{
p1: 'files'=0x2
p2: 'blocks'=0x18
p3: 'requests'=0x2
time in wait: 2.999912 sec
timeout after: never
wait id: 309360511
blocking: 6 sessions
current sql:
short stack: ksedsts()+461<-ksdxfstk()+32<-ksdxcb()+1876<-sspuser()+112<-__sighandler()<-read()+16<-kfk_block()+940<-kfk_transit_waitIO()+188<-kf
k_transitIO()+1739<-kfioWaitIO()+721<-kfioRequestPriv()+351<-kfioRequest()+706<-ksfd_kfioRequest()+649<-ksfd_osmbio()+438<-ksfdbio()+1487<-kcrfw_do_write()+98
8<-kcrfw_redo_write()+3449<-ksbabs()+771<-ksbrdp()+971<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+266<-ssthrdmain()+252<-main()+201<-__libc_start
_main()+244<-_start()+36
wait history:
* time between current wait and wait #1: 0.000098 sec
1. event: 'LGWR wait for redo copy'
time waited: 0.000023 sec
wait id: 309360510 p1: 'copy latch #'=0x5
* time between wait #1 and #2: 0.000009 sec
2. event: 'rdbms ipc message'
time waited: 0.001294 sec
wait id: 309360509 p1: 'timeout'=0x13
* time between wait #2 and #3: 0.000040 sec
3. event: 'log file parallel write'
time waited: 0.000293 sec
wait id: 309360508 p1: 'files'=0x2
p2: 'blocks'=0x2
p3: 'requests'=0x2
}
Chain 1 Signature: 'log file parallel write'<='log file sync'
Chain 1 Signature Hash: 0x9a625f43
-------------------------------------------------------------------------------
===============================================================================
Intersecting chains:
-------------------------------------------------------------------------------
Chain 2:
-------------------------------------------------------------------------------
Oracle session identified by:
{
instance: 2 (cedb.cedb2)
os id: 12760
process id: 102, oracle@db42
session id: 2245
session serial #: 1577
}
is waiting for 'log file sync' with wait info:
{
p1: 'buffer#'=0x6f9d
p2: 'sync scn'=0x6f01b311
time in wait: 2.999925 sec
timeout after: never
wait id: 52573
blocking: 0 sessions
current sql:
short stack: ksedsts()+461<-ksdxfstk()+32<-ksdxcb()+1876<-sspuser()+112<-__sighandler()<-semtimedop()+10<-skgpwwait()+160<-ksliwat()+1865<-kslwai
tctx()+163<-kcrf_commit_force()+972<-kcbdsy()+44<-ksupop()+1090<-opiodr()+1008<-ttcpip()+2242<-opitsk()+1673<-opiino()+966<-opiodr()+916<-opidrv()+570<-sou2o(
)+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+244<-_start()+36
wait history:
* time between current wait and wait #1: 0.000240 sec
1. event: 'SQL*Net message from client'
time waited: 0.000985 sec
wait id: 52572 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #1 and #2: 0.000014 sec
2. event: 'SQL*Net message to client'
time waited: 0.000002 sec
wait id: 52571