Between commit and commit complete

What happens in between a commit and a commit complete internally?

    Requires Free Membership to View

    Login

The biggest thing that happens is that Oracle writes the changes to the online redo log files along with a commit marker for this transaction. A commit is not complete until this information has been written to the online redo log files. This way, if the database were to crash, the transaction could be recovered since it has been written to disk.

This was first published in September 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top