跟踪Oracle启动状态

WBOY
发布: 2016-06-07 16:20:39
原创
966 人浏览过

WAIT #140190090045240: nam='db file sequential read' ela= 460 file#=1 block#=520 blocks=1 obj#=-1 tim=1387540363264254 ===================== PARSING IN CURSOR #140190090037016 len=188 dep=1 uid=0 oct=1 lid=0 tim=1387540363332140 hv=4006182

WAIT #140190090045240: nam='db file sequential read' ela= 460 file#=1 block#=520 blocks=1 obj#=-1 tim=1387540363264254

=====================

PARSING IN CURSOR #140190090037016 len=188 dep=1 uid=0 oct=1 lid=0 tim=1387540363332140 hv=4006182593 ad='91871900' sqlid='32r4f1brckzq1'

create table bootstrap$ (

END OF STMT

PARSE #140190090037016:c=9000,e=67806,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim

=1387540363332139

EXEC #140190090037016:c=0,e=17461,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=0,tim=1387540363349678

CLOSE #140190090037016:c=0,e=3,dep=1,type=0,tim=1387540363349760

=====================

PARSING IN CURSOR #140190090037016 len=55 dep=1 uid=0 oct=3 lid=0 tim=1387540363350500 hv=2111436465 ad='9185fc98' sqlid='6apq2rjyxmxpj'

select line#, sql_text from bootstrap$ where obj# != :1

END OF STMT

PARSE #140190090037016:c=999,e=710,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=1387540363350482

 

*** 2013-12-20 19:52:43.430

BINDS #140190090037016:

 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=7f808c8482d0  bln=22  avl=02  flg=05 

  value=59

EXEC #140190090037016:c=2000,e=116005,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=867914364,tim

=1387540363466571

WAIT #140190090037016: nam='db file sequential read' ela= 24 file#=1 block#=520 blocks=1 obj#=59 tim=1387540363466681

相关标签:
来源:php.cn
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板