威凡网全力打造:网页编程、软件开发编程、平面设计、服务器端开发、操作系统等在线学习平台!学编程,上威凡网!
PHP教程>> PHP基础 PHP技巧 PHP实例 PHP文摘 PHP模板 PHP总结
当前位置:首页 > PHP教程 > PHP总结
上一节 下一节
 OracleSQLTrace几种不同方法示例

[oracle@dex ~]$ ps-aef | grep oracledex oracle 5687 5681 0 apr05 ? 00:00:00 oracledex(description=(local=yes)(address =(protocol=beq))) oracle 6750 1 0 apr05 ? 00:00:01 oracledex (local=no) oracle 7785 1 0 apr05 ? 00:00:00 oracledex (local

[oracle@dex ~]$ ps-aef | grep oracledex

oracle 5687 5681 0 apr05 ? 00:00:00 oracledex(description=(local=yes)(address

=(protocol=beq)))

oracle 6750 1 0 apr05 ? 00:00:01 oracledex (local=no)

oracle 7785 1 0 apr05 ? 00:00:00 oracledex (local=no)

oracle 20421 9560 0 09:35 ? 00:00:00 oracledex(description=(local=yes)(address

=(protocol=beq)))

oracle 20482 1 009:37 ? 00:00:00 oracledex(local=no)

oracle 20518 9234 0 09:40 pts/8 00:00:00 grep oracledex

sys@dex11g> oradebug setospid 5687

oracle pid: 25, unix process pid: 5687, image: oracle@dex (tnsv1-v3)

sys@dex11g> oradebug event 10046 trace name context forever ,level 12 ;

statement processed.

scott@dex11g> select * from tab ;

tname tabtype clusterid

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

bonus table

dept table

emp table

salgrade table

就会在trace文件中看到相应的trace

select count(*) from emp

end of stmt

parse#47316048750480:c=30996,e=154507,p=3,cr=34,cu=0,mis=1,r=0,dep=0,og=1,plh=2937609675

,tim=1365212576667998

exec#47316048750480:c=0,e=53,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2937609675,tim

=1365212576668227

wait #47316048750480: nam='sql*net message to client' ela= 11 driverid=1650815232 #bytes

=1 p3=0 obj#=40 tim=1365212576668455

fetch #47316048750480:c=999,e=21005,p=0,cr=1,cu=0,mis=0,r=1,dep=0,og=1,plh=2937609675,tim

=

1365212576689528

stat #47316048750480 id=1 cnt=1 pid=0 pos=1 obj=0 op='sort aggregate(cr=1 pr=0 pw=

0 time=20996 us)'

stat #47316048750480 id=2 cnt=15 pid=1 pos=1 obj=75336 op='indexfull scan pk_emp (cr=1 pr=0 pw=0 time=20960 us cost=1 size=0 card=15)'

wait #47316048750480: nam='sql*net message from client' ela= 560driver id=1650815232

#bytes=1 p3=0 obj#=40 tim=1365212576690779

fetch #47316048750480:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=2937609675,tim

=1365212576690879

wait #47316048750480: nam='sql*net message to client' ela= 6 driverid=1650815232

#bytes=1 p3=0 obj#=40 tim=1365212576690934

wait #47316048750480: nam='sql*net message from client' ela= 834driver id=16508

15232 #bytes=1 p3=0 obj#=40 tim=1365212576691804

parse#47316048799960:c=0,e=75,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=

1365212576691987

binds #47316048799960:

bind#0

oacdty=123 mxl=4000(4000)mxlc=00 mal=00 scl=00 pre=00

oacflg=00 fl2=1000000 frm=00csi=00 siz=4000 off=0

toid ptr value=87b716c0 length=16

ad26de2f1f4c7c06e0431e4ee50ab7b3

kxsbbbfp=2b08a050c4d0 bln=4000 avl=00 flg=15

bind#1

oacdty=02 mxl=22(22) mxlc=00mal=00 scl=00 pre=00

oacflg=01 fl2=1000000 frm=00csi=00 siz=24 off=0

kxsbbbfp=2b08a054bb00 bln=22 avl=22 flg=05

value=###

an invalid number has beenseen.memory contents are :

dump of memory from 0x00002b08a054bb00 to 0x00002b08a054bb16

2b08a054bb00 000010c1 00000000 00000000 00000000 [................]

2b08a054bb10 00000000 00000000 [........]

wait #47316048799960: nam='sql*net message to client' ela= 9 driverid=1650815232 #bytes=1

p3=0 obj#=40 tim=1365212576693088

exec#47316048799960:c=999,e=1002,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=13652

12576693170

关闭

sys@dex11g> oradebug event 10046 trace name context off ;

statement processed.


申明:本教程内容由威凡网编辑整理并提供IT程序员分享学习,如文中有侵权行为,请与站长联系(QQ:254677821)!
上一节 下一节
相关教程  
其他教程  
PHP基础
PHP技巧
PHP实例
PHP文摘
PHP模板
PHP总结

违法和不良信息举报中心】邮箱:254677821@qq.com
Copyright©威凡网 版权所有 苏ICP备2023020142号
站长QQ:254677821