If you are taking the 9i certification, there are only 4 exams that you have to take. Unfortunately, unless you took at least one exam last year and got "grand-fathered", you will have to enroll at Oracle U. for one of the four courses covering the certification exams.
-- Alan Davey [EMAIL PROTECTED] 718-482-4200 x106 On 2/27/2003 3:19 PM, Nguyen, David M <[EMAIL PROTECTED]> wrote: >RE: Oracle Performance Tuning Exam > >There are totally five exams we have to pass to get certified, I'd >like to know which exam should I take first and what next in order?� >� >Thanks, >David >� >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Thursday, February 27, 2003 9:04 AM >To: Multiple recipients of list ORACLE-L >Subject: RE: Oracle Performance Tuning Exam >� >BTW, >That is why I didn't spend more than a few hours preparing for that >exam.� I already sensed that it would be a waste of time in the long-run.� >-----Original Message----- >From: Mogens N�rgaard [mailto:[EMAIL PROTECTED] >Sent: Wednesday, February 26, 2003 11:39 PM >To: Multiple recipients of list ORACLE-L >Subject: Re: Oracle Performance Tuning Exam >� >Good posting. Thank you. This week Morten Egan from Miracle A/S (who's >on this list as well, I think) is teaching the Tuning Class for Oracle >Denmark, and he's had a few comments as well about the materials. >Morten, would you care to comment (in your usually nice and easy >manner?) If was, after all, you who came with the "unlearn" quote >below. >Best regards, >Mogens >DENNIS WILLIAMS wrote: >>Mogens - I posted this note back in October. >> >>-----Original Message----- >> >>������> >>������ Sent: Saturday, October 05, 2002 4:08 PM >> >>������ To: '[EMAIL PROTECTED]' >> >>������> >>������ >> >>List >> >>I spent last week at an official Oracle Education Oracle9i Performance >>Tuning Class, and here is some of the non-technical stuff I learned. >> >>- Oracle is teaching the wait interface more and more. In fact, >they are >>updating the curriculum next month to emphasize the wait interface >even more >>(lucky me). >> >>- Just how the wait interface is emphasized may depend quite a bit >on the >>instructor, despite what the materials say. My observation is that >our >>opinions are based on what we have experienced and our interpretations >of >>those experiences. So we will probably still have some instructors >that will >>still feel that the wait interface is a passing fad and if you really >want >>to straighten out a database, you need to get in there and improve >the BHR >>(Buffer Hit Ratio). >> >>- My instructor was John Hibbard. He is excellent, and I would highly >>recommend him. He went well beyond the class materials to providing >papers >>he has researched and presented himself, as well as other sources, >including >>papers from Cary Milsap and Jonathan Gennick who participate on >this list. >>When you get through his class, you really feel you have been taken >to a >>whole new level of Oracle knowledge. He is also heavily involved >in >>selecting and preparing the official Oracle training materials for >the >>courses he teaches. Besides Performance Tuning, he teaches several >other >>Oracle classes. Most of the people in my class happened to be more >>experienced with Oracle, and John did a good job of answering advanced >>questions with some depth, but not leaving the newbies in the dust. >> >>- A funny observation on buffer hit ratio vs. wait interface. The >last day >>of class is an opportunity to take a really screwed-up database >and apply a >>little of what you have learned. The first scenario is titled "Buffer >>Cache". So you run the workload assignment and STATSPACK and look >at the BHR >>and say "wow, that is bad", increase the buffer pool, and rerun >the workload >>and STATSPACK. The BHR hasn't changed much, so the tendency is to >dumbly >>bump the buffer pool even more and go again. Then you look down >at the top 5 >>waits section just below on the first page of the STATSPACK report >and see >>that the big wait item is"Scattered Read". Then you go "dope slap" >and >>realize this schema is missing some critical indexes and table scanning >it's >>little heart out. I just found it ironic that some people have reported >that >>some of the Oracle instructors emphasize the BHR too much when the >first >>Workshop Scenario has a great example of why focusing on BHR can't >solve >>many problems. But again, we have experience vs. interpretation >of >>experience. A real died-in-the wool BHR fanatic would probably claim >that >>BHR had solved the problem because the first indication that something >was >>wrong was spotting the bad BHR, which led to other investigations. >> >> >> >>Dennis Williams >> >>DBA >> >>Lifetouch, Inc. >> >>[EMAIL PROTECTED] >> >>-----Original Message----- >>Sent: Tuesday, February 25, 2003 10:24 PM >>To: Multiple recipients of list ORACLE-L >> >> >>Yeah, if you've taken the performance exam, you must now unlearn >what you >>have learnt, to quote from Starwars. I've considered creating a >one- or >>two-day class that would put people into the right track of thinking >after >>having studied and passed that exam. The other exams are more or >less fine. >>The tuning one really - ahm - could be improved... >> >>Mogens >> >>[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED] ><mailto:[EMAIL PROTECTED]>>� wrote: >> >> >>Guys, >> >>I took this exam after 12 hours studying and missed 4 questions.� >I studied >>using the self-test software (few practice exams) some memorization >and the >>student guides from the oracle 8 tuning - read through once and >not every >>item (not 8i class) - where the heck was statspack in the examm, >btw?� I >>took it in 20 minutes.� Only the network one to go.� Can't wait >to get this >>done so can do the 9i upgrade exam - then wishing to concentrate >on >>certification relating to 9ias - is there such a beast? >> >>-----Original Message----- >><mailto:[EMAIL PROTECTED]> ] >>Sent: Tuesday, June 11, 2002 11:14 AM >>To: Multiple recipients of list ORACLE-L >> >> >>Arslan - I'm hoping you get some good replies since I plan to take >this exam >> >>next. >> >>I just took the B&R last week. The resource that helped me the most >is: >>Oracle8i Certified Professional DBA Practice Exams by Jason S. Couchman >>http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1 >><http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA >>1>� >>J&isbn=0072133414 (hopefully this link will work, it will be broken >into two >> >>lines which you must patch back together). >> >>Dennis Williams >>DBA, 20% OCP >>Lifetouch, Inc. >>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>� >> >> >> >>-----Original Message----- >>Sent: Tuesday, June 11, 2002 7:38 AM >>To: Multiple recipients of list ORACLE-L >> >> >>� I will enter my last exam at next week. >>� Could DBAs which have this exam� give� some advice. >>� >>� >> >� >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net> >-- >Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= >� INET: [EMAIL PROTECTED] >Fat City Network Services��� -- 858-538-5051 http://www.fatcity.com ><http://www.fatcity.com> >San Diego, California������� -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and >in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from).� You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
