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
adavey_at_competitrack.com
718-482-4200 x106
On 2/27/2003 3:19 PM, Nguyen, David M <david.m.nguyen_at_xo.com> 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: Paula_Stankus_at_doh.state.fl.us [mailto:Paula_Stankus_at_doh.state.fl.us]
>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:mln_at_miracleas.dk]
>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: 'ORACLE-L_at_fatcity.com'
>>
>> >
>>
>>
>>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.
>>
>>dwilliams_at_lifetouch.com
>>
>>-----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
>>
>>Paula_Stankus_at_doh.state.fl.us<mailto:Paula_Stankus_at_doh.state.fl.us
><mailto:Paula_Stankus_at_doh.state.fl.us>> 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:DWILLIAMS_at_LIFETOUCH.COM> ]
>>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.
>>dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
>>
>>
>>
>>-----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: mln_at_miracleas.dk
>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: ListGuru_at_fatcity.com (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: adavey_at_competitrack.com
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: ListGuru_at_fatcity.com (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).
Received on Thu Feb 27 2003 - 15:44:17 CST
