Log file sync caused by more commit
Today, our db changes slow suddenly.
And i do a hang易做图yze as following:
[sql]
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: db42
Release: 2.6.18-164.el5
Version: #1 SMP Thu Sep 3 04:15:13 EDT 2009
Machine: x86_64
Instance name: cedb2
Redo thread mounted by this instance: 2
Oracle process number: 205
Unix process pid: 11618, image: oracle@db42 (TNS V1-V3)
*** 2013-08-28 15:53:14.460
*** SESSION ID:(773.44301) 2013-08-28 15:53:14.460
*** CLIENT ID:() 2013-08-28 15:53:14.460
*** SERVICE NAME:(SYS$USERS) 2013-08-28 15:53:14.460
*** MODULE NAME:(sqlplus@db42 (TNS V1-V3)) 2013-08-28 15:53:14.460
*** ACTION NAME:() 2013-08-28 15:53:14.460
Processing Oradebug command 'hang易做图yze 3'
*** 2013-08-28 15:53:15.164
===============================================================================
HANG ANALYSIS:
instances (db_name.oracle_sid): cedb.cedb2
oradebug_node_dump_level: 3
易做图ysis initiated by oradebug
os thread sche易做图ng delay history: (sampling every 1.000000 secs)
0.000000 secs at [ 15:53:14 ]
NOTE: sche易做图ng delay has not been sampled for 0.294437 secs 0.000000 secs from [ 15:53:10 - 15:53:15 ], 5 sec avg
0.000000 secs from [ 15:52:15 - 15:53:15 ], 1 min avg
0.000000 secs from [ 15:48:15 - 15:53:15 ], 5 min avg
===============================================================================
Chains most likely to have caused the hang:
[a] Chain 1 Signature: 'log file parallel write'<='log file sync'
Chain 1 Signature Hash: 0x9a625f43
[b] Chain 2 Signature: 'log file parallel write'<='log file sync'
Chain 2 Signature Hash: 0x9a625f43
[c] Chain 3 Signature: 'log file parallel write'<='log file sync'
Chain 3 Signature Hash: 0x9a625f43
===============================================================================
Non-intersecting chains:
-------------------------------------------------------------------------------
Chain 1:
-------------------------------------------------------------------------------
Oracle session identified by:
{
instance: 2 (cedb.cedb2)
os id: 10456
process id: 202, oracle@db42
session id: 595
session serial #: 44879
}
is waiting for 'log file sync' with wait info:
{
p1: 'buffer#'=0x6fa9
p2: 'sync scn'=0x6f01c17c
time in wait: 1.268483 sec
timeout after: never
wait id: 1777
blocking: 0 sessions
current sql: <none>
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.000143 sec
1. event: 'SQL*Net message from client'
time waited: 0.001444 sec
wait id: 1776 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #1 and #2: 0.000012 sec
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
