可以使用10046 event来跟踪
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
[oracle@ggos ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Productionon 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 Area835104768 bytes
Fixed Size2257840 bytes
Variable Size717229136 bytes
Database Buffers113246208bytes
Redo Buffers2371584bytes
Database mounted.
SQL> oradebug setmypid
Statement processed.
SQL> alter session set events '10046 trace name context forever,level12';
Session altered.
SQL> alter database open;
Database altered.
SQL> oradebugtracefile_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>
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
WAIT #140190090045240: nam='db file sequential read' ela= 460 file#=1 block#=520 blocks=1obj#=-1 tim=1387540363264254
=====================
PARSING IN CURSOR #140190090037016 len=188 dep=1 uid=0 oct=1lid=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=3lid=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=00pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24off=0
kxsbbbfp=7f808c8482d0bln=22avl=02flg=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=1obj#=59 tim=1387540363466681
可以看到是加载BOOTSTRAP$表
?
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 NOT NULL ENABLE,
"SQL_TEXT" VARCHAR2(4000) NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 57344 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM"
?
1
2
3
4
5
SQL> select owner,OBJECT_ID from dba_objects where object_name=upper('bootstrap$');
OWNEROBJECT_ID
----------------------------------------
SYS59