oracle lgwr trace,关于oracle lgwr 历程的一点思考

最新推荐文章于 2023-01-30 11:28:08 发布
最新推荐文章于 2023-01-30 11:28:08 发布
阅读量320 收藏
点赞数
文章标签： oracle lgwr trace

SQL> !ps -ef|grep lgwr

ora10g 23584 1 0 08:36 ? 00:00:00 ora_lgwr_roger

ora10g 23637 23572 0 08:37 pts/1 00:00:00 /bin/bash -c ps -ef|grep lgwr

使用strace -ftr -o a.log -p 23584 跟踪lgwr进程，然后另外开启一个窗口进行如下操作：

1000 rows deleted.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

System altered.

SQL> !ps -ef|grep lgwr|grep -v grep

ora10g 23584 1 0 08:36 ? 00:00:00 ora_lgwr_roger

然后我们再回头去看看strace 打出来的trace是什么样的。

23584 0.000056 gettimeofday({1345909238, 375806}, NULL) = 0

23584 0.000053 times(NULL) = 432511470

23584 0.000071 gettimeofday({1345909238, 375933}, NULL) = 0

23584 0.000060 gettimeofday({1345909238, 375990}, NULL) = 0

23584 0.000059 semtimedop(622592, 0x1, 0, {4294901770, 0}) = -1 EAGAIN (Resource temporarily unavailable)

23584 3.001243 gettimeofday({1345909241, 377292}, NULL) = 0

.....省略部分信息

23584 0.000166 times(NULL) = 432511770

23584 0.000032 gettimeofday({1345909241, 377821}, NULL) = 0

23584 0.000043 times(NULL) = 432511770

23584 0.000031 pwrite64(20, "\1\"\0\0\16\0\0\0\226\0\0\0\20\200\303\265h\0\0\0\4\0\0"..., 921088, 7168) = 921088

23584 0.008318 times(NULL) = 432511771

23584 0.000040 gettimeofday({1345909241, 386276}, NULL) = 0

23584 0.000072 times(NULL) = 432511771

23584 0.000040 gettimeofday({1345909241, 386367}, NULL) = 0

23584 0.000036 getrusage(RUSAGE_SELF, {ru_utime={0, 13997}, ru_stime={0, 66989}, ...}) = 0

23584 0.000048 getrusage(RUSAGE_SELF, {ru_utime={0, 13997}, ru_stime={0, 66989}, ...}) = 0

23584 0.000046 gettimeofday({1345909241, 386496}, NULL) = 0

.....省略部分信息

23584 0.000126 gettimeofday({1345909242, 708436}, NULL) = 0

23584 0.000071 times(NULL) = 432511903

23584 0.000074 times(NULL) = 432511903

23584 0.000054 gettimeofday({1345909242, 708690}, NULL) = 0

23584 0.000134 times(NULL) = 432511903

23584 0.000110 pwrite64(20, "\1\"\0\0\25\7\0\0\226\0\0\0\20\200j\351\214\0\0\0\5\235"..., 512, 928256) = 512

23584 0.000944 times(NULL) = 432511904

23584 0.000062 gettimeofday({1345909242, 709896}, NULL) = 0

23584 0.000089 times(NULL) = 432511904

23584 0.000121 gettimeofday({1345909242, 710096}, NULL) = 0

23584 0.000171 semctl(622592, 23, IPC_64|SETVAL, 0xbfffd4fc) = 0

23584 0.001596 gettimeofday({1345909242, 711864}, NULL) = 0

23584 0.000064 gettimeofday({1345909242, 711935}, NULL) = 0

23584 0.000068 gettimeofday({1345909242, 711992}, NULL) = 0

23584 0.000060 times(NULL) = 432511904

23584 0.000068 gettimeofday({1345909242, 712122}, NULL) = 0

23584 0.000120 gettimeofday({1345909242, 712247}, NULL) = 0

23584 0.000072 semtimedop(622592, 0x1, 670000, {4294901770, 0}) = -1 EAGAIN (Resource temporarily unavailable)

23584 1.671260 gettimeofday({1345909244, 383580}, NULL) = 0

23584 0.000072 gettimeofday({1345909244, 383647}, NULL) = 0

......省略部分信息

23584 0.000462 gettimeofday({1345909247, 141720}, NULL) = 0

