ckpt的3秒响应以及oracle系统时间由来

02:24:14.025115 gettimeofday({1263752654, 25192}, NULL) = 0
02:24:14.025192 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025193 gettimeofday({1263752654, 25193}, NULL) = 0
02:24:14.025581 gettimeofday({1263752654, 25615}, NULL) = 0
02:24:14.025680 gettimeofday({1263752654, 26111}, NULL) = 0
02:24:14.026183 gettimeofday({1263752654, 26186}, NULL) = 0
02:24:14.026188 times(NULL)             = 430253501
02:24:14.026189 gettimeofday({1263752654, 26190}, NULL) = 0
02:24:14.026191 gettimeofday({1263752654, 26191}, NULL) = 0
02:24:14.026191 semtimedop(98304, 0xbfffe7f8, 1, {0, 720000000}) = -1 EAGAIN (Resource temporarily unavailable)
02:24:14.747076 gettimeofday({1263752654, 747137}, NULL) = 0
02:24:14.747816 gettimeofday({1263752654, 747826}, NULL) = 0
02:24:14.747832 gettimeofday({1263752654, 747836}, NULL) = 0
02:24:14.747839 gettimeofday({1263752654, 747841}, NULL) = 0
02:24:14.747843 gettimeofday({1263752654, 747843}, NULL) = 0
02:24:14.747844 getrusage(RUSAGE_SELF, {ru_utime={0, 389940}, ru_stime={1, 718738}, ...}) = 0
02:24:14.747844 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 getrusage(RUSAGE_SELF, {ru_utime={0, 389940}, ru_stime={1, 718738}, ...}) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.747845 times(NULL)             = 430253573
02:24:14.747845 gettimeofday({1263752654, 747845}, NULL) = 0
02:24:14.748814 gettimeofday({1263752654, 748824}, NULL) = 0
02:24:14.748830 gettimeofday({1263752654, 748835}, NULL) = 0
02:24:14.748837 gettimeofday({1263752654, 748839}, NULL) = 0
02:24:14.748841 kill(7008, SIG_0)       = 0
02:24:14.749952 open("/proc/7008/stat", O_RDONLY) = 19
02:24:14.750130 read(19, "7008 (oracle) S 1 7008 7008 0 -1"..., 999) = 189
02:24:14.750814 close(19)               = 0
02:24:14.750825 gettimeofday({1263752654, 750833}, NULL) = 0
02:24:14.750838 open("/etc/mtab", O_RDONLY) = 19
02:24:14.750841 fstat64(19, {st_mode=S_IFREG|0644, st_size=266, ...}) = 0
02:24:14.750843 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb721f000
02:24:14.750845 read(19, "/dev/sda3 / ext3 rw 0 0\nnone /pr"..., 4096) = 266
02:24:14.750846 close(19)               = 0
02:24:14.750847 munmap(0xb721f000, 4096) = 0
02:24:14.750847 open("/proc/stat", O_RDONLY) = 19
02:24:14.750847 fstat64(19, {st_mode=S_IFREG|0444, st_size=0, ...}) = 0
02:24:14.751827 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb721f000
02:24:14.751833 read(19, "cpu  2537 582 8835 1677994 11505"..., 1024) = 709
02:24:14.751837 read(19, "", 1024)      = 0
02:24:14.751840 close(19)               = 0
02:24:14.751842 munmap(0xb721f000, 4096) = 0
02:24:14.751844 gettimeofday({1263752654, 751844}, NULL) = 0
02:24:14.751845 times(NULL)             = 430253573
02:24:14.751845 gettimeofday({1263752654, 751845}, NULL) = 0
02:24:14.751846 gettimeofday({1263752654, 751846}, NULL) = 0
02:24:14.751846 kill(7037, SIG_0)       = 0
02:24:14.751846 open("/proc/7037/stat", O_RDONLY) = 19
02:24:14.751846 read(19, "7037 (oracle) S 1 7037 7037 0 -1"..., 999) = 188
02:24:14.751846 close(19)               = 0
02:24:14.751846 kill(7039, SIG_0)       = 0
02:24:14.751846 open("/proc/7039/stat", O_RDONLY) = 19
02:24:14.751846 read(19, "7039 (oracle) S 1 7039 7039 0 -1"..., 999) = 188
02:24:14.751846 close(19)               = 0
02:24:14.751846 gettimeofday({1263752654, 751846}, NULL) = 0
02:24:14.751846 times(NULL)             = 430253573
02:24:14.751846 pwrite64(16, "\25\302\0\0\3\0\0\0\0\0\0\0\0\0\1\4\33F\0\0\2\0\0\0\0\0\0\0\10\0\0\0"..., 16384, 49152) = 16384
02:24:14.754527 times(NULL)             = 430253574
02:24:14.754820 gettimeofday({1263752654, 754827}, NULL) = 0
02:24:14.754832 gettimeofday({1263752654, 754836}, NULL) = 0
02:24:14.754838 gettimeofday({1263752654, 754839}, NULL) = 0
02:24:14.754840 times(NULL)             = 430253574
02:24:14.754841 times(NULL)             = 430253574
02:24:14.754841 times(NULL)             = 430253574
02:24:14.754842 times(NULL)             = 430253574
02:24:14.754842 gettimeofday({1263752654, 754842}, NULL) = 0
02:24:14.754842 gettimeofday({1263752654, 754842}, NULL) = 0
02:24:14.754842 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.754843 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.754843 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.754843 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.754843 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.754843 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.754843 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.754843 gettimeofday({1263752654, 754843}, NULL) = 0
02:24:14.756838 gettimeofday({1263752654, 756839}, NULL) = 0
02:24:14.756839 gettimeofday({1263752654, 756839}, NULL) = 0
02:24:14.756839 gettimeofday({1263752654, 756840}, NULL) = 0
02:24:14.756840 gettimeofday({1263752654, 756840}, NULL) = 0
02:24:14.756840 gettimeofday({1263752654, 756840}, NULL) = 0
02:24:14.757813 gettimeofday({1263752654, 757822}, NULL) = 0
02:24:14.757827 gettimeofday({1263752654, 757831}, NULL) = 0
02:24:14.757834 gettimeofday({1263752654, 757835}, NULL) = 0
02:24:14.757837 gettimeofday({1263752654, 757837}, NULL) = 0
02:24:14.757838 gettimeofday({1263752654, 757838}, NULL) = 0
02:24:14.758838 times(NULL)             = 430253574
02:24:14.759831 gettimeofday({1263752654, 759832}, NULL) = 0
02:24:14.759834 gettimeofday({1263752654, 759834}, NULL) = 0
02:24:14.760282 semtimedop(98304, 0xbfffe7f8, 1, {3, 0}) = -1 EAGAIN (Resource temporarily unavailable)
02:24:17.760610 gettimeofday({1263752657, 760675}, NULL) = 0
02:24:17.761386 gettimeofday({1263752657, 761389}, NULL) = 0
02:24:17.761391 gettimeofday({1263752657, 761392}, NULL) = 0
02:24:17.761393 gettimeofday({1263752657, 761393}, NULL) = 0
02:24:17.761394 gettimeofday({1263752657, 761394}, NULL) = 0
02:24:17.761394 gettimeofday({1263752657, 761394}, NULL) = 0
02:24:17.761394 gettimeofday({1263752657, 761394}, NULL) = 0
02:24:17.761395 gettimeofday({1263752657, 761395}, NULL) = 0
02:24:17.761395 gettimeofday({1263752657, 761395}, NULL) = 0
02:24:17.761395 gettimeofday({1263752657, 761395}, NULL) = 0
02:24:17.761395 gettimeofday({1263752657, 761395}, NULL) = 0
02:24:17.761395 gettimeofday({1263752657, 761395}, NULL) = 0
02:24:17.761395 gettimeofday({1263752657, 761395}, NULL) = 0
02:24:17.762373 gettimeofday({1263752657, 762380}, NULL) = 0
02:24:17.762384 times(NULL)             = 430253874
02:24:17.762387 gettimeofday({1263752657, 762389}, NULL) = 0
02:24:17.762391 gettimeofday({1263752657, 762391}, NULL) = 0
02:24:17.762392 times(NULL)             = 430253874
02:24:17.762392 gettimeofday({1263752657, 762393}, NULL) = 0
02:24:17.762393 gettimeofday({1263752657, 762393}, NULL) = 0
02:24:17.762393 kill(7037, SIG_0)       = 0
02:24:17.762393 open("/proc/7037/stat", O_RDONLY) = 19
02:24:17.762393 read(19, "7037 (oracle) S 1 7037 7037 0 -1"..., 999) = 188
02:24:17.762393 close(19)               = 0
02:24:17.762393 kill(7039, SIG_0)       = 0
02:24:17.762393 open("/proc/7039/stat", O_RDONLY) = 19
02:24:17.762393 read(19, "7039 (oracle) S 1 7039 7039 0 -1"..., 999) = 188
02:24:17.762393 close(19)               = 0
02:24:17.762393 gettimeofday({1263752657, 762393}, NULL) = 0
02:24:17.762393 times(NULL)             = 430253874
02:24:17.762393 pwrite64(16, "\25\302\0\0\3\0\0\0\0\0\0\0\0\0\1\4\rF\0\0\2\0\0\0\0\0\0\0\10\0\0\0"..., 16384, 49152) = 16384
02:24:17.764834 times(NULL)             = 430253875
02:24:17.765379 gettimeofday({1263752657, 765382}, NULL) = 0
02:24:17.765385 gettimeofday({1263752657, 765387}, NULL) = 0
02:24:17.765388 gettimeofday({1263752657, 765389}, NULL) = 0
02:24:17.765389 gettimeofday({1263752657, 765389}, NULL) = 0
02:24:17.765390 gettimeofday({1263752657, 766368}, NULL) = 0
02:24:17.766375 gettimeofday({1263752657, 766380}, NULL) = 0
02:24:17.766383 gettimeofday({1263752657, 766385}, NULL) = 0
02:24:17.766386 gettimeofday({1263752657, 766388}, NULL) = 0
02:24:17.766388 gettimeofday({1263752657, 766389}, NULL) = 0
02:24:17.766389 gettimeofday({1263752657, 766389}, NULL) = 0
02:24:17.766389 gettimeofday({1263752657, 766389}, NULL) = 0
02:24:17.767380 gettimeofday({1263752657, 767383}, NULL) = 0
02:24:17.767385 gettimeofday({1263752657, 767386}, NULL) = 0
02:24:17.767387 gettimeofday({1263752657, 767387}, NULL) = 0
02:24:17.767388 gettimeofday({1263752657, 767388}, NULL) = 0
02:24:17.767388 gettimeofday({1263752657, 767389}, NULL) = 0
02:24:17.768382 gettimeofday({1263752657, 768384}, NULL) = 0
02:24:17.768385 gettimeofday({1263752657, 768386}, NULL) = 0
02:24:17.768386 gettimeofday({1263752657, 768387}, NULL) = 0
02:24:17.768387 gettimeofday({1263752657, 768387}, NULL) = 0
02:24:17.768387 gettimeofday({1263752657, 768387}, NULL) = 0
02:24:17.768387 gettimeofday({1263752657, 768387}, NULL) = 0
02:24:17.768387 times(NULL)             = 430253875
02:24:17.768387 gettimeofday({1263752657, 768387}, NULL) = 0
02:24:17.768387 gettimeofday({1263752657, 768387}, NULL) = 0
02:24:17.768387 semtimedop(98304, 0xbfffe7f8, 1, {3, 0}
注意看下时间,14-17相隔3s,也就是ckpt是每3秒响应一次

同时注意oracle系统时间其实是调用操作系统的gettimeofday函数来实现的,也就是说

为什么更改操作系统时间后oracle时间也会改变的缘故

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15072844/viewspace-625339/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15072844/viewspace-625339/