Log file sync caused by more commit(三)
p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #2 and #3: 0.000820 sec
3. event: 'SQL*Net message from client'
time waited: 0.000716 sec
wait id: 52570 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
}
and is blocked by 'instance: 2, os id: 11611, session id: 1653',
which is a member of 'Chain 1'.
Chain 2 Signature: 'log file parallel write'<='log file sync'
Chain 2 Signature Hash: 0x9a625f43
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Chain 3:
-------------------------------------------------------------------------------
Oracle session identified by:
{
instance: 2 (cedb.cedb2)
os id: 12762
process id: 103, oracle@db42
session id: 2304
session serial #: 1077
}
is waiting for 'log file sync' with wait info:
{
p1: 'buffer#'=0x6fa9
p2: 'sync scn'=0x6f01b313
time in wait: 2.999726 sec
timeout after: never
wait id: 54709
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.000175 sec
1. event: 'SQL*Net message from client'
time waited: 0.000301 sec
wait id: 54708 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #1 and #2: 0.000033 sec
2. event: 'SQL*Net message to client'
time waited: 0.000003 sec
wait id: 54707 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #2 and #3: 0.000850 sec
3. event: 'SQL*Net message from client'
time waited: 0.001152 sec
wait id: 54706 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
}
and is blocked by 'instance: 2, os id: 11611, session id: 1653',
which is a member of 'Chain 1'.
Chain 3 Signature: 'log file parallel write'<='log file sync'
Chain 3 Signature Hash: 0x9a625f43
-------------------------------------------------------------------------------
-------------------------------------------------------------------------------
Chain 4:
-------------------------------------------------------------------------------
Oracle session identified by:
{
instance: 2 (cedb.cedb2)
os id: 12764
process id: 104, oracle@db42
session id: 2364
session serial #: 44511
}
is waiting for 'log file sync' with wait info:
{
p1: 'buffer#'=0x6fa9
p2: 'sync scn'=0x6f01b314
time in wait: 2.999371 sec
timeout after: never
wait id: 52571
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.000135 sec
1. event: 'S