Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When I COMMIT....
<fitzjarrell_at_cox.net>
> I'd hate to work where you do if that's the situation.
>
> Xho and others would be correct in presuming that, in a 25 second
> window, your transaction has already committed and is safe within the
> confines of the database. Even if the server and your client are on
> the same power strip, in the same room.
>
> Of course, you'd really need to experience this to know for certain, so
> we'll wait while you test this out and report your findings to the
> group.
>
> Nothing teaches like experience.
yeah, I will do this sometime:
left index finger on the Off-switch of the power strip Right index finger on "Enter" at "SQL> commit;"
press both at same time and see what happens ;)
Now how to suspend/delay the flushing of redo log buffer to redo log files ??? Received on Mon Nov 06 2006 - 16:41:10 CST