Waht is the frequency of log Updated..?

Whenever commit,checkpoint or redolog buffer is 1/3rd full

Showing Answers 1 - 2 of 2 Answers

SALIH

  • Dec 15th, 2005
 

1.COMMIT or ROLLABCK

2.time out occurs (3 secs)

3 1/3 of log is full

4. 1 mb of redo

5. Checkpoint occurs

  Was this answer useful?  Yes

Jayesh Patel

  • Oct 9th, 2007
 

LGWR writes:

1) COMMIT/ ROLLBACK

2) 1 MB of large transaction

3) Before DBWR writes

4) 1/3 of REDO LOG is full
5) time out occurs
6) Check Point encounters

  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