Home » RDBMS Server » Performance Tuning » DBWR writes entire dirty block ?
DBWR writes entire dirty block ? [message #400272] Mon, 27 April 2009 07:13 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
The DBWn process writes cold, dirty buffers to disk so that user
processes are able to find cold, clean buffers that can be used to read new blocks into the cache.

^^
I got this regarding DBWR in the Database Concepts guide.

What I am slightly confused about is :
Does the entire block get written or only some part of it ?
I think entire block is written.

If wrong then please correct/guide me ?
Re: DBWR writes entire dirty block ? [message #400302 is a reply to message #400272] Mon, 27 April 2009 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First ALWAYS post a link to the documentation you quote.
Then DBWR process changes with version, so post it too.

Block is the logical unit of io for Oracle.

Regards
Michel

Re: DBWR writes entire dirty block ? [message #400327 is a reply to message #400272] Mon, 27 April 2009 11:30 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/process.htm

I got it from the 9i Concepts guide.
Re: DBWR writes entire dirty block ? [message #400331 is a reply to message #400327] Mon, 27 April 2009 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant a link to what you quote not a whole chapter of 30 pages.
You need to help us help you by provinding the most precise information. If you expect us to make the effort to find what you easily post you will be disapointed and mourn why you have no answer.

Anyway you have the answer but think it for your next question.

Regards
Michel
Re: DBWR writes entire dirty block ? [message #400333 is a reply to message #400272] Mon, 27 April 2009 12:12 Go to previous message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
>I think entire block is written.
Operating system block or Oracle block?
Previous Topic: Hints USE_HASH (merged)
Next Topic: Job queue process takes more then 90 % cpu
Goto Forum:
  


Current Time: Wed Dec 07 14:27:30 CST 2016

Total time taken to generate the page: 0.07382 seconds