Tracking Oracle Startup status

You can use the 10046 event to track

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 The

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

wait #140190090045240: nam= ' db file sequential read ' ela= 460 file#=1 k#=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 () 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   & nbsp;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=-file#=1 block#=520 blocks=1 obj#=59 tim=1387 540363466681

Can see is loading bootstrap$ table

?

1 2 3 4 5 6 7 8 9 10 11-12

Sql> Select Dbms_metadata.get_ddl (' TABLE ', ' bootstrap$ ', ' SYS ') from dual; CREATE TABLE "SYS". bootstrap$ "(" line# "number not NULL Enable," obj# "number is not null enable," Sql_text "VARCHAR2 (400 0) Not NULL ENABLE PCTFREE pctused initrans 1 Maxtrans 255 nocompress LOGGING STORAGE (INITIAL 57344 NEXT 104 8576 minextents 1 maxextents 2147483645 pctincrease 0 freelists 1 freelist GROUPS 1 buffer_pool DEFAULT flash_cache DE FAULT cell_flash_cache DEFAULT) tablespace "SYSTEM"

?

1 2 3 4 5

> SQ L> Select owner,object_id from dba_objects where Object_name=upper (' bootstrap$ ');   owner                            object_id---------------------------------------- sys                                     59