system@ORA10R2> alter session set events '10046 trace name context forever,level 12';
会话已更改。
system@ORA10R2> create view vew_t as select * from ade.t;
视图已创建。
得到Trace file
insert into view$(obj#,cols,audit$,intcols,property,flags,textlength,text)values(:1,:2,:3,:4,:5,:6,:7,:8)
END OF STMT
PARSE #13:c=0,e=1763,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=21356352922
BINDS #13:
kkscoacd
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=087c47e8bln=22avl=04flg=05
value=53663[/COLOR]
Bind#1
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=087c47c4bln=24avl=02flg=05
value=3
Bind#2
oacdty=01 mxl=128(38) mxlc=00 mal=00 scl=00 pre=00
oacflg=18 fl2=0001 frm=01 csi=852 siz=128 off=0
kxsbbbfp=65682260bln=128avl=38flg=09
value="--------------------------------------"
Bind#3
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=087c47a0bln=24avl=02flg=05
value=3
Bind#4
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=087c477cbln=24avl=01flg=05
value=0
Bind#5
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=087c4758bln=24avl=01flg=05
value=0
Bind#6
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=087c4734bln=24avl=02flg=05
value=40
Bind#7
oacdty=01 mxl=128(40) mxlc=00 mal=00 scl=00 pre=00
oacflg=18 fl2=0001 frm=01 csi=852 siz=128 off=0
kxsbbbfp=074830dcbln=128avl=40flg=09
value="select "ENAME","DEPTNO","SAL" from ade.t"
system@ORA10R2> conn system/yqtfln as sysdba
已连接。
sys@ORA10R2> select rowid from view$ where obj#=53663;
ROWID
------------------
AAAAA/AABAAABr5AAE
|