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

2014-11-24 17:09:09 · 作者: · 浏览: 15
1/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: bys3.bys.com
Release: 2.6.32-200.13.1.el5uek
Version: #1 SMP Wed Jul 27 20:21:26 EDT 2011
Machine: i686
Instance name: bys3
Redo thread mounted by this instance: 1
Oracle process number: 17
Unix process pid: 13020, image: oracle@bys3.bys.com (TNS V1-V3)

*** 2013-11-29 13:44:59.723
*** SESSION ID:(1.5) 2013-11-29 13:44:59.723
*** CLIENT ID:() 2013-11-29 13:44:59.723
*** SERVICE NAME:() 2013-11-29 13:44:59.723
*** MODULE NAME:(sqlplus@bys3.bys.com (TNS V1-V3)) 2013-11-29 13:44:59.723
*** ACTION NAME:() 2013-11-29 13:44:59.723

WAIT #3064440660: nam='SQL*Net message to client' ela= 10 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1385703899721694

*** 2013-11-29 13:45:05.589
WAIT #3064440660: nam='SQL*Net message from client' ela= 5865444 driver id=1650815232 #bytes=1 p3=0 obj#=-1 tim=1385703905589082
CLOSE #3064440660:c=0,e=28,dep=0,type=1,tim=1385703905590081
XCTEND rlbk=0, rd_only=1, tim=1385703905595227
=====================
PARSING IN CURSOR #3064435524 len=19 dep=0 uid=0 oct=35 lid=0 tim=1385703905623330 hv=1907384048 ad='25eddd7c' sqlid='a01hp0psv0rrh'
alter database open
END OF STMT
PARSE #3064435524:c=12999,e=33127,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1385703905623322
WAIT #3064435524: nam='Disk file operations I/O' ela= 550 FileOperation=2 fileno=0 filetype=1 obj#=-1 tim=1385703905629002
WAIT #3064435524: nam='Disk file operations I/O' ela= 33 FileOperation=2 fileno=1 filetype=1 obj#=-1 tim=1385703905629484
WAIT #3064435524: nam='control file sequential read' ela= 188 file#=0 block#=1 blocks=1 obj#=-1 tim=1385703905629831
WAIT #3064435524: nam='control file sequential read' ela= 47 file#=1 block#=1 blocks=1 obj#=-1 tim=1385703905630128
WAIT #3064435524: nam='control file sequential read' ela= 23 file#=0 block#=8 blocks=1 obj#=-1 tim=1385703905630278
WAIT #3064435524: nam='control file sequential read' ela= 41 file#=0 block#=10 blocks=1 obj#=-1 tim=1385703905630632
WAIT #3064435524: nam='control file sequential read' ela= 39 file#=0 block#=1 blocks=1 obj#=-1 tim=1385703905633356
WAIT #3064435524: nam='control file sequential read' ela= 41 file#=0 block#=8 blocks=1 obj#=-1 tim=1385703905633910
WAIT #3064435524: nam='control file sequential read' ela= 38 file#=0 block#=10 blocks=1 obj#=-1 tim=1385703905634005
WAIT #3064435524: nam='rdbms ipc reply' ela= 60 from_process=10 timeout=910 p3=0 obj#=-1 tim=1385703905637300
WAIT #3064435524: nam='rdbms ipc reply' ela= 127477 from_process=10 timeout=910 p3=0 obj#=-1 tim=1385703905764875
WAIT #3064435524: nam='control file sequential read' ela= 52 file#=0 block#=1 blocks=1 obj#=-1 tim=1385703905765507
WAIT #3064435524: nam='control file sequential read' ela= 43 file#=0 block#=8 blocks=1 obj#=-1 tim=1385703905765632
WAIT #3064435524: nam='control file sequential read' ela= 42 file#=0 block#=10 blocks=1 obj#=-1 tim=1385703905765734
WAIT #3064435524: nam='control file sequential read' ela= 68 file#=0 block#=291 blocks=1 obj#=-1 tim=1385703905765869
WAIT #3064435524: nam='control file sequential read' ela= 40 file#=0 block#=1 blocks=1 obj#=-1 tim=1385703905766297
WAIT #3064435524: nam='control file sequential read' ela= 47 file#=1 block#=1 blocks=1 obj#=-1 tim=1385703905766543
WAIT #3064435524: nam='control file sequential read' ela= 4