借老郭的上图,说明一下: vcD4KPGgzPlVQREFURdPvvuS007Xa0ruyvbW9tdq+xbK9tcS21NOmysejujwvaDM+CrXa0ruyvaO6vau4/LjEtcTK/b7dtOa3xbW9UEdBICA8YnI+CrXatv6yvaO6vatCVUZGRVIgQ0FDSEXW0L7Jyv2+3b+9sbS1vbmyz+2z2LXEy73T0ElNVSBidWZmZXI8YnI+CrXayP2yvaO6vatQR
借老郭的上图,说明一下:喎?http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPGgzPlVQREFURdPvvuS007Xa0ruyvbW9tdq+xbK9tcS21NOmysejujwvaDM+CrXa0ruyvaO6vau4/LjEtcTK/b7dtOa3xbW9UEdBICA8YnI+CrXatv6yvaO6vatCVUZGRVIgQ0FDSEXW0L7Jyv2+3b+9sbS1vbmyz+2z2LXEy73T0ElNVSBidWZmZXI8YnI+CrXayP2yvaO6vatQR0HW0NDeuMS687XEyv2+3bTmt8W1vXByaXZhdGUgcmVkbzxicj4KtdrLxLK9o7rQ3rjEYnVmZnJlIGNhY2hl1tC1xMr9vt08YnI+Cteio7rO0sq10enBy9f2tb3V4tK7sr2jrNa00NB1cGRhdGXT777kuvPRuMvZo6gzw+vE2qOptcS9+NDQRFVNUCBSRURPIExPR0ZJTEW1xLLZ1/ejrLTTRFVNULP2tcTOxLz+1tCjrMrH1dKyu7W9tMvKws7xtcRSRURPyNXWvsz1xL+hozxicj4K1/bM4b27stnX97rzo7o8YnI+CrXazuWyvaO6tNNJTVXW0L+9sbTQ3rjEx7AmIzIwNTQwO7W9QlVGRkVSIENBQ0hF1tC5ub2o0ru49kNSv+ktLS0tLby0yrnOtMzhvbvKsVNNT07DvzPD69Kyu+HX9rTLuaTX9zxicj4KtdrB+bK9o7q12svEsr3Q3rjE0N64xGJ1ZmZyZSBjYWNoZdbQtcTK/b7dsvrJ+rXEcmVkb8jV1r7QtMjrcmVkbyBsb2cgZmlsZTxicj4KtdrG37K9o7q12s7lsr2y2df3ubnU7ENSv+mjrLL6yfq1xHJlZG/I1da+0LTI6yByZWRvIGxvZyBmaWxlPGJyPgq12rDLsr2jutPJbGd3ctC0s/Zsb2cgYnVmZmVytb1yZWRvIGxvZyBmaWxlPGJyPgo8cD612r7Fsr2jumRid3IgvavU4Mr9vt3QtMjrZGF0YSBmaWxlPC9wPgo8cD7KtdHpsr3W6KO6PGJyPgo8L3A+CjEyOjEyOjA0IEJZU0AgYnlzMyZndDtzZWxlY3QgYS5ncm91cCMsYS5zZXF1ZW5jZSMsYS5hcmNoaXZlZCxhLnN0YXR1cyxiLnR5cGUsYi5tZW1iZXIgZnJvbSB2JGxvZyBhLHYkbG9nZmlsZSBiIHdoZXJlIGEuZ3JvdXAjPWIuZ3JvdXAjOzxicj4KICAgIEdST1VQIyAgU0VRVUVOQ0UjIEFSQyBTVEFUVVMgICAgICAgICAgIFRZUEUgICAgTUVNQkVSPGJyPgotLS0tLS0tLS0tIC0tLS0tLS0tLS0gLS0tIC0tLS0tLS0tLS0tLS0tLS0gLS0tLS0tLSAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08YnI+CiAgICAgICAgIDEgICAgICAgIDMzNCBOTyAgQ1VSUkVOVCAgICAgICAgICBPTkxJTkUgIC91MDEvb3JhZGF0YS9ieXMzL3JlZG8wMS5sb2c8YnI+CiAgICAgICAgIDIgICAgICAgIDMzMiBZRVMgQUNUSVZFICAgICAgICAgICBPTkxJTkUgIC91MDEvb3JhZGF0YS9ieXMzL3JlZG8wMi5sb2c8YnI+CiAgICAgICAgIDMgICAgICAgIDMzMyBZRVMgQUNUSVZFICAgICAgICAgICBPTkxJTkUgIC91MDEvb3JhZGF0YS9ieXMzL3JlZG8wMy5sb2c8YnI+CkVsYXBzZWQ6IDAwOjAwOjAwLjAzPGJyPgoxMjoxMjowOSBCWVNAIGJ5czMmZ3Q7c2VsZWN0ICogZnJvbSBkZXB0Ozxicj4KICAgIERFUFROTyBETkFNRSAgICAgICAgICBMT0M8YnI+Ci0tLS0tLS0tLS0gLS0tLS0tLS0tLS0tLS0gLS0tLS0tLS0tLS0tLTxicj4KICAgICAgICAxMCBBQ0NPVU5USU5HICAgICBORVcgWU9SSzxicj4KICAgICAgICAyMCBSRVNFQVJDSCAgICAgICBEQUxMQVM8YnI+CiAgICAgICAgNDAgT1BFUkFUSU9OUyAgICAgQk9TVE9OPGJyPgogICAgICAgIDExIGRhdGFiYXNlICAgICAgIGRhdGFiYXNlPGJyPgogICAgICAgIDIyIGRhdGFvcmFjbGUgICAgIHNoPGJyPgpFbGFwc2VkOiAwMDowMDowMC4wMTxicj4KMTI6MTI6MjQgQllTQCBieXMzJmd0O3VwZGF0ZSBkZXB0IHNldCBkbmFtZT0="mysql' where deptno=11;
1 row updated.
Elapsed: 00:00:00.01
12:12:29 BYS@ bys3> ---UPDATE语句完成的时间是:12:12:29,只做UPDATE语句,不要提交,立刻去DUMP REDO LOGFILE.
执行完此操作迅速(3秒内)的进行DUMP REDO LOGFILE的操作,从DUMP出的文件中,是找不到此事务的REDO日志条目。有兴趣的可以做一下试试。
如果过3秒后,再执行DUMP REDO LOGFILE的操作,从DUMP出的文件中,可以看到此次操作的信息:--怎么感觉这样不太严谨REDO RECORD - Thread:1 RBA: 0x00014e.0000000e.0010 LEN: 0x01bc VLD: 0x0d
SCN: 0x0000.00736971 SUBSCN: 1 01/09/2014 12:12:31 --时间与12:12:29对比,刚好是3秒,但是这一点好像不绝对,其它实验中有间隔5秒直到发出COMMIT才产生日志的。--不确定看这个地方对不对呢?