What commit does in oracle

Source: Internet
Author: User


In oracle, the time used by commit is not affected by the transaction size. The overhead of commit has two factors: the round-trip communication with the database. If each record is submitted, the generated round-trip traffic will be much larger. Each submission must wait for the redo to be written to the disk;
Execute the commit command to generate an scn www.2cto.com lgwr for the transaction, write the cached redo log entries to the disk, and record the scn to the online redo log file; releasing v $ lock records the locks held by our sessions;
If the transaction modified block still exists in the block buffer cache, it will be cleared for later transactions. Lgwr usually takes less time. The reason why this operation time can be greatly reduced is that lgwr has been writing data to the disk in a continuous manner, and we usually wait for lgwr to complete all the write operations, and will be returned only when the data has been confirmed on the disk. PL/SQL provides commit optimization. After pl/SQL routines are completed, when we return data from the database to the client, it needs to wait until the commit call returns immediately.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.