What happens in Oracle database when a COMMIT is placed after a UPDATE statement?

  • Interview Candidate
  • 1
  • 2855

Showing Answers 1 - 1 of 1 Answers

innovative

  • Feb 23rd, 2006
 

this que is tricky oneu would have chosen option 1.but take care that the dirty buffers are written only when there is a checkpointsame applies for LGWRin this case server process will place the commit record in the redo log buffer as redo info...then the records are written to the datafiles in case of a checkpoint.....

  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