« 数据库架构设计与性能优化实践 技术交流会 | Blog首页 | Oracle数据恢复:ORA-600 4097错误解决案例一则 »

Oracle队列等待: enq: IS - contention 阻塞启动

PARSING IN CURSOR #1 len=20 dep=0 uid=0 oct=35 lid=0 tim=1996856932 hv=1361353028 ad='33ecfc5c'

alter database open

END OF STMT

PARSE #1:c=0,e=55194,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=1996856924

BINDS #1:

WAIT #1: nam='enq: IS - contention' ela= 2999928 name|mode=1230176262 0=0 type=1 obj#=-1 tim=1999862398

WAIT #1: nam='enq: IS - contention' ela= 3000194 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2002886571

WAIT #1: nam='enq: IS - contention' ela= 3000147 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2005887755

*** 2011-07-15 09:19:25.797

WAIT #1: nam='enq: IS - contention' ela= 3000175 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2008888928

WAIT #1: nam='enq: IS - contention' ela= 2999845 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2011890945

WAIT #1: nam='enq: IS - contention' ela= 2999919 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2014892245

WAIT #1: nam='enq: IS - contention' ela= 3000160 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2017893430

*** 2011-07-15 09:19:37.803

WAIT #1: nam='enq: IS - contention' ela= 3000097 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2020894541

WAIT #1: nam='enq: IS - contention' ela= 2999605 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2023895772

WAIT #1: nam='enq: IS - contention' ela= 3000207 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2026896973

WAIT #1: nam='enq: IS - contention' ela= 3000061 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2029898088

*** 2011-07-15 09:19:49.806

WAIT #1: nam='enq: IS - contention' ela= 2999260 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2032898062

WAIT #1: nam='enq: IS - contention' ela= 2999582 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2035899453

WAIT #1: nam='enq: IS - contention' ela= 3000204 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2038900628

WAIT #1: nam='enq: IS - contention' ela= 2999892 name|mode=1230176262 0=0 type=1 obj#=-1 tim=2041901560

SQL> select KSQSTTYP,KSQSTEXPL from x$ksqst where KSQSTTYP='IS';

KS KSQSTEXPL

-- --------------------------------------------------------------------------------

IS Enqueue used to synchronize instance state changes

PARSING IN CURSOR #3 len=142 dep=3 uid=0 oct=3 lid=0 tim=14891728852 hv=361892850 ad='33edaafc'

select /*+ rule */ name,file#,block#,status$,user#,undosqn,xactsqn,scnbas,scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1

END OF STMT

PARSE #3:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=3,tim=14891728848

BINDS #3:

kkscoacd

Bind#0

  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

  oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

  kxsbbbfp=054d1860  bln=22  avl=02  flg=05

  value=7

EXEC #3:c=0,e=174,p=0,cr=0,cu=0,mis=0,r=0,dep=3,og=3,tim=14891729170

WAIT #3: nam='row cache lock' ela= 2999602 cache id=3 mode=0 request=3 obj#=-1 tim=14894728832

WAIT #3: nam='row cache lock' ela= 2999768 cache id=3 mode=0 request=3 obj#=-1 tim=14897728773

WAIT #3: nam='row cache lock' ela= 3000277 cache id=3 mode=0 request=3 obj#=-1 tim=14900729179

*** 2011-07-15 12:54:20.637

WAIT #3: nam='row cache lock' ela= 3000060 cache id=3 mode=0 request=3 obj#=-1 tim=14903729401

WAIT #3: nam='row cache lock' ela= 2999894 cache id=3 mode=0 request=3 obj#=-1 tim=14906729519

By eygle on 2011-07-18 08:38 | Comments (0) | FAQ | 2843 |

Wait