How to Turn off Autocommit in Oracle

Written by suvro banerji
  • Share
  • Tweet
  • Share
  • Email

Oracle supports an "AUTOCOMMIT" option in its database product where each individual SQL statement is treated as a transaction and is automatically committed right after it is executed. As a user, you have the option to turn this option on or off based on your preference. When AUTOCOMMIT is turned off, you can allow two or more statements to be grouped into one single transaction. You may require administrative rights on certain computer to complete this task.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Launch your preferred terminal window based on your operating system. If you use Windows, click the Start menu, and type "cmd" in the search box and press "Enter" key. This will launch Command Prompt. If you use Linux, access the terminal window from the "Application" menu on the top bar by either choosing "System Tools" or "Utilities."

  2. 2

    Type the following command:

    SET AUTOCOMMIT OFF

  3. 3

    Press "Enter" key to turn off AUTOCOMMIT.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.