Oracle commit and commit work

What is the difference between commit and commit work

Questions by jannaat   answers by jannaat

Showing Answers 1 - 6 of 6 Answers

actaully, both mean the same but try to understand what is commit?
see..most of the people think that when we type commit data or changes of what you have made has been written to data files,but this is wrong when you type commit it means that you are saying that your job has been completed and respestive verification will be done by oracle engine that means it checks whther your transaction achieved consistency when it finds ok it it sends a commit message to the user from log buffer but not from data buffer..so after writing data in log buffer it insists data buffer to write data in to data files....this is how it works

any doubts please revert back to me..............
 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions