使用10046事件查看数据库OPEN时从root dba到bootstrap$的详细引导过程(六)

2014-11-24 17:09:09 · 作者: · 浏览: 17
read' ela= 41 file#=0 block#=1 blocks=1 obj#=-1 tim=1385703907143570
WAIT #3064435524: nam='control file sequential read' ela= 39 file#=0 block#=8 blocks=1 obj#=-1 tim=1385703907143651
WAIT #3064435524: nam='control file sequential read' ela= 43 file#=0 block#=10 blocks=1 obj#=-1 tim=1385703907143739
WAIT #3064435524: nam='control file sequential read' ela= 40 file#=0 block#=292 blocks=1 obj#=-1 tim=1385703907143821
WAIT #3064435524: nam='control file sequential read' ela= 41 file#=0 block#=1 blocks=1 obj#=-1 tim=1385703907143944
WAIT #3064435524: nam='control file sequential read' ela= 40 file#=0 block#=8 blocks=1 obj#=-1 tim=1385703907144025
WAIT #3064435524: nam='control file sequential read' ela= 42 file#=0 block#=10 blocks=1 obj#=-1 tim=1385703907144110
WAIT #3064435524: nam='control file sequential read' ela= 40 file#=0 block#=292 blocks=1 obj#=-1 tim=1385703907144192
WAIT #3064435524: nam='control file sequential read' ela= 44 file#=0 block#=1 blocks=1 obj#=-1 tim=1385703907148808
WAIT #3064435524: nam='control file sequential read' ela= 49 file#=0 block#=8 blocks=1 obj#=-1 tim=1385703907148929
WAIT #3064435524: nam='control file sequential read' ela= 40 file#=0 block#=10 blocks=1 obj#=-1 tim=1385703907149011
WAIT #3064435524: nam='control file sequential read' ela= 43 file#=0 block#=292 blocks=1 obj#=-1 tim=1385703907149094
WAIT #3064435524: nam='db file sequential read' ela= 264 file#=1 block#=520blocks=1 obj#=-1 tim=1385703907158975
=====================
PARSING IN CURSOR #3064429824 len=188 dep=1 uid=0 oct=1 lid=0 tim=1385703907172599 hv=4006182593 ad='257ea26c' sqlid='32r4f1brckzq1'
create table bootstrap$ (
END OF STMT
PARSE #3064429824:c=5999,e=11363,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=1385703907172594
EXEC #3064429824:c=2000,e=16397,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=0,tim=1385703907191131
CLOSE #3064429824:c=1000,e=36,dep=1,type=0,tim=1385703907191434
=====================
PARSING IN CURSOR #3064429824 len=55 dep=1 uid=0 oct=3 lid=0 tim=1385703907195679 hv=2111436465 ad='257e8e88' sqlid='6apq2rjyxmxpj'
select line#, sql_text from bootstrap$ where obj# != :1
END OF STMT
PARSE #3064429824:c=2999,e=4055,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=1385703907195675
BINDS #3064429824:
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=b6a778d0 bln=22 avl=02 flg=05
value=59
EXEC #3064429824:c=7999,e=47324,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=867914364,tim=1385703907244586
WAIT #3064429824: nam='db file sequential read' ela= 246 file#=1 block#=520 blocks=1 obj#=59 tim=1385703907245408
WAIT #3064429824: nam='db file scattered read' ela= 470 file#=1 block#=521 blocks=3 obj#=59 tim=1385703907248639
FETCH #3064429824:c=3999,e=7831,p=4,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=867914364,tim=1385703907252714
FETCH #3064429824:c=0,e=45,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,plh=867914364,tim=1385703907252920
FETCH #3064429824:c=0,e=10,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,plh=867914364,tim=1385703907252978
FETCH #3064429824:c=0,e=10,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,plh=867914364,tim=1385703907253032
FETCH #3064429824:c=0,e=9,p=0,cr=1,cu=0,mis=0,r=1,dep=1,og=4,plh=867914364,tim=1385703907253089
FETCH #3064429824: