strace & sqlnet.ora

--sqlnet.ora
TRACE_LEVEL_CLIENT=16
TRACE_FILE_CLIENT=CLIENT
TRACE_TIMESTAMP_CLIENT=ON
trace_directory_client=/home/oracle/product/10g/network/admin

[oracle@VSZ-ORCLE-jftest admin]$ more client_18797.trc
[11-JUL-2014 15:18:10:200] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[11-JUL-2014 15:18:10:200] New trace stream is /home/oracle/product/10g/network/admin/client_18797.trc
[11-JUL-2014 15:18:10:200] New trace level is 16
[11-JUL-2014 15:18:10:200] --- TRACE CONFIGURATION INFORMATION ENDS ---
[11-JUL-2014 15:18:10:200] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
[11-JUL-2014 15:18:10:200] Attempted load of system pfile source /home/oracle/product/10g/network/admin/sqlnet.ora

[11-JUL-2014 15:18:10:204] sntpcall: not detaching from parent with additional fork
[11-JUL-2014 15:18:10:204] sntpcall: Signal handler for SIGCHLD installed
[11-JUL-2014 15:18:10:205] sntpcall: hdl[IR]=11, hdl[IW]=10
[11-JUL-2014 15:18:10:904] sntpcall: result string is NTP0 18798 [很慢]
[11-JUL-2014 15:18:10:904] sntpcall: exit

[oracle@VSZ-ORCLE-jftest ~]$ strace -T -o hj.txt sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jul 11 15:20:15 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@VSZ-ORCLE-jftest ~]$
[oracle@VSZ-ORCLE-jftest ~]$ less hj.txt
close(9)                                = 0 <0.000007>
close(13)                               = 0 <0.000007>
lseek(7, 0, SEEK_CUR)                   = 9748 <0.000007>
write(7, "[11-JUL-2014 15:21:49:244] sntpc"..., 37) = 37 <0.000010>
write(7, "hdl[IR]=12, hdl[IW]=11\n", 23) = 23 <0.000010>

read(12, "NTP0 18824\n", 64)            = 11 <0.631114>  【其实这里不利于问题的解决】
lseek(7, 0, SEEK_CUR)                   = 9808 <0.000008>
write(7, "[11-JUL-2014 15:21:49:875] sntpc"..., 37) = 37 <0.000012>
write(7, "result string is NTP0 18824\n", 28) = 28 <0.000010>
lseek(7, 0, SEEK_CUR)                   = 9873 <0.000008>
write(7, "[11-JUL-2014 15:21:49:875] sntpc"..., 37) = 37 <0.000012>

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值