Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When I COMMIT....
"klabu" <noone_at_gmail_dot_com> wrote:
> <xhoster_at_gmail.com>
> > What is the exact timing here?
>
> let's just say right after I hit "Enter" (within .25 secs)
Most likely, the commit has already finished within that time frame.
> my screen goes
> off because someone tripped on the power strip and dislodged
> the jack from the wall socket.
Now it is your local computer that went down? Before, it was the server that went down. In this case, it is almost certain that your transaction has been committed. Oracle usually blocks and/or throws an error immediately if it is going to, rather than delaying an error until commit time. So if your commit get dispatch before you computer died, it is unlikely that that commit didn't get executed. What are the chances that two people tripped over two power cords at the same time? But to be sure you have to figure out if it committed or not by querying the database.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service $9.95/Month 30GBReceived on Mon Nov 06 2006 - 14:19:26 CST