Archive for March, 2009

Officially 11g Certified Today….

I had taken my OCP New Features exam some time back.  I am not sure but now I guess, Oracle certification delivery team sends a mail to confirm the address before sending the actual certificate. Probably its to avoid the hassles that happen when they send and people argue that  they never received it , anyhow its a good thing IMO. So I got my success kit delivered to me today. I must say, its always a  very sweet feeling when ever I see my certificate. Its the same feeling all the time when I had received it for the very first time :-) . So today, officially I am 11g certified database administrator! Sounds cool right ;-) !

12 Comments

MOSC….

Change is always welcome. Its the sign that some thing is moving, some thing is getting improved. With change, there are always chances for new ideas to get born and groom. By constantly changing the way things are working, we always can make our work, life more better. To sum up, to grow, become more error-free, a change is required.

But as it is said, there is nothing always black or white. There are always exceptions to every rule. I mentioned above change as its need in our lives. Does it mean we should get married to a new person every other year to make our lives more better ? Heck no! And there are some rules which work forever. One out of those rules is, if some thing is not broken , don’t try to fix it. We need change but it should be done if there is a need to bring it. It should not be done just to make sure that no one sits idle and there should be some work for people to do, doesn’t matter its useless work too.
When OTN Forums( http://forums.oracle.com) got upgraded( or degraded, whatever you may want to call it, suit yourself) and the new point system got introduced, there was a huge hue and cry among many people. Some liked it , some hated it, some didn’t bother. Many blog posts were written talking about its pros/cons, many threads were created over Forums to understand/protest/suggest about it. I am not going to write another post talking about the same thing. I chose to be neutral about it. There is no need to shout over something which we can’t change. I like/dislike point system, it won’t make any difference to OTN team and in their decision to bring it or discard it. Infact, I guess with some exceptions like repeated posts to get points, people not bothering about giving points to right answers, this point system have proved to be good. I know couple of posters whose question count is in thousands. With the previous method of making someone a top user with only number of posts, they could had become top user as well with no benefit to others. They just ask questions, don’t contribute by helping others and that’s what a top user(s) should do. So with point system, only “noisy” people got sacked from the top user listing. Though its not the NYSE listing ,dropping from which can give some one a heart attack but still, now the list is having those who really spend time to give answers. Okay, there are still debates, arguements about some posters that they don’t do the right thing and have attained points by repeated posts. But I guess, there is no system which is totally error-free. So to sum up , this change over the OTN Forums was a welcome change, atleast for me( and if I don’t mention the sluggish performance of forums afterwards, another topic and may be another day).

But one ketchup doesn’t suit all the dishes does it?  I was browsing over Twitter and I read a link which Eddie posted,

http://www.dba-oracle.com/oracle_news/news_oracle_support_community.htm

WTH! So it means that now over Metalink too, there will be point system? So what would be the metalink support analysts will do? What if some one who is not from Oracle support attains more points than anyone ?Should we start listening to him/her and leave what Support people say as they don’t have “enough points” to prove that they are right? There is so much debate that people are striving to become top users over OTN forums. Now what would happen, if some one from Support or not from Support would come and try the same?I have not seen the interface of this MOSC yet but if its the same like OTN than what if someone finds an answer from someone rude and reports it as abuse? Would that person be banned from Metalink as one can be from OTN? Not to forget about the requirement to use Flash to use the new interface! Some thing which didn’t require any fix got “fixed” and now everyone is in a “fix” what would happen next?

I don’t think that this was needed at all. There may be something better in someone’s mind who suggested , implemented all this. But I believe, some times , simple is better. I still like my normal Nokia8210 the most, doesn’t matter what Iphone has brought up? Not so modern may be I am!

No Comments

Certification, What, Why, How….

Oracle Certification is among the most popular and most highly rated certifications worldwide. A lot of people write different exams and there are many many so far who have got certified. I am asked a question many times that how one should prepare for it and is it really worth to prepare for it as well? I shall try to put my thoughts about the question which I hope shall help others in taking right decision when then they will have it in their mind.

What is certification ( not just of Oracle but any)

Certification is a means to tell others that you have prepared about a certain topic and you have demonstrated to be good in it by clearing the exam which was conducted by the product vendor itself. Who else will be the better one to judge your skills than those who actually prepared it? When you clear a certification, its a reflection of your commitment and sincerity that you wanted to be acquainted with the knowledge of that module/track , you prepared for it and cleared it. So a certification is this only. It doesn’t show that you have a complete mastery of that module( it was never prepared to reflect that in the first place). No one , after clearing an exam of any kind in any industry can say that he/she is an expert of said technology. In an exam of few hours/days, its not possible to put all the scenarios , environments, issues which are out there in the real world. There are always new challenges which arise with the ever growing and improving technology. Can you imagine that someone can claim that he/she is the best architect in the world because he/she has cleared his/her Civil Engineering? Nope that’s next to impossible. An exam check certain basic and to some extent, some medium level information which any professional of that technology must have. So assuming in your mind that just because you have cleared an exam, now you are supposed to be called or should be considered as an Guru in that module is simply living in a fallacy. The same hold true for the score as well. Does the person who scores just the passing scores is inferior to the one who scored it 100%? I don’t think so? I know many so who are not good in the cramming of the stuff and because , most of the exams, both academic and professional, are having a huge content which is based on the cramming of some fine points of the material, don’t score well. They do pass the exam but not with 100%. There are many who are good in remembering the stuff and score much high. But the former, most of the time are very good in the practical implementation of the technology and thus are more useful to the real world than those who merely score high but are not so good in the practicals, an essential skill to have in the real world. If one can be good on both the aspects, nothing like that, but score alone too doesn’t prove that you are good/better/best/average.

The above said applies completely to Oracle certification and over its various tracks as well. Oracle has prepared couple of tracks which checks a person’s basic and medium level efficiency. From the induction of the Oracle Certified Masters track, now the practical aspects of the person’s knowledge is also getting verified. But as this is the last level of the certification, one must clear all the previous levels before going for it. Even if you clear the most basic level certification, Oracle Certified Associate, or clear OCM, don’t get into the trap of assuming that you know it all. You don’t, no one does. Learning is a constant process which must continue. Steve Jobs(Apple) said once in a speech, “stay hungry , stay foolish” and I guess, this sums up everything.

Is it really worth of the effort?

Well, let me ask you a question before I attempt to take this question. There is a surgeon who is certified to operate you but he never did any real time surgery so far, will you let him touch you? Here is one more, there is a person who assisted a surgeon for many years and knows almost all about it but he is not certified, is not holding a degree which authenticates that he can operate over others, will you let him touch you? Tough question! Well, I guess you should have got the answer. Read above to know what is a certification? Its just a reflection of the sincerity of yours about the technology. You want to stay current with the technology that’s why you took up all the new features exams. By being certified over multiple versions doesn’t mean that you know about them, all the features of every version. So than what’s the worth of being certified, to put in all the efforts, burn the mid night oil for it? Because, being certified gives you a confidence, a feeling that you have put in some efforts to know about the know-hows of the module. Because this would show others the same as well. And think about it, is it going to do any harm to you if you will get an authentic piece of paper which would say that you are now a certified professional in the mentioned track, no I don’t think so? If it won’t hurt you than why not go for it? I can assure you that by preparing for the exan, there would be atleast one thing new that you would learn because the exams are not just focussed over a certain area or section of the topic but they cover it all(at least most of it). So it may happen that today you are not using Automatic Storage Management in your company but you have studied about it in your exam, this would give you a fare idea what you are dealing with when in the next project or company you are going to shake hand with it. And as like its said all the time, the worst thing is not to try and fail but not trying at all! If you are certified plus you have experience on the technology as well, you got it all covered. In case you are just starting and have a certification, you have shown to your future employer(s) that you are serious about this field and you have already started preparing yourself for it. So yes, its actually will be the worth of your effort, may not be directly but in other ways, but it surely will be worth of the entire time , effort and of course money spent over it.

How shall I prepare for it, the best way to make sure that I pass it for sure?

Hmm are there any global rules to make a successful marriage ? No right? What worked for me, may not work for you. So I guess the same is applicable about the preparation strategies as well. All have a different way of study the stuff, some start from theory than do the demos. Some start things with the action first, they want to see it happening first. Once they know that what ever is in the material actually runs, than they start with the theory. So there is no such one rule or methodology to follow to prepare for the certication tracks. Make it sure that you can’t skip anything, be it theory, be it practicals, anything and everything will be in the exam. So anyone who is just thinking that merely cramming the book is enough, or on the other hand, some one who thinks that he knows it all how to make the stuff work , doesn’t need to read about the theory at all, both will have a tough time in the exam. You need to prepare the material in both practical and theoretical aspects. It is always helpful to check with other sources as well about the topics. You need to cover it all if you want to have good hopes that you would clear the exam. I shall suggest one thing though, preparation will be much easier if you can find a partner with you. If prepared as a team, the process becomes amazingly interesting and easy. So besides finding the technical resources, try finding someone who can prepare with you for the same topic. I can assure you , you won’t regret.

Final words

So here is a long winded answer of mine(an attempt at least) for some common questions that I get about the certification all the time. I hope it answers to some extent about the above mentioned topics. Before I conclude, its worth to mention that Joel Goodman wrote a very good piece of note about the same topic which is a must read. Here is the link to it.

http://dbatrain.wordpress.com/2009/03/03/preparing-for-oracle-dba-certification-tests

I wish you all best wishes for your preparation. Do leave a note here if you think anything more can be added to the topic. Good luck for your preparation and hope you get it with flying colors.

4 Comments

Fixed Table Definitions, A New Learning….

Whenever I used to find out the info of any fixed table(x$) I used to do this by a workaround. I used to set the trace, run the query and see the table’s name. For example, if we are looking for the V$log’s fixed table name so I would do something like that ,

SQL> select * from  V$log;

Execution Plan

———————————————————-

Plan hash value: 2536105608

——————————————————————————–

————

| Id  | Operation                | Name            | Rows  | Bytes | Cost (%CPU)

| Time     |

——————————————————————————–

————

|   0 | SELECT STATEMENT         |                 |     1 |   185 |     0   (0)

| 00:00:01 |

|   1 |  NESTED LOOPS            |                 |     1 |   185 |     0   (0)

| 00:00:01 |

|*  2 |   FIXED TABLE FULL       | X$KCCLE         |     1 |   136 |     0   (0)

| 00:00:01 |

|*  3 |   FIXED TABLE FIXED INDEX| X$KCCRT (ind:1) |     1 |    49 |     0   (0)

| 00:00:01 |

——————————————————————————–

————

(output trimmed)
So I got that x$kccle and x$kccrt are driving it. Well not a bad way IMO.
Till today….
When I found this note,
So there is actually a view which tells us the description of the fixed tables, cool! So doing the same from here,
SQL> select view_definition
2  from v$fixed_view_definition where view_name=’V$LOG’;
VIEW_DEFINITION
——————————————————————————–
select   GROUP# , THREAD# , SEQUENCE# , BYTES , MEMBERS , ARCHIVED , STATUS , FI
RST_CHANGE# , FIRST_TIME from GV$LOG where inst_id = USERENV(’Instance’)
SQL> select view_definition
2  from v$fixed_view_definition where view_name=’GV$LOG’;
VIEW_DEFINITION
——————————————————————————–
select le.inst_id, le.lenum, le.lethr, le.leseq, le.lesiz*le.lebsz, ledup, decod
e(bitand(le.leflg,1),0,’NO’,’YES’), decode(bitand(le.leflg,24), 8, ‘CURRENT’,
16,’CLEARING’,                            24,’CLEARING_
CURRENT’,        decode(sign(leseq),0,’UNUSED’,        decode(sign((to_number(rt
.rtckp_scn)-to_number(le.lenxs))*        bitand(rt.rtsta,2)),-1,’ACTIVE’,’INACTI
VE’))), to_number(le.lelos), to_date(le.lelot,’MM/DD/RR HH24:MI:SS’,’NLS_CALENDA
R=Gregorian’) from x$kccle le, x$kccrt rt where le.ledup!=0 and le.lethr=rt.rtnu
m and  le.inst_id = rt.inst_id
SQL>
Voila! We got the fixed table’s names and much more info about how they are being used. Cool! Its always better to take a straight way rather than a workaround. Learned some thing new today :-) .

