How to track Oracle's startup status

You can use the 10046 event to track

[Oracle@ggos ~]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.4.0 Production on Fri Dec 20 19:48:00 2013

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to a idle instance.

Sql> Startup Mount

ORACLE instance started.

Total System Global area 835104768 bytes

Fixed Size 2257840 bytes

Variable Size 717229136 bytes

Database buffers 113246208 bytes

Redo buffers 2371584 bytes

Database mounted.

Sql> Oradebug Setmypid

Statement processed.

Sql> alter session SET events ' 10046 Trace name context forever,level 12 ';

Session altered.

sql> ALTER DATABASE open;

Database altered.

Sql> Oradebug Tracefile_name

/u01/app/oracle/diag/rdbms/oraprod/oraprod/trace/oraprod_ora_2820.trc

Sql> alter session SET events ' 10046 Trace name context off ';

Session altered.

Sql>

Wait #140190090045240: nam= ' db file sequential read ' ela= 460 file#=1 block#=520 Blocks=1 obj#=-1

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

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

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

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

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=1387540363466681

Can see is loading bootstrap$ table

Sql> Select Dbms_metadata.get_ddl (' TABLE ', ' bootstrap$ ', ' SYS ') from dual;

CREATE TABLE "SYS". bootstrap$ "

("line#" number not NULL ENABLE,

"obj#" number not NULL ENABLE,

' Sql_text ' VARCHAR2 (4000) not NULL ENABLE

) PCTFREE pctused Initrans 1 Maxtrans 255

Nocompress LOGGING

STORAGE (INITIAL 57344 NEXT 1048576 minextents 1 maxextents 2147483645

Pctincrease 0 freelists 1 freelist GROUPS 1

Buffer_pool default Flash_cache default Cell_flash_cache default)

Tablespace "SYSTEM"

Sql> Select owner,object_id from dba_objects where Object_name=upper (' bootstrap$ ');

OWNER object_id

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

SYS 59