简单记录.
[oracle@yws ~]$ ps -ef |grep ckpt|grep -v grep |awk '{print $2}'
10217
[oracle@yws ~]$ ltrace -t -p 10217 --跟踪
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 gettimeofday(0xbfde37e0, NULL) = 0
05:55:21 gettimeofday(0xbfde3674, NULL) = 0
05:55:21 gettimeofday(0xbfde36d4, NULL) = 0
05:55:21 gettimeofday(0xbfde372c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 times(0, 0xd04564c, 0, 300, 0) = 0x1a356420
05:55:21 gettimeofday(0xbfde39b8, NULL) = 0
05:55:21 gettimeofday(0xbfde3700, NULL) = 0
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 gettimeofday(0xbfde37e0, NULL) = 0
05:55:23 gettimeofday(0xbfde3674, NULL) = 0
05:55:23 gettimeofday(0xbfde36d4, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 times(0, 0xd04564c, 0, 231, 0) = 0x1a35650b
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 times(0, 0xbfde39e4, 0, 199, 49) = 0x1a35650b
05:55:23 times(0, 0xbfde39e4, 0, 948, 49) = 0x1a35650b
05:55:23 gettimeofday(0xbfde3980, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 sprintf("/proc/10255/stat", "/proc/%d/stat", 10255) = 16
05:55:23 open("/proc/10255/stat", 0, 00) = 24
05:55:23 read(24, "10255 (oracle) S 1 10255 10255 0"..., 999) = 198
05:55:23 close(24) = 0
05:55:23 strchr("10255 (oracle) S 1 10255 10255 0"..., ')') = ") S 1 10255 10255 0 -1 4202496 3"...
05:55:23 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282035) = 1
05:55:23 sprintf("/proc/10257/stat", "/proc/%d/stat", 10257) = 16
05:55:23 open("/proc/10257/stat", 0, 00) = 24
05:55:23 read(24, "10257 (oracle) S 1 10257 10257 0"..., 999) = 201
05:55:23 close(24) = 0
05:55:23 strchr("10257 (oracle) S 1 10257 10257 0"..., ')') = ") S 1 10257 10257 0 -1 4202496 5"...
05:55:23 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282037) = 1
05:55:23 _setjmp(0xbfde35c4, 0, 0x2000ade8, 0, 0) = 0
05:55:23 _intel_fast_memset(0xb7f7b800, 0, 16384, 16895, 0xc9f0690) = 0xb7f7b800
05:55:23 _intel_fast_memcpy(0xb7f7b814, 0x2000cc50, 484, 0xb7f7b800, 0) = 0xb7f7b814
05:55:23 _setjmp(0xbfde34f4, 0x30203730, 0x20312d20, 0x32303234, 0x20363934) = 0
05:55:23 gettimeofday(0xbfde35d4, NULL) = 0
05:55:23 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35650b
05:55:23 pwrite64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 times(0, 0xd04564c, 0, 0xb7f7956c, 16384) = 0x1a35650c
05:55:23 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35650c
05:55:23 pwrite64(16, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 times(0, 0xd04564c, 0, 0xb7f79694, 16384) = 0x1a35650c
05:55:23 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35650d
05:55:23 pwrite64(17, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 times(0, 0xd04564c, 0, 0xb7f797bc, 16384) = 0x1a35650d
05:55:23 gettimeofday(0xbfde35c0, NULL) = 0
05:55:23 gettimeofday(0xbfde35d4, NULL) = 0
05:55:23 pread64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 gettimeofday(0xbfde35d8, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 _setjmp(0xbfde3928, 0xab19a2e, 0x6092b2f8, 102, 100) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde3784, NULL) = 0
05:55:23 _setjmp(0xbfde3678, 0, 0, 0, 0) = 0
05:55:23 _intel_fast_memset(0xb7f794d8, 0, 440, 440, 0xc644330) = 0xb7f794d8
05:55:23 gettimeofday(0xbfde3784, NULL) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde3854, NULL) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 times(0, 0xd04564c, 0, 0, 304) = 0x1a35650f
05:55:23 gettimeofday(0xbfde39b8, NULL) = 0
05:55:23 gettimeofday(0xbfde3700, NULL) = 0
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 gettimeofday(0xbfde37e0, NULL) = 0
05:55:26 gettimeofday(0xbfde3674, NULL) = 0
05:55:26 gettimeofday(0xbfde36d4, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 _setjmp(0xbfde3914, 0x5310954e, -1, 0, 0xda384f4) = 0
05:55:26 gettimeofday(0xbfde3868, NULL) = 0
05:55:26 getrusage(0, 0xbfde3834, 0x304b8fc4, 0, 1) = 0
05:55:26 getrusage(0, 0xbfde3804, 0x30e2ae9c, 0xbfde3940, 0x8342b1e) = 0
05:55:26 gettimeofday(0xbfde3838, NULL) = 0
05:55:26 _setjmp(0xbfde3914, 0x5310954e, 0x53109553, 0, 0xda37988) = 0
05:55:26 _setjmp(0xbfde3914, 0x5310954e, 0x53109551, 0, 0xda1914c) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 times(0, 0xd04564c, 0, 300, 0) = 0x1a35663d
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 localtime_r(0xbfde3934, 0xbfde3900, 0xd099b3c, 0x30e2afe4, 0) = 0xbfde3900
05:55:26 gettimeofday(0xbfde388c, NULL) = 0
05:55:26 gettimeofday(0xbfde388c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 times(0, 0xbfde39e4, 0, 199, 49) = 0x1a35663d
05:55:26 times(0, 0xbfde39e4, 0, 948, 49) = 0x1a35663d
05:55:26 gettimeofday(0xbfde3980, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 sprintf("/proc/10255/stat", "/proc/%d/stat", 10255) = 16
05:55:26 open("/proc/10255/stat", 0, 00) = 24
05:55:26 read(24, "10255 (oracle) S 1 10255 10255 0"..., 999) = 198
05:55:26 close(24) = 0
05:55:26 strchr("10255 (oracle) S 1 10255 10255 0"..., ')') = ") S 1 10255 10255 0 -1 4202496 3"...
05:55:26 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282035) = 1
05:55:26 sprintf("/proc/10257/stat", "/proc/%d/stat", 10257) = 16
05:55:26 open("/proc/10257/stat", 0, 00) = 24
05:55:26 read(24, "10257 (oracle) S 1 10257 10257 0"..., 999) = 201
05:55:26 close(24) = 0
05:55:26 strchr("10257 (oracle) S 1 10257 10257 0"..., ')') = ") S 1 10257 10257 0 -1 4202496 5"...
05:55:26 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282037) = 1
05:55:26 _setjmp(0xbfde35c4, 0, 0x2000ade8, 0, 0) = 0
05:55:26 _intel_fast_memset(0xb7f7b800, 0, 16384, 16895, 0xc9f0690) = 0xb7f7b800
05:55:26 _intel_fast_memcpy(0xb7f7b814, 0x2000cc50, 484, 0xb7f7b800, 0) = 0xb7f7b814
05:55:26 _setjmp(0xbfde34f4, 0x30203730, 0x20312d20, 0x32303234, 0x20363934) = 0
05:55:26 gettimeofday(0xbfde35d4, NULL) = 0
05:55:26 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35663e
05:55:26 pwrite64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 times(0, 0xd04564c, 0, 0xb7f7956c, 16384) = 0x1a35663e
05:55:26 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35663e
05:55:26 pwrite64(16, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 times(0, 0xd04564c, 0, 0xb7f79694, 16384) = 0x1a35663f
05:55:26 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35663f
05:55:26 pwrite64(17, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 times(0, 0xd04564c, 0, 0xb7f797bc, 16384) = 0x1a35663f
05:55:26 gettimeofday(0xbfde35c0, NULL) = 0
05:55:26 gettimeofday(0xbfde35d4, NULL) = 0
05:55:26 pread64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 gettimeofday(0xbfde35d8, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 _setjmp(0xbfde3928, 0xab19a2e, 0x60975e48, 102, 100) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde3784, NULL) = 0
05:55:26 _setjmp(0xbfde3678, 0, 0, 0, 0) = 0
05:55:26 _intel_fast_memset(0xb7f794d8, 0, 440, 440, 0xc644330) = 0xb7f794d8
05:55:26 gettimeofday(0xbfde3784, NULL) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde3854, NULL) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 times(0, 0xd04564c, 0, 0, 302) = 0x1a356641
05:55:26 gettimeofday(0xbfde39b8, NULL) = 0
05:55:26 gettimeofday(0xbfde3700, NULL) = 0
可以发现是每三秒进行一次.第一列是系统事件.同时证明Oracle也不可能脱离系统事件.
同时查看lgwr进程:
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 46, 0) = 0x1a35ba50
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0x321bf723, 0, 0, 0x6193b40) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7afc8, NULL) = 0
05:59:02 localtime_r(0xbfe7afd0, 0xbfe7af9c, 460, 0, 0x30e2aa20) = 0xbfe7af9c
05:59:02 _setjmp(0xbfe7afb4, 0x53109626, -1, 0xafbb4f5, 0xe60612c) = 0
05:59:02 gettimeofday(0xbfe7af08, NULL) = 0
05:59:02 getrusage(0, 0xbfe7aed4, 22085, 0x30e5e154, 0) = 0
05:59:02 getrusage(0, 0xbfe7aea4, 0xbfe7af34, 0x834401e, 110) = 0
05:59:02 gettimeofday(0xbfe7aed8, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 0, 304) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7b058, NULL) = 0
05:59:02 gettimeofday(0xbfe7ada0, NULL) = 0
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 300, 0) = 0x1a35bb7e
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0x321bf726, 0, 0, 0x619472a) = 0x1a35bb7e
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe602dfc) = 0
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe5ed14c) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 0, 301) = 0x1a35bb7f
05:59:05 gettimeofday(0xbfe7b058, NULL) = 0
05:59:05 gettimeofday(0xbfe7ada0, NULL) = 0
查看dbwr进程:
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 46, 0) = 0x1a35ba50
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0x321bf723, 0, 0, 0x6193b40) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7afc8, NULL) = 0
05:59:02 localtime_r(0xbfe7afd0, 0xbfe7af9c, 460, 0, 0x30e2aa20) = 0xbfe7af9c
05:59:02 _setjmp(0xbfe7afb4, 0x53109626, -1, 0xafbb4f5, 0xe60612c) = 0
05:59:02 gettimeofday(0xbfe7af08, NULL) = 0
05:59:02 getrusage(0, 0xbfe7aed4, 22085, 0x30e5e154, 0) = 0
05:59:02 getrusage(0, 0xbfe7aea4, 0xbfe7af34, 0x834401e, 110) = 0
05:59:02 gettimeofday(0xbfe7aed8, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 0, 304) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7b058, NULL) = 0
05:59:02 gettimeofday(0xbfe7ada0, NULL) = 0
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 300, 0) = 0x1a35bb7e
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0x321bf726, 0, 0, 0x619472a) = 0x1a35bb7e
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe602dfc) = 0
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe5ed14c) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 0, 301) = 0x1a35bb7f
05:59:05 gettimeofday(0xbfe7b058, NULL) = 0
05:59:05 gettimeofday(0xbfe7ada0, NULL) = 0
[oracle@yws ~]$ ltrace -t -p 10213
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 gettimeofday(0xbfd70020, NULL) = 0
06:00:24 gettimeofday(0xbfd6feb4, NULL) = 0
06:00:24 gettimeofday(0xbfd6ff14, NULL) = 0
06:00:24 gettimeofday(0xbfd6ff6c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 times(0, 0xd04564c, 0, 300, 0) = 0x1a35daa1
06:00:24 gettimeofday(0xbfd701f8, NULL) = 0
06:00:24 gettimeofday(0xbfd6ff40, NULL) = 0
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 gettimeofday(0xbfd70020, NULL) = 0
06:00:27 gettimeofday(0xbfd6feb4, NULL) = 0
06:00:27 gettimeofday(0xbfd6ff14, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 _setjmp(0xbfd70154, 0x5310967a, -1, 0, 0xd983630) = 0
06:00:27 gettimeofday(0xbfd700a8, NULL) = 0
06:00:27 getrusage(0, 0xbfd70074, 0, 0x53109675, 0) = 0
06:00:27 getrusage(0, 0xbfd70044, 0x30e2a314, 0xbfd70180, 0x8342b1e) = 0
06:00:27 gettimeofday(0xbfd70078, NULL) = 0
06:00:27 _setjmp(0xbfd70154, 0x5310967a, 0x5310967f, 0, 0xd982ac4) = 0
06:00:27 _setjmp(0xbfd70154, 0x5310967a, 0x5310967d, 0, 0xd96614c) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 times(0, 0xd04564c, 0, 213, 0) = 0x1a35db7b
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 times(0, 0xd96993c, 0, 0xd96993c, 256) = 0x1a35db7b
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 times(0, 0xd04564c, 0, 0, 305) = 0x1a35db7b
06:00:27 gettimeofday(0xbfd701f8, NULL) = 0
06:00:27 gettimeofday(0xbfd6ff40, NULL) = 0
简单记录下,挺有意思.
[oracle@yws ~]$ ps -ef |grep ckpt|grep -v grep |awk '{print $2}'
10217
[oracle@yws ~]$ ltrace -t -p 10217 --跟踪
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 __errno_location() = 0x21468c
05:55:21 gettimeofday(0xbfde37e0, NULL) = 0
05:55:21 gettimeofday(0xbfde3674, NULL) = 0
05:55:21 gettimeofday(0xbfde36d4, NULL) = 0
05:55:21 gettimeofday(0xbfde372c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 gettimeofday(0xbfde392c, NULL) = 0
05:55:21 times(0, 0xd04564c, 0, 300, 0) = 0x1a356420
05:55:21 gettimeofday(0xbfde39b8, NULL) = 0
05:55:21 gettimeofday(0xbfde3700, NULL) = 0
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 __errno_location() = 0x21468c
05:55:23 gettimeofday(0xbfde37e0, NULL) = 0
05:55:23 gettimeofday(0xbfde3674, NULL) = 0
05:55:23 gettimeofday(0xbfde36d4, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 times(0, 0xd04564c, 0, 231, 0) = 0x1a35650b
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 times(0, 0xbfde39e4, 0, 199, 49) = 0x1a35650b
05:55:23 times(0, 0xbfde39e4, 0, 948, 49) = 0x1a35650b
05:55:23 gettimeofday(0xbfde3980, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 sprintf("/proc/10255/stat", "/proc/%d/stat", 10255) = 16
05:55:23 open("/proc/10255/stat", 0, 00) = 24
05:55:23 read(24, "10255 (oracle) S 1 10255 10255 0"..., 999) = 198
05:55:23 close(24) = 0
05:55:23 strchr("10255 (oracle) S 1 10255 10255 0"..., ')') = ") S 1 10255 10255 0 -1 4202496 3"...
05:55:23 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282035) = 1
05:55:23 sprintf("/proc/10257/stat", "/proc/%d/stat", 10257) = 16
05:55:23 open("/proc/10257/stat", 0, 00) = 24
05:55:23 read(24, "10257 (oracle) S 1 10257 10257 0"..., 999) = 201
05:55:23 close(24) = 0
05:55:23 strchr("10257 (oracle) S 1 10257 10257 0"..., ')') = ") S 1 10257 10257 0 -1 4202496 5"...
05:55:23 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282037) = 1
05:55:23 _setjmp(0xbfde35c4, 0, 0x2000ade8, 0, 0) = 0
05:55:23 _intel_fast_memset(0xb7f7b800, 0, 16384, 16895, 0xc9f0690) = 0xb7f7b800
05:55:23 _intel_fast_memcpy(0xb7f7b814, 0x2000cc50, 484, 0xb7f7b800, 0) = 0xb7f7b814
05:55:23 _setjmp(0xbfde34f4, 0x30203730, 0x20312d20, 0x32303234, 0x20363934) = 0
05:55:23 gettimeofday(0xbfde35d4, NULL) = 0
05:55:23 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35650b
05:55:23 pwrite64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 times(0, 0xd04564c, 0, 0xb7f7956c, 16384) = 0x1a35650c
05:55:23 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35650c
05:55:23 pwrite64(16, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 times(0, 0xd04564c, 0, 0xb7f79694, 16384) = 0x1a35650c
05:55:23 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35650d
05:55:23 pwrite64(17, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 times(0, 0xd04564c, 0, 0xb7f797bc, 16384) = 0x1a35650d
05:55:23 gettimeofday(0xbfde35c0, NULL) = 0
05:55:23 gettimeofday(0xbfde35d4, NULL) = 0
05:55:23 pread64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:23 gettimeofday(0xbfde35d8, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 _setjmp(0xbfde3928, 0xab19a2e, 0x6092b2f8, 102, 100) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde3784, NULL) = 0
05:55:23 _setjmp(0xbfde3678, 0, 0, 0, 0) = 0
05:55:23 _intel_fast_memset(0xb7f794d8, 0, 440, 440, 0xc644330) = 0xb7f794d8
05:55:23 gettimeofday(0xbfde3784, NULL) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde3854, NULL) = 0
05:55:23 gettimeofday(0xbfde38a0, NULL) = 0
05:55:23 gettimeofday(0xbfde392c, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 gettimeofday(0xbfde3920, NULL) = 0
05:55:23 times(0, 0xd04564c, 0, 0, 304) = 0x1a35650f
05:55:23 gettimeofday(0xbfde39b8, NULL) = 0
05:55:23 gettimeofday(0xbfde3700, NULL) = 0
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 __errno_location() = 0x21468c
05:55:26 gettimeofday(0xbfde37e0, NULL) = 0
05:55:26 gettimeofday(0xbfde3674, NULL) = 0
05:55:26 gettimeofday(0xbfde36d4, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 _setjmp(0xbfde3914, 0x5310954e, -1, 0, 0xda384f4) = 0
05:55:26 gettimeofday(0xbfde3868, NULL) = 0
05:55:26 getrusage(0, 0xbfde3834, 0x304b8fc4, 0, 1) = 0
05:55:26 getrusage(0, 0xbfde3804, 0x30e2ae9c, 0xbfde3940, 0x8342b1e) = 0
05:55:26 gettimeofday(0xbfde3838, NULL) = 0
05:55:26 _setjmp(0xbfde3914, 0x5310954e, 0x53109553, 0, 0xda37988) = 0
05:55:26 _setjmp(0xbfde3914, 0x5310954e, 0x53109551, 0, 0xda1914c) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 times(0, 0xd04564c, 0, 300, 0) = 0x1a35663d
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 localtime_r(0xbfde3934, 0xbfde3900, 0xd099b3c, 0x30e2afe4, 0) = 0xbfde3900
05:55:26 gettimeofday(0xbfde388c, NULL) = 0
05:55:26 gettimeofday(0xbfde388c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 times(0, 0xbfde39e4, 0, 199, 49) = 0x1a35663d
05:55:26 times(0, 0xbfde39e4, 0, 948, 49) = 0x1a35663d
05:55:26 gettimeofday(0xbfde3980, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 sprintf("/proc/10255/stat", "/proc/%d/stat", 10255) = 16
05:55:26 open("/proc/10255/stat", 0, 00) = 24
05:55:26 read(24, "10255 (oracle) S 1 10255 10255 0"..., 999) = 198
05:55:26 close(24) = 0
05:55:26 strchr("10255 (oracle) S 1 10255 10255 0"..., ')') = ") S 1 10255 10255 0 -1 4202496 3"...
05:55:26 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282035) = 1
05:55:26 sprintf("/proc/10257/stat", "/proc/%d/stat", 10257) = 16
05:55:26 open("/proc/10257/stat", 0, 00) = 24
05:55:26 read(24, "10257 (oracle) S 1 10257 10257 0"..., 999) = 201
05:55:26 close(24) = 0
05:55:26 strchr("10257 (oracle) S 1 10257 10257 0"..., ')') = ") S 1 10257 10257 0 -1 4202496 5"...
05:55:26 sscanf(0xbfde2f2f, 0xcbeb060, 0xbfde3340, 0x35323031, 0x6f282037) = 1
05:55:26 _setjmp(0xbfde35c4, 0, 0x2000ade8, 0, 0) = 0
05:55:26 _intel_fast_memset(0xb7f7b800, 0, 16384, 16895, 0xc9f0690) = 0xb7f7b800
05:55:26 _intel_fast_memcpy(0xb7f7b814, 0x2000cc50, 484, 0xb7f7b800, 0) = 0xb7f7b814
05:55:26 _setjmp(0xbfde34f4, 0x30203730, 0x20312d20, 0x32303234, 0x20363934) = 0
05:55:26 gettimeofday(0xbfde35d4, NULL) = 0
05:55:26 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35663e
05:55:26 pwrite64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 times(0, 0xd04564c, 0, 0xb7f7956c, 16384) = 0x1a35663e
05:55:26 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35663e
05:55:26 pwrite64(16, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 times(0, 0xd04564c, 0, 0xb7f79694, 16384) = 0x1a35663f
05:55:26 times(0, 0xd04564c, 0, 16384, 49152) = 0x1a35663f
05:55:26 pwrite64(17, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 times(0, 0xd04564c, 0, 0xb7f797bc, 16384) = 0x1a35663f
05:55:26 gettimeofday(0xbfde35c0, NULL) = 0
05:55:26 gettimeofday(0xbfde35d4, NULL) = 0
05:55:26 pread64(15, 0xb7f7b800, 16384, 49152, 0) = 16384
05:55:26 gettimeofday(0xbfde35d8, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 _setjmp(0xbfde3928, 0xab19a2e, 0x60975e48, 102, 100) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde3784, NULL) = 0
05:55:26 _setjmp(0xbfde3678, 0, 0, 0, 0) = 0
05:55:26 _intel_fast_memset(0xb7f794d8, 0, 440, 440, 0xc644330) = 0xb7f794d8
05:55:26 gettimeofday(0xbfde3784, NULL) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde3854, NULL) = 0
05:55:26 gettimeofday(0xbfde38a0, NULL) = 0
05:55:26 gettimeofday(0xbfde392c, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 gettimeofday(0xbfde3920, NULL) = 0
05:55:26 times(0, 0xd04564c, 0, 0, 302) = 0x1a356641
05:55:26 gettimeofday(0xbfde39b8, NULL) = 0
05:55:26 gettimeofday(0xbfde3700, NULL) = 0
可以发现是每三秒进行一次.第一列是系统事件.同时证明Oracle也不可能脱离系统事件.
同时查看lgwr进程:
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 46, 0) = 0x1a35ba50
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0x321bf723, 0, 0, 0x6193b40) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7afc8, NULL) = 0
05:59:02 localtime_r(0xbfe7afd0, 0xbfe7af9c, 460, 0, 0x30e2aa20) = 0xbfe7af9c
05:59:02 _setjmp(0xbfe7afb4, 0x53109626, -1, 0xafbb4f5, 0xe60612c) = 0
05:59:02 gettimeofday(0xbfe7af08, NULL) = 0
05:59:02 getrusage(0, 0xbfe7aed4, 22085, 0x30e5e154, 0) = 0
05:59:02 getrusage(0, 0xbfe7aea4, 0xbfe7af34, 0x834401e, 110) = 0
05:59:02 gettimeofday(0xbfe7aed8, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 0, 304) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7b058, NULL) = 0
05:59:02 gettimeofday(0xbfe7ada0, NULL) = 0
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 300, 0) = 0x1a35bb7e
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0x321bf726, 0, 0, 0x619472a) = 0x1a35bb7e
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe602dfc) = 0
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe5ed14c) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 0, 301) = 0x1a35bb7f
05:59:05 gettimeofday(0xbfe7b058, NULL) = 0
05:59:05 gettimeofday(0xbfe7ada0, NULL) = 0
查看dbwr进程:
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 __errno_location() = 0x91e68c
05:59:02 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:02 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 46, 0) = 0x1a35ba50
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 times(0, 0x321bf723, 0, 0, 0x6193b40) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7afc8, NULL) = 0
05:59:02 localtime_r(0xbfe7afd0, 0xbfe7af9c, 460, 0, 0x30e2aa20) = 0xbfe7af9c
05:59:02 _setjmp(0xbfe7afb4, 0x53109626, -1, 0xafbb4f5, 0xe60612c) = 0
05:59:02 gettimeofday(0xbfe7af08, NULL) = 0
05:59:02 getrusage(0, 0xbfe7aed4, 22085, 0x30e5e154, 0) = 0
05:59:02 getrusage(0, 0xbfe7aea4, 0xbfe7af34, 0x834401e, 110) = 0
05:59:02 gettimeofday(0xbfe7aed8, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:02 times(0, 0xd04564c, 0, 0, 304) = 0x1a35ba51
05:59:02 gettimeofday(0xbfe7b058, NULL) = 0
05:59:02 gettimeofday(0xbfe7ada0, NULL) = 0
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 __errno_location() = 0x91e68c
05:59:05 gettimeofday(0xbfe7ae80, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad14, NULL) = 0
05:59:05 gettimeofday(0xbfe7ad74, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 300, 0) = 0x1a35bb7e
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 times(0, 0x321bf726, 0, 0, 0x619472a) = 0x1a35bb7e
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe602dfc) = 0
05:59:05 _setjmp(0xbfe7afb4, 0x53109629, 0x5310962b, 0, 0xe5ed14c) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afcc, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 gettimeofday(0xbfe7afc0, NULL) = 0
05:59:05 times(0, 0xd04564c, 0, 0, 301) = 0x1a35bb7f
05:59:05 gettimeofday(0xbfe7b058, NULL) = 0
05:59:05 gettimeofday(0xbfe7ada0, NULL) = 0
[oracle@yws ~]$ ltrace -t -p 10213
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 __errno_location() = 0x8ad68c
06:00:24 gettimeofday(0xbfd70020, NULL) = 0
06:00:24 gettimeofday(0xbfd6feb4, NULL) = 0
06:00:24 gettimeofday(0xbfd6ff14, NULL) = 0
06:00:24 gettimeofday(0xbfd6ff6c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 gettimeofday(0xbfd7016c, NULL) = 0
06:00:24 times(0, 0xd04564c, 0, 300, 0) = 0x1a35daa1
06:00:24 gettimeofday(0xbfd701f8, NULL) = 0
06:00:24 gettimeofday(0xbfd6ff40, NULL) = 0
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 __errno_location() = 0x8ad68c
06:00:27 gettimeofday(0xbfd70020, NULL) = 0
06:00:27 gettimeofday(0xbfd6feb4, NULL) = 0
06:00:27 gettimeofday(0xbfd6ff14, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 _setjmp(0xbfd70154, 0x5310967a, -1, 0, 0xd983630) = 0
06:00:27 gettimeofday(0xbfd700a8, NULL) = 0
06:00:27 getrusage(0, 0xbfd70074, 0, 0x53109675, 0) = 0
06:00:27 getrusage(0, 0xbfd70044, 0x30e2a314, 0xbfd70180, 0x8342b1e) = 0
06:00:27 gettimeofday(0xbfd70078, NULL) = 0
06:00:27 _setjmp(0xbfd70154, 0x5310967a, 0x5310967f, 0, 0xd982ac4) = 0
06:00:27 _setjmp(0xbfd70154, 0x5310967a, 0x5310967d, 0, 0xd96614c) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 times(0, 0xd04564c, 0, 213, 0) = 0x1a35db7b
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 times(0, 0xd96993c, 0, 0xd96993c, 256) = 0x1a35db7b
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd7016c, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 gettimeofday(0xbfd70160, NULL) = 0
06:00:27 times(0, 0xd04564c, 0, 0, 305) = 0x1a35db7b
06:00:27 gettimeofday(0xbfd701f8, NULL) = 0
06:00:27 gettimeofday(0xbfd6ff40, NULL) = 0
简单记录下,挺有意思.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29477587/viewspace-1097380/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29477587/viewspace-1097380/