Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: When I COMMIT....

Re: When I COMMIT....

From: klabu <noone_at_gmail_dot_com>
Date: Mon, 6 Nov 2006 17:41:10 -0500
Message-ID: <12kveg7ac6ikq38@corp.supernews.com>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US