跟踪Oracle启动状态

nbvf

可以使用10046 event来跟踪
[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 an 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 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  

可以看到是加载BOOTSTRAP$表
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 10 PCTUSED 40 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  

zrong

如果我的真诚对你来说是种谎言的话，那我宁愿选择沉默