--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>