OCP...HAVE A THE FINAL VERDICT ?
LETS HAVE THINGS STRAIGHT....
1)OCP IS A AN OBJECTIVE EXAM.......IF A PERSON EVEN WITHOUT EXP GETS THE OCP......IT IS IMPLIED THAT HE KNOWS MOST OF THE ORACLE FUNCTIONALITY THAT THE EXAMS INTENDS HIM TO KNOW.
YOU CANNOT BE OCP AND KNOW NOUGHT ABOUT ORACLE. THAT POSSIBILITY IS AS BLEAK AS EXPECTING TO FIND AN EMPTY HIVE WITH HONEY.
2 MANY PEOPLE HAVE TRIED TO UNDERMINE THE IMP OF OCP TO THAT OF EXP. THAT MAY BE TRUE IN SOME CASES .BUT PL CONSIDER THE OTHER CASE ....ALL AN "EXP" MUST HAVE DONE THROUGH HIS SO CALLED LONG "EXP" MUST BE BACK UPS, ASSIGN USERS AND RIGHTS,TUNE APPLICATIONS IF REQD.THESE MUST ALL BE THE SAME REPITITVE TASKS..ALTHOUGH HE CAN CLAIM A LOT THROUGH THIS "EXP"
ASK A ORACLE 7.3/8 ABOUT TRANSPORTABLE TS, NEWER FEATURES OF RMAN ......
TRUE DBA REQUIRES A LOT OF EXP......BUT EXP CAN ONLY BE GAINED BY WORKING.!!!
OCP DBA HAD CIRCUMVENTED MOST OF THE FUNCTIONALITY OF ORACLE .GIVEN A SITUATION WHERE AN EXP DBA AND OCP(NO EXP) ARE WORKING PAR LEVEL.THE OCP MAY MESS UP & LAG FOR FEW MONTHS...BUT HE'LL CATCH UP SOON...AND MORE THAN THAT MAY SUGGEST MODIFICATIONS TO PRESENT INFRASTR BASED ON NEWER FEATURES OF ORACLE.
3)SOME PEOPLE HAVE SUGGESTED ..SPEND TIME (YRS) AS PROGRAMMER/DEVELOPER THEN TRY FOR DBA EXP.
CAN THEY PL SITE WHY..?WHAT ASPECT OF PROGRAMMING IS DIRECTLY REQUIRED IN DBA.?
[Edited by varchar2 on 08-18-2001 at 04:42 PM]
Re: OCP...HAVE A THE FINAL VERDICT ?
Quote:
Originally posted by varchar2
LETS HAVE THINGS STRAIGHT....
3)SOME PEOPLE HAVE SUGGESTED ..SPEND TIME (YRS) AS PROGRAMMER/DEVELOPER THEN TRY FOR DBA EXP.
CAN THEY PL SITE WHY..?WHAT ASPECT OF PROGRAMMING IS DIRECTLY REQUIRED IN DBA.?
[Edited by varchar2 on 08-18-2001 at 04:42 PM]
I agree with you on (1) and (2). Now about (3):
Spend it but only if this is possible. If you are so eager to launch an Oracle career as a DBA, OK, go ahead. You wanna know what aspects of programming are directly required in a DBA's job: Tuning SQL statements, PL/SQL blocks, whole packages are good examples. If you spend some time tuning your DBs, you will find out (as I have) that you may tune very well all memory structures, I/Os, etc. but still applications are slow due to sloppy PL/SQL blocks. And here comes the good DBA: helping developers! It's harder to learn to make efficient applications that to create tablespaces, indexes or take backups with RMAN.
(I agree that the last statement of mine is questionable.)