2 Comments

11g New Features Exam, A Roadmap….

I am always in the favour of certifications. The reason for this is that  certifications give one a confidence, a trust that he/she has done somethign good, some thing which really does prove that he/she is serious enough to be current with the ever changing technology. I don’t think that we should take the certification as a way to show that we are more superior than those who don’t have it or don’t like it. All have  different opinions about things and at some point or the other, all are correct. I take certifications for my own satisfaction and that’s the main reason, I don’t post any logos or mention which certifications I hold. 

11g is the most latest offering from the Oracle corp for its flagship product, database.  As the version 11g is around from some time now, the certification track of it also is out. At the moment, the Oracle Certified Associate(OCA) track of the fresh OCP is out. The next level, OCP of 11g is yet to be out. But the exam for the already certified professionals , for example, 10g is already out with the exam code, 11g New Features for DBAs(1z0-050) is already out. This post is basically is a collection of the references that I did use when I was preparing for it. I found the exam quite exhaustive so I guess, if this post can help someone , he/she atleast won’t be feeling the same exhaustiveness.

The exam contents are mentioned here For the starting of the preparation, there is a must requirement for the material. The best material is from Oracle University only as OU offers official course for the topic. But , some may not be able to avail the course due to various constraints. I must mention that its not a must for the already certified people to attend a course for the exam as the Hands-on-Course requirement(HOC) is only for the fresh candidates. In case, you are not able to attend the course from OU, still the exam preparation can be done from these following books, 

