跟踪Oracle启动状态
来源:互联网 发布:五十岁而知天命 编辑:程序博客网 时间:2024/05/24 03:43
可以使用10046 event来跟踪
[oracle@ggos ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 20 19:48:00 2013Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup mountORACLE instance started.Total System Global Area 835104768 bytesFixed Size 2257840 bytesVariable Size 717229136 bytesDatabase Buffers 113246208 bytesRedo Buffers 2371584 bytesDatabase mounted.SQL> oradebug setmypidStatement 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.trcSQL> 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=1387540363332139EXEC #140190090037016:c=0,e=17461,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=0,tim=1387540363349678CLOSE #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# != :1END 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.430BINDS #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=59EXEC #140190090037016:c=2000,e=116005,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=867914364,tim=1387540363466571WAIT #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
0 0
- 跟踪Oracle启动状态
- Oracle的启动状态
- ORACLE启动到NOMOUNT状态
- oracle启动的四个状态
- 如何查看oracle启动状态
- oracle启动的四个状态
- oracle启动的四个状态
- 00045.Oracle启动数据库、设置数据库状态
- Windows 下逐状态启动 Oracle数据库
- oracle的三种启动状态
- 跟踪用户状态
- 跟踪状态(TASK_TRACED)
- newlisp跟踪jobtracker状态
- 04-跟踪用户状态
- Web应用程序状态跟踪
- InventTrans中的状态跟踪
- Oracle 几种启动方式 & 查询启动状态
- Yii2 启动跟踪记录
- 数学之美系列二:谈谈中文分词
- 轻松搞定面试中的二叉树题目
- ActiveRecord 验证及回调函数callback
- 现在优化软件概述--引自浙大江爱朋博士论文
- Java笔记
- 跟踪Oracle启动状态
- DeepLearnToolbox_DBN notes
- rails 单表继承 观察者
- 2013视觉跟踪的初学者
- SWT、Swing 或 AWT:哪个更适合您?
- 《人月神话》读书笔记
- 通过继承CWinThread实现MFC多线程
- scrollview 中嵌套 edittext edit无法获取焦点的解决办法
- window下NDK详细配置及如何编译 .