COOLINTERVIEW.COM ORACLE DETAILS

Question :

What happens next when a server process is not able to find enough free buffers to copy the blocks from disk?

Answer :

To reduce I/O contention, the DBWn process does not write the changed buffers immediately to the disk. They are written only when the dirty buffers reach a threshold or when there are not enough free buffers available or when the checkpoint occurs. the server process ask DBWR to write the changes to disk in order to free the space in buffer cache.  Posted by: geetu gaur       Contact Author © CoolInterview.com Today's Special: Get Free Magazine from SAP now! A D V E R T I S E M E N T

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question

   

Category	Oracle Interview Questions
Rating	(0.0) By 0 users
Added	7/7/2005
Views	801
Rate it!	* * * * * * * * * * * * * * *
Free Offers	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: