# echo 0 >| /proc/sys/kernel/vsyscall64
# time strace -c ./gtod
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
99.84 0.095268 0 1000000 gettimeofday
0.16 0.000152 19 8 mmap
0.00 0.000000 0 1 read
0.00 0.000000 0 2 open
0.00 0.000000 0 2 close
0.00 0.000000 0 2 fstat
0.00 0.000000 0 3 mprotect
0.00 0.000000 0 1 munmap
0.00 0.000000 0 1 brk
0.00 0.000000 0 1 1 access
0.00 0.000000 0 1 execve
0.00 0.000000 0 1 arch_prctl
------ ----------- ----------- --------- --------- ----------------
100.00 0.095420 1000023 1 total
real 0m33.072s
user 0m4.665s
sys 0m32.098s
# echo 1 >| /proc/sys/kernel/vsyscall64
# time strace -c ./gtod
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
-nan 0.000000 0 1 read
-nan 0.000000 0 2 open
-nan 0.000000 0 2 close
-nan 0.000000 0 2 fstat
-nan 0.000000 0 8 mmap
-nan 0.000000 0 3 mprotect
-nan 0.000000 0 1 munmap
-nan 0.000000 0 1 brk
-nan 0.000000 0 1 1 access
-nan 0.000000 0 1 execve
-nan 0.000000 0 1 arch_prctl
------ ----------- ----------- --------- --------- ----------------
100.00 0.000000 23 1 total
real 0m0.065s
user 0m0.062s
sys 0m0.003s
# echo 2 >| /proc/sys/kernel/vsyscall64
# cat /proc/sys/kernel/vsyscall64
2
# time strace -c ./gtod
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
-nan 0.000000 0 1 read
-nan 0.000000 0 2 open
-nan 0.000000 0 2 close
-nan 0.000000 0 2 fstat
-nan 0.000000 0 8 mmap
-nan 0.000000 0 3 mprotect
-nan 0.000000 0 1 munmap
-nan 0.000000 0 1 brk
-nan 0.000000 0 1 1 access
-nan 0.000000 0 1 execve
-nan 0.000000 0 1 arch_prctl
------ ----------- ----------- --------- --------- ----------------
100.00 0.000000 23 1 total
real 0m0.066s
user 0m0.064s
sys 0m0.001s
# echo 0 >| /proc/sys/kernel/vsyscall64
$ time strace -f -c sqlplus system/xxxx @/tmp/a.sql
...
Elapsed: 00:00:22.18
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
65.63 0.106459 2 60292 read
16.42 0.026644 0 251228 gettimeofday
7.22 0.011710 0 111292 getrusage
7.12 0.011548 0 60117 write
3.54 0.005747 0 60220 times
0.02 0.000031 1 34 munmap
0.01 0.000021 0 223 113 open
0.01 0.000020 0 159 mmap
0.01 0.000019 0 53 rt_sigaction
0.01 0.000014 0 125 close
0.01 0.000010 0 96 lseek
0.00 0.000000 0 49 36 stat
0.00 0.000000 0 55 fstat
0.00 0.000000 0 65 mprotect
0.00 0.000000 0 16 brk
0.00 0.000000 0 18 rt_sigprocmask
0.00 0.000000 0 3 ioctl
0.00 0.000000 0 21 14 access
0.00 0.000000 0 2 pipe
0.00 0.000000 0 16 14 shmget
0.00 0.000000 0 2 shmat
0.00 0.000000 0 1 shmctl
0.00 0.000000 0 2 dup
0.00 0.000000 0 9 socket
0.00 0.000000 0 8 8 connect
0.00 0.000000 0 1 bind
0.00 0.000000 0 1 getsockname
0.00 0.000000 0 1 1 getpeername
0.00 0.000000 0 2 getsockopt
0.00 0.000000 0 1 clone
0.00 0.000000 0 2 execve
0.00 0.000000 0 7 uname
0.00 0.000000 0 2 semctl
0.00 0.000000 0 2 shmdt
0.00 0.000000 0 29 fcntl
0.00 0.000000 0 6 getdents
0.00 0.000000 0 5 getcwd
0.00 0.000000 0 1 chdir
0.00 0.000000 0 3 readlink
0.00 0.000000 0 2 umask
0.00 0.000000 0 9 getrlimit
0.00 0.000000 0 7 getuid
0.00 0.000000 0 2 geteuid
0.00 0.000000 0 1 getegid
0.00 0.000000 0 3 getppid
0.00 0.000000 0 2 1 setsid
0.00 0.000000 0 1 sigaltstack
0.00 0.000000 0 3 statfs
0.00 0.000000 0 2 arch_prctl
0.00 0.000000 0 3 setrlimit
0.00 0.000000 0 8 2 futex
0.00 0.000000 0 1 sched_getaffinity
0.00 0.000000 0 2 io_setup
0.00 0.000000 0 1 io_destroy
0.00 0.000000 0 2 set_tid_address
0.00 0.000000 0 1 semtimedop
0.00 0.000000 0 2 set_robust_list
------ ----------- ----------- --------- --------- ----------------
100.00 0.162223 544221 189 total
real 0m22.412s
user 0m3.541s
sys 0m12.842s
# echo 1 >| /proc/sys/kernel/vsyscall64
$ time strace -f -c sqlplus system/xxxx @/tmp/a.sql
....
Elapsed: 00:00:10.66
.....
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
66.44 0.044495 1 60292 read
14.52 0.009727 0 116045 getrusage
12.88 0.008626 0 60117 write
5.59 0.003745 0 60655 times
0.21 0.000138 4 34 munmap
0.10 0.000066 33 2 pipe
0.10 0.000065 33 2 set_tid_address
0.06 0.000040 0 225 113 open
0.04 0.000025 1 21 14 access
0.03 0.000018 0 96 lseek
0.02 0.000015 0 65 mprotect
0.02 0.000011 0 170 mmap
0.00 0.000000 0 127 close
0.00 0.000000 0 49 36 stat
0.00 0.000000 0 55 fstat
0.00 0.000000 0 16 brk
0.00 0.000000 0 53 rt_sigaction
0.00 0.000000 0 18 rt_sigprocmask
0.00 0.000000 0 3 ioctl
0.00 0.000000 0 6 pread
0.00 0.000000 0 16 14 shmget
0.00 0.000000 0 2 shmat
0.00 0.000000 0 1 shmctl
0.00 0.000000 0 2 dup
0.00 0.000000 0 9 socket
0.00 0.000000 0 8 8 connect
0.00 0.000000 0 1 bind
0.00 0.000000 0 1 getsockname
0.00 0.000000 0 1 1 getpeername
0.00 0.000000 0 2 getsockopt
0.00 0.000000 0 1 clone
0.00 0.000000 0 2 execve
0.00 0.000000 0 7 uname
0.00 0.000000 0 5 semctl
0.00 0.000000 0 2 shmdt
0.00 0.000000 0 31 fcntl
0.00 0.000000 0 6 getdents
0.00 0.000000 0 5 getcwd
0.00 0.000000 0 1 chdir
0.00 0.000000 0 3 readlink
0.00 0.000000 0 2 umask
0.00 0.000000 0 9 getrlimit
0.00 0.000000 0 7 getuid
0.00 0.000000 0 2 geteuid
0.00 0.000000 0 1 getegid
0.00 0.000000 0 3 getppid
0.00 0.000000 0 2 1 setsid
0.00 0.000000 0 1 sigaltstack
0.00 0.000000 0 5 statfs
0.00 0.000000 0 2 arch_prctl
0.00 0.000000 0 3 setrlimit
0.00 0.000000 0 8 2 futex
0.00 0.000000 0 1 sched_getaffinity
0.00 0.000000 0 2 io_setup
0.00 0.000000 0 1 io_destroy
0.00 0.000000 0 2 semtimedop
0.00 0.000000 0 2 set_robust_list
------ ----------- ----------- --------- --------- ----------------
100.00 0.066971 298210 189 total
real 0m11.241s
user 0m2.249s
sys 0m6.253s
# echo 1 >| /proc/sys/kernel/vsyscall64
$ time strace -f -c sqlplus system/xxxx @/tmp/a.sql
....
Elapsed: 00:00:12.85
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
69.65 0.069590 1 60292 read
13.24 0.013234 0 111684 getrusage
11.39 0.011378 0 60117 write
5.51 0.005502 0 60262 times
0.14 0.000142 8 18 rt_sigprocmask
0.03 0.000028 0 65 mprotect
0.03 0.000027 0 223 113 open
0.02 0.000019 1 34 munmap
0.00 0.000000 0 125 close
0.00 0.000000 0 49 36 stat
0.00 0.000000 0 55 fstat
0.00 0.000000 0 96 lseek
0.00 0.000000 0 165 mmap
0.00 0.000000 0 16 brk
0.00 0.000000 0 53 rt_sigaction
0.00 0.000000 0 3 ioctl
0.00 0.000000 0 21 14 access
0.00 0.000000 0 2 pipe
0.00 0.000000 0 16 14 shmget
0.00 0.000000 0 2 shmat
0.00 0.000000 0 1 shmctl
0.00 0.000000 0 2 dup
0.00 0.000000 0 9 socket
0.00 0.000000 0 8 8 connect
0.00 0.000000 0 1 bind
0.00 0.000000 0 1 getsockname
0.00 0.000000 0 1 1 getpeername
0.00 0.000000 0 2 getsockopt
0.00 0.000000 0 1 clone
0.00 0.000000 0 2 execve
0.00 0.000000 0 7 uname
0.00 0.000000 0 2 semctl
0.00 0.000000 0 2 shmdt
0.00 0.000000 0 29 fcntl
0.00 0.000000 0 6 getdents
0.00 0.000000 0 5 getcwd
0.00 0.000000 0 1 chdir
0.00 0.000000 0 3 readlink
0.00 0.000000 0 2 umask
0.00 0.000000 0 9 getrlimit
0.00 0.000000 0 7 getuid
0.00 0.000000 0 2 geteuid
0.00 0.000000 0 1 getegid
0.00 0.000000 0 3 getppid
0.00 0.000000 0 2 1 setsid
0.00 0.000000 0 1 sigaltstack
0.00 0.000000 0 3 statfs
0.00 0.000000 0 2 arch_prctl
0.00 0.000000 0 3 setrlimit
0.00 0.000000 0 8 2 futex
0.00 0.000000 0 1 sched_getaffinity
0.00 0.000000 0 2 io_setup
0.00 0.000000 0 1 io_destroy
0.00 0.000000 0 2 set_tid_address
0.00 0.000000 0 2 semtimedop
0.00 0.000000 0 2 set_robust_list
------ ----------- ----------- --------- --------- ----------------
100.00 0.099920 293434 189 total
real 0m13.330s
user 0m2.442s
sys 0m7.564s
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/267265/viewspace-765611/ ,如需转载,请注明出处,否则将追究法律责任。