The trusted standard commit command is the same as commit write immediate, wait, but there are three other alternatives. Each can be put into effect in any of the following ways:

The following snippet shows the various ways to interactively use and set the commit_write options to an immediate and nowait setting.

This snippet first shows the current commit_write setting, which is null, meaning it has not been set. The second entry alters only the session, and the third alters the entire instance. Then the parameter is once again shown to reflect the alterations. Finally, the modified commit statement was entered directly, overriding any instance parameter, session, or system setting.