harikrishna

• Apr 24th, 2006

 

when we commit a transaction we cannot undo any information in that transaction.

once commit has been happened in any transaction oreacle server saves all changes done by us and again it wont give permission to us to do any alter or modification

sweetytrivedi82

 Profile Answers by sweetytrivedi82 

• Apr 25th, 2006

 

when a commit occurs in the transaction then the points are as mentioned:-

1)an SCN is created & record in redo log buffer

2)LGWR writes from Redo log buffer to redo log files

3)oracle shows commit complete

4)locks now can be released

vijaydeep

 Profile Answers by vijaydeep 

• Mar 1st, 2009

 

Ends the current transaction by making all pending data changes permanent.
Is the simplest way to define.
Transaction means start with an DML SQL Statement and end with one of the following 
1) A commit or rollback statement is issued, or
2) DML OR DCL Statement executes (AUTO COMMIT) or
3) The System crashes.