http://www.amazon.ca/OCP-Oracle-Database-11g-Administrators/dp/0071496823″> OCP-11g New Features, Sam Alapati

http://www.amazon.ca/Expert-Oracle-Database-11g-Administration/dp/143021015X”>Expert Oracle Administration 11g, Sam Alapati

These two books cover almost all the topics which are both for the exam and for the actual working environments. Combining this with the official docs from oracle at http://tahiti.oracle.com wil be enough to cover the topics of the exam.

The exam is focussed essentially about the new features which are offered in 11g. Surely enough, if you are well verse with the 10g , you will find some link between the 11g features with them. Though, this is not true for all the new features , for example, Real Application Testing but having a good knowledge about 10g will surely help. 

For the practical demos, I used, Tim Hall’s articles and Oracle by Example series very heavily. Here is the link for both, 

http://www.oracle-base.com/articles/11g/Articles11g.php#ocp

http://www.oracle.com/technology/obe/11gr1_db/index.htm

I would really suggest to use Tim’s articles as using them will give you an immediate idea about how things look in action.  I won’t say that the same is not true for the OBE series, but it is not solely mentioned for the exam, so you may find some things in the articles which you won’t need atleast while just starting. But combining both, will be a good mix to start with the practical hands-on. 

In addition to the above mentioned sources, Arup Nanda’s , Top Features of 11g  series is also a must read for those who are looking for a quick know-how about the features. I used it very heavily for my preparation as the language used is very simple and Arup’s style to present the topic in the form of an actual business problem makes it easier to understand and also with that note, its easy to remember the topic as well. The series is also having good demos of all the mentioned features which again is a big help when you yourself don’t know how to make a demo/presentation. 

For some topics, I had to look around for that “little extra” as I was not very clear how to go for them. So in that process, I used various links. Here are those links which I used. In case , you also will get struck at the same point, I hope these links will help you.

Partioning in 11g

http://www.orafaq.com/node/1912

http://www.rittmanmead.com/2008/09/13/investigating-oracle-11g-interval-partitioning/

http://asanga-pradeep.blogspot.com/2008/08/11g-partitioning-enhancements.html

Automatic Memory Management in 11g

http://kevinclosson.wordpress.com/2007/08/23/oracle11g-automatic-memory-management-and-linux-hugepages-support/ 

http://blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/

So that’s all about the technical stuff I guess. Now, the last but certainly not the least part, find someone who can prepare it with you. I got lucky and had my friend Neeraj working with me for the same exam. It helped a lot to prepare as like a team as I like to discuss, share the stuff. When I discuss something, it sticks in my mind with all the essentials of it and also, if there are any doubts , they get cleared as well. So, besides the technical topics and their know-hows, try finding someone who is going to study for the same. I can gurantee that you will find the preparation much easier. 

So that’s all! Hope you get some help from this not-so-technical post for your exam preparation and clear with flying colors. Good luck!

, ,

6 Comments