GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Oracle

 Print  |  
Question:  When we commit a transaction what sort of things happen in the oracle server ?



April 04, 2006 06:49:18 #2
 sweetytrivedi82   Member Since: April 2006    Total Comments: 1 
RE: When we commit a transaction what sort of things h...
 

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
     

 

Back To Question