So an another year is on the verge of being over and another new year is knocking on the door. Its that time of the year again to say goodbye to the old one and welcoming the new one with the open arms with a hope that it would bring a lot of happiness, success and good health for all of us.So from me, a very happy and prosperous 2012 to the entire Oracle community :-). Hope in this year, we shall see a lot of new and exciting stuff ( as like always) from Oracle database side , giving us all new stuff to learn and play with. And how can I skip, Cloud Computing! Now that’s something that would be really interesting to watch out , isn’t it :-)?
You may also like...
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
The question is not related to your this blog. It is a general doubt about Checkpoint design in oracle.
How Oracle takes care or Partial page write problem?
I have searched in net alot but didn’t got concrete answer about it.
I will be very thankful if you can let me know something about it.
What is “partial page write” ? I am not sure that I have ever read or heard it within oracle db. Are you sure that this term is related to Oracle db or picked up from somewhere else, in context to some other db?
This is a generic Disk I/O problem which all databases have some solution. “Partial Page Write” term is used in PostgreSQL DB.
I shall try to explain what I want to know:
During checkpoint, when DBWn process tries to flush any page to disk, if during flush the system goes off; then chances are there that only half the block is written.
Now next time when database comes up it will find that page as corrupt.
So other databases have some solution to address this problem(mainly to maintain a duplicate copy of page).
I wanted to know how Oracle address this issue?
Its not a “generic problem” of all the databases, at least not of Oracle database. I guess you should read this. It would be better than me writing about it again.
I was thinking and reading about this from some time but from nowhere got the concrete answer.
I got it how oracle handles this situation.
In the meantime I thought I’d solve the partial page write by wishing everyone a FULL happy new year 🙂