Re: When I COMMIT....

Yes, the transaction would be gone as if the transaction is not commited. If it did commit, and the redo logs show a completed transaction, it will be rolled forward and applied if the entire transaction can be applied, otherwise no transaction. Without app side logging the transaction is gone 100% from the database if not written in redo.

See Chapter 9, Expert Oracle Database Arch 9i/10g, by tkyte for some good examples. Page 290 describes a similar situation.

klabu wrote:
> Say if when i hit "Enter" on "commit ;", someone tripped on the power cord
> of the database box..
>
> Is it possible I'd lose 100% of that tranaction without ANY possibility of
> recovery.
>
>
> thanks
> --
> 10gR2
Received on Mon Nov 06 2006 - 09:28:41 CST