23584 0.000106 pread64(15, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\225\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000135 gettimeofday({1345909247, 142041}, NULL) = 0

23584 0.000193 gettimeofday({1345909247, 142133}, NULL) = 0

23584 0.000139 pread64(16, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\225\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000105 gettimeofday({1345909247, 142405}, NULL) = 0

23584 0.000122 gettimeofday({1345909247, 142503}, NULL) = 0

23584 0.000071 pread64(17, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\225\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000093 gettimeofday({1345909247, 143127}, NULL) = 0

23584 0.000576 gettimeofday({1345909247, 143255}, NULL) = 0

23584 0.000087 pread64(15, "\25\302\0\0\20\0\0\0\227\31\0\0\377\377\1\4P\31\0\0\200"..., 16384, 262144) = 16384

23584 0.000237 gettimeofday({1345909247, 143563}, NULL) = 0

23584 0.000156 gettimeofday({1345909247, 143722}, NULL) = 0

23584 0.000464 pread64(15, "\25\302\0\0\22\0\0\0\227\31\0\0\377\377\1\4\vL\0\0\0\0"..., 16384, 294912) = 16384

23584 0.000408 gettimeofday({1345909247, 144677}, NULL) = 0

23584 0.000472 gettimeofday({1345909247, 145071}, NULL) = 0

23584 0.000095 pread64(15, "\25\302\0\0\24\0\0\0\226\31\0\0\377\377\1\4\243R\0\0\17"..., 16384, 327680) = 16384

23584 0.000112 gettimeofday({1345909247, 145282}, NULL) = 0

23584 0.000090 gettimeofday({1345909247, 145358}, NULL) = 0

23584 0.000082 pread64(15, "\25\302\0\0\25\0\0\0\227\31\0\0\377\377\1\4B

23584 0.000181 gettimeofday({1345909247, 145623}, NULL) = 0

23584 0.000083 gettimeofday({1345909247, 145705}, NULL) = 0

23584 0.000230 semctl(622592, 9, IPC_64|SETVAL, 0xbfffe10c) = 0

23584 0.000809 gettimeofday({1345909247, 146745}, NULL) = 0

23584 0.000069 times(NULL) = 432512347

23584 0.000055 pwrite64(15, "\25\302\0\0\26\0\0\0\230\31\0\0\377\377\1\4\362\230\0\0"..., 16384, 360448) = 16384

23584 0.000852 times(NULL) = 432512347

23584 0.000052 times(NULL) = 432512347

23584 0.000053 pwrite64(16, "\25\302\0\0\26\0\0\0\230\31\0\0\377\377\1\4\362\230\0\0"..., 16384, 360448) = 16384

23584 0.000689 times(NULL) = 432512348

23584 0.000057 times(NULL) = 432512348

23584 0.000052 pwrite64(17, "\25\302\0\0\26\0\0\0\230\31\0\0\377\377\1\4\362\230\0\0"..., 16384, 360448) = 16384

23584 0.000612 times(NULL) = 432512348

23584 0.000067 gettimeofday({1345909247, 149302}, NULL) = 0

23584 0.000077 gettimeofday({1345909247, 149402}, NULL) = 0

23584 0.000089 times(NULL) = 432512348

23584 0.000088 pwrite64(15, "\25\302\0\0\21\0\0\0\230\31\0\0\377\377\1\4\10L\0\0\0\0"..., 16384, 278528) = 16384

23584 0.000565 times(NULL) = 432512348

23584 0.000050 times(NULL) = 432512348

23584 0.000052 pwrite64(16, "\25\302\0\0\21\0\0\0\230\31\0\0\377\377\1\4\10L\0\0\0\0"..., 16384, 278528) = 16384

23584 0.000562 times(NULL) = 432512348

23584 0.000051 times(NULL) = 432512348

23584 0.000051 pwrite64(17, "\25\302\0\0\21\0\0\0\230\31\0\0\377\377\1\4\10L\0\0\0\0"..., 16384, 278528) = 16384

23584 0.000616 times(NULL) = 432512348

23584 0.000067 gettimeofday({1345909247, 151570}, NULL) = 0

23584 0.000073 gettimeofday({1345909247, 151643}, NULL) = 0

23584 0.000063 times(NULL) = 432512348

23584 0.000052 pwrite64(15, "\25\302\0\0\17\0\0\0\230\31\0\0\377\377\1\4\317\33\0\0"..., 16384, 245760) = 16384

23584 0.000622 times(NULL) = 432512348

23584 0.000067 times(NULL) = 432512348

23584 0.000091 pwrite64(16, "\25\302\0\0\17\0\0\0\230\31\0\0\377\377\1\4\317\33\0\0"..., 16384, 245760) = 16384

23584 0.000641 times(NULL) = 432512348

23584 0.000051 times(NULL) = 432512348

23584 0.000062 pwrite64(17, "\25\302\0\0\17\0\0\0\230\31\0\0\377\377\1\4\317\33\0\0"..., 16384, 245760) = 16384

23584 0.000649 times(NULL) = 432512348

23584 0.000127 gettimeofday({1345909247, 154107}, NULL) = 0

23584 0.000119 gettimeofday({1345909247, 154198}, NULL) = 0

23584 0.000085 gettimeofday({1345909247, 154271}, NULL) = 0

23584 0.000063 times(NULL) = 432512348

23584 0.000054 pwrite64(15, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.001031 times(NULL) = 432512348

23584 0.000083 times(NULL) = 432512348

23584 0.000056 pwrite64(16, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000639 times(NULL) = 432512348

23584 0.000060 times(NULL) = 432512348

23584 0.000051 pwrite64(17, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000624 times(NULL) = 432512348

23584 0.000088 gettimeofday({1345909247, 157021}, NULL) = 0

23584 0.000065 gettimeofday({1345909247, 157085}, NULL) = 0

23584 0.000065 pread64(15, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000090 gettimeofday({1345909247, 157250}, NULL) = 0

23584 0.000077 gettimeofday({1345909247, 157317}, NULL) = 0

23584 0.000124 times(NULL) = 432512348

23584 0.000092 times(NULL) = 432512348

23584 0.000061 gettimeofday({1345909247, 157594}, NULL) = 0

23584 0.000119 semctl(622592, 23, IPC_64|SETVAL, 0xbfffcfb4) = 0

23584 0.000143 gettimeofday({1345909247, 157857}, NULL) = 0

23584 0.000065 gettimeofday({1345909247, 158008}, NULL) = 0

23584 0.000170 pread64(20, "\1\"\0\0\1\0\0\0\226\0\0\0\0\200\246\270\0\0\0\0\0\5 \n"..., 512, 512) = 512

23584 0.000067 gettimeofday({1345909247, 158151}, NULL) = 0

23584 0.000042 gettimeofday({1345909247, 158200}, NULL) = 0

23584 0.000046 pread64(15, "\25\302\0\0\36\0\0\0\223\31\0\0\377\377\1\4\236\177\0\0"..., 16384, 491520) = 16384

23584 0.000054 gettimeofday({1345909247, 158293}, NULL) = 0

23584 0.000047 gettimeofday({1345909247, 158340}, NULL) = 0

23584 0.000039 pwrite64(18, "\1\"\0\0\1\0\0\0\227\0\0\0\0\200\244\272\0\0\0\0\0\5 \n"..., 512, 512) = 512

23584 0.000504 gettimeofday({1345909247, 158885}, NULL) = 0

23584 0.000078 gettimeofday({1345909247, 158994}, NULL) = 0

23584 0.000084 pread64(20, "\1\"\0\0\1\0\0\0\226\0\0\0\0\200\246\270\0\0\0\0\0\5 \n"..., 512, 512) = 512

23584 0.000050 gettimeofday({1345909247, 159095}, NULL) = 0

23584 0.000041 gettimeofday({1345909247, 159137}, NULL) = 0

23584 0.000039 pwrite64(20, "\1\"\0\0\1\0\0\0\226\0\0\0\0\200u\210\0\0\0\0\0\5 \n)M"..., 512, 512) = 512

23584 0.000874 gettimeofday({1345909247, 160050}, NULL) = 0

23584 0.000052 gettimeofday({1345909247, 160103}, NULL) = 0

23584 0.000041 times(NULL) = 432512349

23584 0.000032 pwrite64(15, "\25\302\0\0\25\0\0\0\231\31\0\0\377\377\1\4\217\234\0\0"..., 16384, 344064) = 16384

23584 0.000816 times(NULL) = 432512349

23584 0.000031 times(NULL) = 432512349

23584 0.000032 pwrite64(16, "\25\302\0\0\25\0\0\0\231\31\0\0\377\377\1\4\217\234\0\0"..., 16384, 344064) = 16384

23584 0.000589 times(NULL) = 432512349

23584 0.000030 times(NULL) = 432512349

23584 0.000031 pwrite64(17, "\25\302\0\0\25\0\0\0\231\31\0\0\377\377\1\4\217\234\0\0"..., 16384, 344064) = 16384

23584 0.000571 times(NULL) = 432512349

23584 0.000036 gettimeofday({1345909247, 162310}, NULL) = 0

23584 0.000044 gettimeofday({1345909247, 162354}, NULL) = 0

23584 0.000054 pread64(15, "\25\302\0\0(\1\0\0\220\31\0\0\377\377\1\4\200L\0\0\n\0"..., 16384, 4849664) = 16384

23584 0.000077 gettimeofday({1345909247, 162488}, NULL) = 0

23584 0.000047 gettimeofday({1345909247, 162532}, NULL) = 0

23584 0.000043 gettimeofday({1345909247, 162575}, NULL) = 0

23584 0.000038 pread64(15, "\25\302\0\0\275\0\0\0\226\31\0\0\377\377\1\4$\177\0\0Y"..., 16384, 3096576) = 16384

23584 0.000052 gettimeofday({1345909247, 162665}, NULL) = 0

23584 0.000042 gettimeofday({1345909247, 162707}, NULL) = 0

23584 0.000038 pread64(15, "\25\302\0\0\25\0\0\0\231\31\0\0\377\377\1\4\217\234\0\0"..., 16384, 344064) = 16384

23584 0.000051 gettimeofday({1345909247, 162796}, NULL) = 0

23584 0.000106 gettimeofday({1345909247, 162904}, NULL) = 0

23584 0.000039 times(NULL) = 432512349

23584 0.000051 pwrite64(15, "\25\302\0\0\276\0\0\0\231\31\0\0\377\377\1\4}\177\0\0Y"..., 16384, 3112960) = 16384

23584 0.000520 times(NULL) = 432512349

23584 0.000030 times(NULL) = 432512349

23584 0.000032 pwrite64(16, "\25\302\0\0\276\0\0\0\231\31\0\0\377\377\1\4}\177\0\0Y"..., 16384, 3112960) = 16384

23584 0.000598 times(NULL) = 432512349

23584 0.000037 times(NULL) = 432512349

23584 0.000031 pwrite64(17, "\25\302\0\0\276\0\0\0\231\31\0\0\377\377\1\4}\177\0\0Y"..., 16384, 3112960) = 16384

23584 0.000507 times(NULL) = 432512349

23584 0.000035 gettimeofday({1345909247, 164782}, NULL) = 0

23584 0.000042 gettimeofday({1345909247, 164825}, NULL) = 0

23584 0.000039 pread64(15, "\25\302\0\0\24\0\0\0\226\31\0\0\377\377\1\4\243R\0\0\17"..., 16384, 327680) = 16384

23584 0.000054 gettimeofday({1345909247, 164917}, NULL) = 0

23584 0.000078 gettimeofday({1345909247, 165000}, NULL) = 0

23584 0.000043 times(NULL) = 432512349

23584 0.000031 pwrite64(15, "\25\302\0\0\23\0\0\0\231\31\0\0\377\377\1\4\246R\0\0\17"..., 16384, 311296) = 16384

23584 0.000568 times(NULL) = 432512349

23584 0.000043 times(NULL) = 432512349

23584 0.000032 pwrite64(16, "\25\302\0\0\23\0\0\0\231\31\0\0\377\377\1\4\246R\0\0\17"..., 16384, 311296) = 16384

23584 0.000458 times(NULL) = 432512349

23584 0.000039 times(NULL) = 432512349

23584 0.000031 pwrite64(17, "\25\302\0\0\23\0\0\0\231\31\0\0\377\377\1\4\246R\0\0\17"..., 16384, 311296) = 16384

23584 0.000543 times(NULL) = 432512349

23584 0.000034 gettimeofday({1345909247, 166819}, NULL) = 0

23584 0.000045 gettimeofday({1345909247, 166863}, NULL) = 0

23584 0.000038 times(NULL) = 432512349

23584 0.000031 pwrite64(15, "\25\302\0\0\22\0\0\0\231\31\0\0\377\377\1\4\3332\0\0\0"..., 16384, 294912) = 16384

23584 0.000697 times(NULL) = 432512349

23584 0.000030 times(NULL) = 432512349

23584 0.000031 pwrite64(16, "\25\302\0\0\22\0\0\0\231\31\0\0\377\377\1\4\3332\0\0\0"..., 16384, 294912) = 16384

23584 0.000509 times(NULL) = 432512349

23584 0.000037 times(NULL) = 432512349

23584 0.000032 pwrite64(17, "\25\302\0\0\22\0\0\0\231\31\0\0\377\377\1\4\3332\0\0\0"..., 16384, 294912) = 16384

23584 0.000565 times(NULL) = 432512350

23584 0.000035 gettimeofday({1345909247, 168867}, NULL) = 0

23584 0.000060 gettimeofday({1345909247, 168933}, NULL) = 0

23584 0.000289 times(NULL) = 432512350

23584 0.000037 pwrite64(15, "\25\302\0\0\20\0\0\0\231\31\0\0\377\377\1\4P8\0\0\200$"..., 16384, 262144) = 16384

23584 0.000525 times(NULL) = 432512350

23584 0.000030 times(NULL) = 432512350

23584 0.000032 pwrite64(16, "\25\302\0\0\20\0\0\0\231\31\0\0\377\377\1\4P8\0\0\200$"..., 16384, 262144) = 16384

23584 0.000576 times(NULL) = 432512350

23584 0.000046 times(NULL) = 432512350

23584 0.000092 pwrite64(17, "\25\302\0\0\20\0\0\0\231\31\0\0\377\377\1\4P8\0\0\200$"..., 16384, 262144) = 16384

23584 0.000630 times(NULL) = 432512350

23584 0.000043 gettimeofday({1345909247, 171228}, NULL) = 0

23584 0.000045 gettimeofday({1345909247, 171272}, NULL) = 0

23584 0.000044 gettimeofday({1345909247, 171316}, NULL) = 0

23584 0.000037 times(NULL) = 432512350

23584 0.000054 pwrite64(15, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000804 times(NULL) = 432512350

23584 0.000038 times(NULL) = 432512350

23584 0.000032 pwrite64(16, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000589 times(NULL) = 432512350

23584 0.000030 times(NULL) = 432512350

23584 0.000031 pwrite64(17, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000606 times(NULL) = 432512350

23584 0.000034 gettimeofday({1345909247, 173571}, NULL) = 0

23584 0.000038 gettimeofday({1345909247, 173609}, NULL) = 0

23584 0.000039 pread64(15, "\25\302\0\0\1\0\0\0\0\0\0\0\0\0\1\4\300\377\0\0\0\0\0\0"..., 16384, 16384) = 16384

23584 0.000054 gettimeofday({1345909247, 173702}, NULL) = 0

23584 0.000040 gettimeofday({1345909247, 173742}, NULL) = 0

23584 0.000040 times(NULL) = 432512350

23584 0.000751 times(NULL) = 432512350

23584 0.000043 gettimeofday({1345909247, 174576}, NULL) = 0

23584 0.000041 semctl(622592, 23, IPC_64|SETVAL, 0xbfffd09c) = 0

23584 0.001190 gettimeofday({1345909247, 175992}, NULL) = 0

23584 0.000242 pread64(15, "\25\302\0\0\36\0\0\0\223\31\0\0\377\377\1\4\236\177\0\0"..., 16384, 491520) = 16384

23584 0.000061 gettimeofday({1345909247, 176111}, NULL) = 0

23584 0.000057 gettimeofday({1345909247, 176175}, NULL) = 0

23584 0.000111 getrusage(RUSAGE_SELF, {ru_utime={0, 15997}, ru_stime={0, 72988}, ...}) = 0

23584 0.000051 getrusage(RUSAGE_SELF, {ru_utime={0, 15997}, ru_stime={0, 72988}, ...}) = 0

23584 0.000045 gettimeofday({1345909247, 176374}, NULL) = 0

23584 0.000078 gettimeofday({1345909247, 176545}, NULL) = 0

23584 0.000155 semctl(622592, 9, IPC_64|SETVAL, 0xbfffe0f4) = 0

23584 0.000165 open("/proc/23604/stat", O_RDONLY) = 32

23584 0.000058 read(32, "23604 (oracle) S 1 23604 23604 0"..., 999) = 190

23584 0.000085 close(32) = 0

23584 0.000115 gettimeofday({1345909247, 177038}, NULL) = 0

23584 0.000049 semctl(622592, 20, IPC_64|SETVAL, 0xbfffe0a4) = 0

23584 0.000624 semctl(622592, 20, IPC_64|SETVAL, 0xbfffe14c) = 0

23584 0.000042 close(8) = 0

23584 0.000035 open("/home/ora10g/admin/roger/bdump/alert_roger.log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 8

23584 0.000062 time(NULL) = 1345909247

23584 0.000040 stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1017, ...}) = 0

23584 0.000146 stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1017, ...}) = 0

23584 0.000071 stat64("/etc/localtime", {st_mode=S_IFREG|0644, st_size=1017, ...}) = 0

23584 0.000064 writev(8, [{"Sat Aug 25 08:40:47 PDT 2012\n", 29}, {"Thread 1 advanced to log sequenc"..., 51}, {"\n", 1}], 3) = 81

23584 0.000074 times(NULL) = 432512350

23584 0.000051 times(NULL) = 432512350

23584 0.000031 close(8) = 0

23584 0.000031 open("/home/ora10g/admin/roger/bdump/alert_roger.log", O_WRONLY|O_APPEND|O_CREAT|O_LARGEFILE, 0660) = 8

23584 0.000063 writev(8, [{" Current log# 1 seq# 151 mem# 0"..., 71}, {"\n", 1}], 2) = 72

23584 0.000072 gettimeofday({1345909247, 178488}, NULL) = 0

.....省略部分信息

23584 0.000057 gettimeofday({1345909247, 179580}, NULL) = 0

23584 0.000197 semtimedop(622592, 0x1, 200000, {4294901770, 0}) = -1 EAGAIN (Resource temporarily unavailable)

23584 0.201062 gettimeofday({1345909247, 380703}, NULL) = 0

.....省略部分信息

23584 0.000068 gettimeofday({1345909247, 382030}, NULL) = 0

23584 0.000047 semtimedop(622592, 0x1, 0, {4294901770, 0}) = -1 EAGAIN (Resource temporarily unavailable)

23584 3.000146 gettimeofday({1345909250, 382231}, NULL) = 0

23584 0.000068 gettimeofday({1345909250, 382295}, NULL) = 0

23584 0.000058 gettimeofday({1345909250, 382353}, NULL) = 0

23584 0.000062 gettimeofday({1345909250, 382415}, NULL) = 0

23584 0.000055 gettimeofday({1345909250, 382548}, NULL) = 0

23584 0.000170 gettimeofday({1345909250, 382644}, NULL) = 0

23584 0.000063 times(NULL) = 432512671

23584 0.000225 gettimeofday({1345909250, 382930}, NULL) = 0

23584 0.000058 gettimeofday({1345909250, 382984}, NULL) = 0

23584 0.000055 times(NULL) = 432512671

23584 0.000065 times(NULL) = 432512671

23584 0.000107 gettimeofday({1345909250, 383219}, NULL) = 0

23584 0.000073 times(NULL) = 432512671

23584 0.000050 pwrite64(18, "\1\"\0\0\2\0\0\0\227\0\0\0\20\200\200oh\0\0\0\4\0\0\0\223"..., 512, 1024) = 512

23584 0.000886 times(NULL) = 432512671

23584 0.000078 gettimeofday({1345909250, 384300}, NULL) = 0

.....省略部分信息

23584 0.000092 gettimeofday({1345909250, 385232}, NULL) = 0

23584 0.000061 semtimedop(622592, 0x1, 0, {4294901770, 0}) = -1 EAGAIN (Resource temporarily unavailable)

23584 3.000481 gettimeofday({1345909253, 385780}, NULL) = 0

.....省略部分信息

23584 0.001228 times(NULL) = 432512971

23584 0.000520 gettimeofday({1345909253, 388094}, NULL) = 0

23584 0.000184 getrusage(RUSAGE_SELF, {ru_utime={0, 15997}, ru_stime={0, 74988}, ...}) = 0

23584 0.000081 getrusage(RUSAGE_SELF, {ru_utime={0, 15997}, ru_stime={0, 74988}, ...}) = 0

23584 0.000183 gettimeofday({1345909253, 388540}, NULL) = 0

.....省略部分信息

23584 0.000141 gettimeofday({1345909253, 389471}, NULL) = 0

23584 0.000079 semtimedop(622592, 0x1, 0, {4294901770, 0}

[root@killdb ~]#

hydroxicacid
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle_db_process.zip_linux oracle_oracle
09-22
5. **进程管理**: 在Oracle中，每个用户会话对应一个后台进程，如用户进程（USER PROCESS）、服务器进程（SERVER PROCESS）、检查点进程（CKPT）、日志写入进程（LGWR）等。理解这些进程的作用和交互对于性能调优至...
oracle跟踪文件与跟踪事件(zt)
08-03 339
一、Oracle跟踪文件Oracle跟踪文件分为三种类型，一种是后台报警日志文件，记录数据库在启动、关闭和运行期间后台进程的活动情况,如表空间创建、回滚段创建、某些alter命令、日志切换、错误消息等。在数据库出现故障时，应首先...
Oracle 服务器结构
weixin_33795806的博客
09-26 199
  【学习目标】         作为一个数据库管理员（DBA），经常会遇到各种没有见过的问题。除了宝贵的经验外， 通过理论基础去对问题进行判断、解决是至关重要的。因此，Oracle 服务器的结构和组成 是学习Oracle 数据库必不可少的基础知识，所以本章内容对于学习以后章节的内容都是至 关重要的。         本章主要介绍Oracle 服务器的结构和组成，对Oracle 服务器从...
Oracle 的联机日志文件
Multis
01-30 1184
联机日志文件又叫重做日志文件，记录了对数据库修改的信息，一个 Oracle 实例有一组或多组联机日志文件，每组包含一个或多个日志成员，同一组的日志成员内容相同，存放位置不同，防止日志文件组内某个日志文件损坏导致数据丢失。
oracle11g 联机重做日志、归档日志、日志文件组以及日志文件操作
热门推荐
不是一枚开发
03-20 7万+
文章目录一.归档方式1.1 联机重做日志、归档日志概念1.2 工作模式1.3 数据库恢复1.4 启用归档模式(1)关闭数据库：(2)启动数据库到mount状态（控制状态已经打开，用户信息仍然不能查看）：(3)配置归档模式并打开数据库：(4)查看归档状态(5)查看归档文件被存放的路径以及存放文件的容量：(6)手动进行日志切换：(7)log_archive_dest参数，查看归档目录路径和状态：(8)修改归档目录路径(9)设置多个归档目录,每个归档目录存储的内容是一样的(10)修改归档目录状态 defer (表
log file sync（ 日志文件同步）等待事件
鲨鱼胃的博客
05-09 4307
log file sync等待事件发生 log file sync等待事件发生在redo log从log buffer写入到log file期间。 在一个提交（commit）十分频繁的数据库中，一般会出现log file sync等待事件，当这个等待事件出现在top5中，这个时侯我们需要针对log file sync等待事件进行优化，一定要尽快分析并解决问题，否则当log file sync等待时间从几毫秒直接到20几毫秒可能导致系统性能急剧下降，甚至会导致短暂的挂起。 何时发生日志写入 1.commit或
Oracle 11g DataGuard配置过程_CentOS1
08-08
tail -f /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log ``` 配置 Oracle 11g DataGuard 需要遵循一定的步骤和要求，包括安装前准备、hosts 文件、环境变量、RMAN+DUPLICATE 命令、DataGuard ...
Oracle10g数据库系统性能优化与调整.pdf
10-10
Oracle 10g数据库系统是企业级应用广泛的关系型数据库管理系统，其性能优化与调整对于保证系统的高效运行至关重要。随着数据库的数据量增大和并发用户数量增多，系统可能会遇到吞吐量降低、响应时间延长等问题，这...
Oracle数据库日常维护手册(最全+最实用).docx
05-04
- **检查ORACLE服务进程**：通过`ps -ef | grep ora_`可以列出所有Oracle相关的进程，确保关键进程如DBWR、LGWR、PMON等都在运行。 - **检查ORACLE监听状态**：使用`lsnrctl status`命令检查监听器的状态，确认...
[Oracle.11g权威指南（第2版
05-09
《Oracle.11g权威指南（第2版》是一本深度解析Oracle 11g数据库系统的专业书籍。Oracle是全球最广泛使用的数据库管理系统之一，尤其在企业级应用中占据主导地位。11g版本作为Oracle数据库的一个重要里程碑，引入了...
oracle重做日志原理
05-22
oracle重做日志原理
oracle lgwr trace,10.2.0.4 LGWR Trace Warning: Log Write Time
weixin_31444279的博客
04-09 152
10.2.0.4 LGWR Trace Warning: Log Write Time*** 2009-10-19 13:13:51.534Warning: log write time 720ms, size 3KB*** 2009-10-20 10:33:27.372Warning: log write time 510ms, size 2KB*** 2009-10-21 02:00:01.1...
Oracle数据库服务器IO高的分析方案和案例探讨
coco3600的博客
04-12 1533
Oracle数据库服务器IO高的分析方案和案例探讨 本文原题《ORACLE数据库服务器IO高的分析方案和案例探讨》 目录：...
oracle DG 日志传输小结
weixin_43869703的博客
10-18 917
oracle dg日志传输记录
oracle lgwr trace,LGWR trace文件一直Warning,怎么回事？
weixin_39607935的博客
04-09 165
文件内容如下：/usr/oracle/app/oracle/admin/ora10g/bdump/ora10g_lgwr_1538.trcOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Appli...
oracle 日志切换太频繁,日志组切换频繁，LGWR总处于等待
weixin_42099116的博客
04-06 798
1、如果日志组切换频繁(最好控制在30分钟左右一次)，需要增加成员的大小。2、LGWR总处于等待状态(主要为：归档中还没释放日志组)，需要增加日志组。(判断等待是否是因为归档没释放方法1)是否为归档模式(只有归档模式才会发生，如果为非归档模式，下面的就不用看了)C:\Documents and Settings\Administrator>sqlplus /"as sysdba"SQL&gt...
oracle等待进程为lgwr,Oracle 后台进程（三）LGWR进程
weixin_32135505的博客
04-05 1040
一、LGWR进程简介LGWR，是Log Writer的缩写，也是一种后台进程。主要负责将日志缓冲内容写到磁盘的在线重做日志文件或组中。DBWn将dirty块写到磁盘之前，所有与buffer修改相关的redo log都需要由LGWR写入磁盘的在线重做日志文件(组)，如果未写完，那么DBWn会等待LGWR，也会产生一些相应的等待事件(例如：log file prarllel write，后面单独作为话...
oracle进程什么时候,Oracle LGWR进程跟踪
weixin_33454551的博客
04-03 149
Oracle LGWR进程跟踪Oracle LGWR进程在正常情况下有以下条件被唤醒:每三秒,写满logbuffer 1M,log buffer空间写满了三分之一,用户提交和其他进程通知需要写出log buffer(比如 dbwr进程在写出数据库块,都要通知LGWR进程先把对应的redo写出).基本过程如下:用户进程发布提交请求=>LGWR进程被唤醒=>LGWR进程发布IO调用写出lo...
oracle多进程阻塞,lgwr进程堵塞session的commit，但是lgwr本身是空闲等待
weixin_33296185的博客
04-03 747
本帖最后由 running_life 于 2017-5-15 11:05 编辑环境：rhel6.311.2.0.4.4rac情况描述：接到预警信息，session中有55个log file sync，查询blocker为lgwr，但是lgwr进程本身是空闲等待，且执行其他新的dml语句，commit正常。另外，在半个小时前重启过该库的adg，同步模式是async的。现在已经堵塞了很久了，只...
oracle lgwr async dg需要手动触发alter system switch logfile
最新发布
06-07
在 Oracle 数据库中，启用异步日志传输 (async) 的 Data Guard 环境中，可能需要手动触发 "alter system switch logfile" 命令，以确保主库的日志能够及时传输到备库并应用到备库上。 异步日志传输是指主库将日志...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值