Monthly Archives: February 2010

Want To Become Oracle Certified? Do It ASAP Because….

Oracle University has announced that they are going to increase the prices of their exams from March 1,2010! You can read the complete information from this post.

Well, this was about the announcement, now a little rant! I am not sure that whether this price hike is actually correct or not? If one looks at the prices of the courses, combines it with the logistic charges, add to it the prices of the exams, the sum total becomes sky high! And this is when the exam fee is still the same. So when the exam fee would be increased, I am not sure how many would be really interested to take up the exams since I hear all the time at the moment even that the prices are very high! Agreed that the price hike would vary from country to country(which I don’t understand why but that’s another rant to talk about I guess) still, it would effect in an overall manner a lot! Not sure what’s good is going to come out from this but I believe its going to demoralize those new aspirants who want to get certified! I just hope that it won’t happen because doesn’t matter what anyone would say, Oracle Certification program is still is the best way to learn and demonstrate one’s passion about learning Oracle! Okay rant over!!

If you want to get certified and are delaying it, probably the time has come that you speed up your preparation process and write the exams as soon as possible! And this makes me recall that I need to do the same as well :-( !

Confused About DataGuard, Issues With It, Share/Discuss/Get Clarifications At….

Data Guard forum at OTN forums! It just has come up and based on the discussion happened here, I believe its the fruit of the efforts done by the product manager of Data Guard Larry Carpenter who is also the lead author of Data Guard Handbook from Oracle Press! I am quite active over OTN forums and based on my experience over there, I can say with complete trust that alike other forums like Database General and many more, this would also help Oracle community immensely! Another bookmark added to my daily-visit sites :-) !

Redo & Undo, Partners In Crime Talked About Yet Again….

Anyone who does know about Oracle db and its working even the slightest bit would have heard about these two words for sure, Redo and Undo! Both make Oracle db what it is, a very robust data engine and also come out as one of the most complex algorithms to understand within the same. Almost all the time, there is some confusion that’s there about these two and I am sure, both will be a very hot topic of discussion for many many years yet to come!

I am quite active on OTN Forums ( and no that’s not an excuse of being less active here) and at times, there are some very interesting questions which do pop up there. One such question about Redo, which obviously would include Undo as well did come out few days back over this thread, why not use Redo log for consistent read. Now, it shouldn’t come out as a surprise that why Redo can’t be used if one understands the way it works but it was still a very interesting topic to jump into since the way Oracle db works is one of my favorite areas. So I did try to explain it somewhat. If you think that you don’t know the answer or even if you know you do, I would welcome you to read the thread! As like always, any corrections wherever needed and possible are most welcome!

Though the thread went to great lengths, still I fee that the underlying answer was not really what it should had been. I am sure the reason is my not-so-deep understanding about Oracle db only since I was the one who did give maximum replies there. But I guess, the topic was actually good because of which, Jonathan Lewis, probably the best and the most knowledgeable person over this planet about Oracle, did pick the question and gave the actual (and an awesome one) and very detailed answer over here. I would recommend you to read the complete blog post which clears the concept completely that why Redo should NOT be used for read consistency and Undo should be! Thanks so much Jonathan for such a brilliant explanation!

I am pretty busy at the moment( and no, this is also not the reason for being less active here) because there is a very important writing assignment I am working over but I shall try to write soon about some of these basic concepts over here! Hope that “soon” happens soon :-) !