RE: Oracle Performance Tuning Exam

[Johnson, Michael]

Don ... Why dont you tell everyone how you really feel !
Where have you been ?  ... besides busy like the rest of us.

Mike
-Original Message-
Sent: Tuesday, March 04, 2003 7:04 PM
To: Multiple recipients of list ORACLE-L


Sorry for the very late response, but I've seen a lot of similar postings
recently.  I've been lurking for some months now, when I have time for even
that, but I've never been accused of being under-opinionated, so...

In my opinion, the exam to take first is the Architecture & Administration
exam.  Anyone with any sort of significant Oracle DBA experience should be
able to pass it cold.  If it doesn't seem too easy or doesn't score well,
adjust the exam schedule and allocated study time accordingly.

I took the 8i Architecture/Administration exam and the 8i Backup & Recovery
exams on the same Tuesday at OracleWorld 2002 with zero preparation other
than experience.  I finished the first in under 20 minutes, the latter in
about 35.  Both seemed easy.  Of course, there were some "trick" questions,
some RMAN syntax trivia, and other OCP exam inanity.

Two days later, I took the SQL & PL/SQL exam.  I "crammed" on obscure syntax
and advanced stuff for about two hours in the IOUG bookstore in the exhibit
hall immediately prior.  It was unnecessary - no advanced stuff appeared on
the exam (Warning!  Your mileage may vary.).  It was easier than I thought
based on what I had heard about it.  It wasn't really difficult, but it was
a little tricky in places and a bit tedious in places.  All the other exams
were allowed 90 minutes, but this one was allowed 120 minutes.  I actually
took about 65 minutes (almost twice as long as any of the other five for 8i
+ 9i) due to checking over every answer twice and some of the "tricky"
questions thrice.

I think that the vast majority of experienced DBAs could easily pass these
with an 80%+ score with no formal preparation.  The only caveat is that one
needs to be conversant in RMAN - the basics at least.

The tuning exam was "a bit odd".  Knowing that it required the "party line"
answers, I spent about two hours reviewing the various ratio formulae and
memorizing other fairly useless trivia.  Some of the questions had no truly
correct answer - especially some that said something like "pick three..."
when there were definitely NOT three "correct" answers (and perhaps not even
two - or one).  This one might require some study by even the most
experienced DBAs.  Actually, the amount of "prep time" required might be
directly proportional to one's tuning expertise!  The fairly naive might
actually score better than actual experts given the same prep time!  There
were a number of questions that should have had a "none of the above - no
matter what the book says" choice - or perhaps an optional write-in answer
(e.g.  "I refuse to answer - even the question is utterly irrelevant and
misleading!").

I studied about 12 hours for the networking exam - primarily because I've
never used connection manager, Oracle Names, or OID in "real life" - and
have only rarely used some other stuff like MTS.  This exam was *much*
easier than I anticipated.  However, it did have a few "GUI trivia"
questions - stuff like knowing what menu something is on in netca, picking
among four very similar possible answers for the exact wording on some
boilerplate or menu, ad nauseum.  (Kind of missed the point of GUIs didn't
they?)

I took the 9i upgrade a week later, but studied for it most of the week (The
week of Thanksgiving - 4 evenings, one Saturday and a couple of hours per
day for the three days at work).  It could be considered the most difficult
since it covers only 9i new features - few of which one might have any "real
life" experience with.  It covered most topics at the conceptual level or a
very basic level, but there were a couple of extremely esoteric technical
questions that almost nobody would even attempt to answer in "real life"
without consulting a manual.

All these OCP exams were far easier than I ever thought they would be - even
after taking a few.  Most of the questions were of a conceptual or rather
basic nature.  All the exams had some serious flaws - questions that were
ambiguous, the wrong "correct" answers, obscure syntax trivia, GUI trivia,
too many questions about things that (almost) nobody ever uses (e.g. OEM's
Oracle Trace), etc.

A significant part of the game is in knowing how to take exams.  In this,
I've had a lot of experience - about 240 university semester hours and three
degrees.  If you don't see an obviously "correct" answer right away, weed
out the obviously "incorrect" answers.  Never leave a "multiple guess"
question unanswered if there is no penalty for missed guesses.  Et cetera...

After having gone from 0% OCP to 200% OCP (8i + 9i) in about three weeks in
November, perhaps now I can say "OCP doesn't mean squat - except to HR
checklists" - without appearing to be just another crusty old curmudgeon -
or jealous/nervous/worried/antiquate

Re: Oracle Performance Tuning Exam

[Don Granaman]

Sorry for the very late response, but I've seen a lot of similar postings
recently.  I've been lurking for some months now, when I have time for even
that, but I've never been accused of being under-opinionated, so...

In my opinion, the exam to take first is the Architecture & Administration
exam.  Anyone with any sort of significant Oracle DBA experience should be
able to pass it cold.  If it doesn't seem too easy or doesn't score well,
adjust the exam schedule and allocated study time accordingly.

I took the 8i Architecture/Administration exam and the 8i Backup & Recovery
exams on the same Tuesday at OracleWorld 2002 with zero preparation other
than experience.  I finished the first in under 20 minutes, the latter in
about 35.  Both seemed easy.  Of course, there were some "trick" questions,
some RMAN syntax trivia, and other OCP exam inanity.

Two days later, I took the SQL & PL/SQL exam.  I "crammed" on obscure syntax
and advanced stuff for about two hours in the IOUG bookstore in the exhibit
hall immediately prior.  It was unnecessary - no advanced stuff appeared on
the exam (Warning!  Your mileage may vary.).  It was easier than I thought
based on what I had heard about it.  It wasn't really difficult, but it was
a little tricky in places and a bit tedious in places.  All the other exams
were allowed 90 minutes, but this one was allowed 120 minutes.  I actually
took about 65 minutes (almost twice as long as any of the other five for 8i
+ 9i) due to checking over every answer twice and some of the "tricky"
questions thrice.

I think that the vast majority of experienced DBAs could easily pass these
with an 80%+ score with no formal preparation.  The only caveat is that one
needs to be conversant in RMAN - the basics at least.

The tuning exam was "a bit odd".  Knowing that it required the "party line"
answers, I spent about two hours reviewing the various ratio formulae and
memorizing other fairly useless trivia.  Some of the questions had no truly
correct answer - especially some that said something like "pick three..."
when there were definitely NOT three "correct" answers (and perhaps not even
two - or one).  This one might require some study by even the most
experienced DBAs.  Actually, the amount of "prep time" required might be
directly proportional to one's tuning expertise!  The fairly naive might
actually score better than actual experts given the same prep time!  There
were a number of questions that should have had a "none of the above - no
matter what the book says" choice - or perhaps an optional write-in answer
(e.g.  "I refuse to answer - even the question is utterly irrelevant and
misleading!").

I studied about 12 hours for the networking exam - primarily because I've
never used connection manager, Oracle Names, or OID in "real life" - and
have only rarely used some other stuff like MTS.  This exam was *much*
easier than I anticipated.  However, it did have a few "GUI trivia"
questions - stuff like knowing what menu something is on in netca, picking
among four very similar possible answers for the exact wording on some
boilerplate or menu, ad nauseum.  (Kind of missed the point of GUIs didn't
they?)

I took the 9i upgrade a week later, but studied for it most of the week (The
week of Thanksgiving - 4 evenings, one Saturday and a couple of hours per
day for the three days at work).  It could be considered the most difficult
since it covers only 9i new features - few of which one might have any "real
life" experience with.  It covered most topics at the conceptual level or a
very basic level, but there were a couple of extremely esoteric technical
questions that almost nobody would even attempt to answer in "real life"
without consulting a manual.

All these OCP exams were far easier than I ever thought they would be - even
after taking a few.  Most of the questions were of a conceptual or rather
basic nature.  All the exams had some serious flaws - questions that were
ambiguous, the wrong "correct" answers, obscure syntax trivia, GUI trivia,
too many questions about things that (almost) nobody ever uses (e.g. OEM's
Oracle Trace), etc.

A significant part of the game is in knowing how to take exams.  In this,
I've had a lot of experience - about 240 university semester hours and three
degrees.  If you don't see an obviously "correct" answer right away, weed
out the obviously "incorrect" answers.  Never leave a "multiple guess"
question unanswered if there is no penalty for missed guesses.  Et cetera...

After having gone from 0% OCP to 200% OCP (8i + 9i) in about three weeks in
November, perhaps now I can say "OCP doesn't mean squat - except to HR
checklists" - without appearing to be just another crusty old curmudgeon -
or jealous/nervous/worried/antiquated/whatever.  If one is really new to
this stuff, then perhaps snail-paced Oracle ILT, commercial practice exams,
exam prep books, and/or other expensive gadgetry can be justified
(rationalized?).  Otherwise, just go for it!

Don Gra

RE: Oracle Performance Tuning Exam

[Ed]

Wow, I'm actually sending two messages in quick succession...

The SQL test was extremely easy if you have any SQL experience in the
"real world".  I never understood why people said not to take it first,
it was by far the easiest test of the five.

There probably is no best test to take first.  It varies by person.

Best,

Ed


On Fri, 2003-02-28 at 10:45, DENNIS WILLIAMS wrote:
> David - I haven't taken all the exams yet, but the advice I heard was not to
> take the SQL exam first. On the surface it sounds easy, but it tends to be
> more of a SQL trivia test. For most of us practicing DBAs, I heard that the
> DBA exam tends to be the easiest, and is a good place to start and build
> your confidence. Naturally I didn't do it that way, but from what I have
> seen it is good advice. Depending on what you work with most, some exams may
> be easier for you than others. Perhaps some on the list who have taken all 5
> can provide you more opinions. 
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP, 100% DBA 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Thursday, February 27, 2003 2:20 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 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
> 
>  
> 

> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ed
  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).

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





I used to interview perspective Oracle DBA's for Oracle.  I was always unimpressed with the certificate.  However, once I heard that I might have to pay $1000 for another class just to take the 9i exam I took the 8i OCP DBA exams just so I could take the 9i upgrade - principal alone.  Experience should be key but unfortunately sometimes management only goes by things that are easily quantifiable not having the technical background to make any other judgement - not all management but unfortunately a few I have met.  As a pragmatist I am busily getting certified after holding out for 8 years feeling my experience was all that should matter.  In truth I feel that if we think of ourselves as true professionals than we accept certification as part of the job as so many other fields do.  Also, it didn't hurt my memory to go over a few things I had learned but forgotten along the way.  As for the certification exam itself (Performance and Tuning) being absolutely incorrect (and really not all of it just what was mainly emphasized) then the more experienced DBA's should write to Oracle University in protest and get them to redo the exam.  In otherwords, if more experienced technicians get certified my bet would be that the exams would become better and more appropo.  Also, I love the idea of exams in a lab - workshop.  So let's quit whining and turn this into something that really matters to our profession.  Then again, maybe I am just taking this whole Oracle DBA thing just a bit too seriously.  

Just my 2 cents


-Original Message-
From: Chip [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 27, 2003 11:24 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle Performance Tuning Exam



Depends on the path chosen to Oracle 9i DBA OCP:
1A) Pass the 5 Oracle 8i OCP DBA exams, then pass the Oracle 9i DBA OCP 
upgrade exam (total of 6 exams, but still does not need an Oracle 
Univeristy course)
Note: if Oracle retires the Oracle8i DBA exams like the Oracle 8 DBA 
exams, they would be available until May 2004 (5 months after Error 
Correction End Support).


2A) Pass 2 exams for Oracle 9i DBA OCA (Associate),
2B) Pass 2 more exams and attend an Oracle Univeristy course (unless an 
Oracle 9i DBA OCP exam was passed before Sep 1, 2002)


http://www.oracle.com/education/certification/index.html?certpaths.html
has the certification path information (Oracle has promised to publish 
changes 6 months before implementation)


The Oracle 9i DBA OCM (Master) requires Oracle 9i DBA OCP, 2 advanced 
DBA courses from Oracle Univeristy, and passing a 2 day hands-on exam 
(using Oracle on Red-Hat Linux).  While I agree with the continuing 
education requirement, I disagree that Oracle University is the ONLY 
place that offers high quality advanced DBA education.  I wish Oracle 
would count the Hotsos Symposium 2003 (and future Hotsos Symposiums as a 
meeting the Master education requirement).  In my meager experience of 
Oracle conferences, the Hotsos Symposium has been the best education value.


Since my employer won't pay for OCM (cutting training budget again), I 
would rather attend several conferences (and learn from many fine people 
on this list) than spend $ 4,000 to $ 7,000+ pursuing 9i DBA OCM.


Realistically, OCP DBA only validates that someone can read and 
memorize; I passed 3 of my 4 certifications without hands-on experience 
using that version of Oracle.  The exams validated I had spent some time 
learning the terminology of new features, but offer no indication that I 
know how to use them.  As more hairs turn gray (silver), I can 
appreciate why experience is needed and valued.  Also, certification 
does show an employer serious interest in becoming a DBA.


Have Fun :)
OCP DBA 7.3, 8, 8i, & 9i  (yea yea I got the paper and the plastic, but 
this list is far more educational and fun)


Alan Davey wrote:


>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.

>
>  
>




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chip
  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).

RE: Oracle Performance Tuning Exam

[Ramon E. Estevez]

I agree with Dennis, it depends on what you work with most.  I found the
DBA exam the easiest one, and the Backup the hardest one.

Luck

-Original Message-
WILLIAMS
Sent: Friday, February 28, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L


David - I haven't taken all the exams yet, but the advice I heard was
not to take the SQL exam first. On the surface it sounds easy, but it
tends to be more of a SQL trivia test. For most of us practicing DBAs, I
heard that the DBA exam tends to be the easiest, and is a good place to
start and build your confidence. Naturally I didn't do it that way, but
from what I have seen it is good advice. Depending on what you work with
most, some exams may be easier for you than others. Perhaps some on the
list who have taken all 5 can provide you more opinions. 



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, February 27, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L



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-
Sent: Thursday, February 27, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L

 

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- 
Sent: Wednesday, February 26, 2003 11:39 PM 
To: Multiple recipients of list ORACLE-L 

 

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 somethin

RE: Oracle Performance Tuning Exam

[DENNIS WILLIAMS]

David - I haven't taken all the exams yet, but the advice I heard was not to
take the SQL exam first. On the surface it sounds easy, but it tends to be
more of a SQL trivia test. For most of us practicing DBAs, I heard that the
DBA exam tends to be the easiest, and is a good place to start and build
your confidence. Naturally I didn't do it that way, but from what I have
seen it is good advice. Depending on what you work with most, some exams may
be easier for you than others. Perhaps some on the list who have taken all 5
can provide you more opinions. 



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, February 27, 2003 2:20 PM
To: Multiple recipients of list ORACLE-L



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-
Sent: Thursday, February 27, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L

 

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- 
Sent: Wednesday, February 26, 2003 11:39 PM 
To: Multiple recipients of list ORACLE-L 

 

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

Re: Oracle Performance Tuning Exam

[Chip]

Depends on the path chosen to Oracle 9i DBA OCP:
1A) Pass the 5 Oracle 8i OCP DBA exams, then pass the Oracle 9i DBA OCP 
upgrade exam (total of 6 exams, but still does not need an Oracle 
Univeristy course)
Note: if Oracle retires the Oracle8i DBA exams like the Oracle 8 DBA 
exams, they would be available until May 2004 (5 months after Error 
Correction End Support).

2A) Pass 2 exams for Oracle 9i DBA OCA (Associate),
2B) Pass 2 more exams and attend an Oracle Univeristy course (unless an 
Oracle 9i DBA OCP exam was passed before Sep 1, 2002)

http://www.oracle.com/education/certification/index.html?certpaths.html
has the certification path information (Oracle has promised to publish 
changes 6 months before implementation)

The Oracle 9i DBA OCM (Master) requires Oracle 9i DBA OCP, 2 advanced 
DBA courses from Oracle Univeristy, and passing a 2 day hands-on exam 
(using Oracle on Red-Hat Linux).  While I agree with the continuing 
education requirement, I disagree that Oracle University is the ONLY 
place that offers high quality advanced DBA education.  I wish Oracle 
would count the Hotsos Symposium 2003 (and future Hotsos Symposiums as a 
meeting the Master education requirement).  In my meager experience of 
Oracle conferences, the Hotsos Symposium has been the best education value.

Since my employer won't pay for OCM (cutting training budget again), I 
would rather attend several conferences (and learn from many fine people 
on this list) than spend $ 4,000 to $ 7,000+ pursuing 9i DBA OCM.

Realistically, OCP DBA only validates that someone can read and 
memorize; I passed 3 of my 4 certifications without hands-on experience 
using that version of Oracle.  The exams validated I had spent some time 
learning the terminology of new features, but offer no indication that I 
know how to use them.  As more hairs turn gray (silver), I can 
appreciate why experience is needed and valued.  Also, certification 
does show an employer serious interest in becoming a DBA.

Have Fun :)
OCP DBA 7.3, 8, 8i, & 9i  (yea yea I got the paper and the plastic, but 
this list is far more educational and fun)

Alan Davey wrote:

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.

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chip
 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).

Re: Oracle Performance Tuning Exam

[Alan Davey]

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 Scenari

RE: Oracle Performance Tuning Exam

[Nguyen, David M]

Title: 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- o

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





Okay,


We can plan our time so that one person goes to one and the other to the other - taping or taking copius notes and getting extra handouts then share.  

-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 27, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Performance Tuning Exam



Anything by Cary Millsap, Tim Gorman, Jonathan Lewis, Anjo Kolk


there are others but I plan on being at any session I can that the
above give... which should be interesting as they have Anjo and
Jonathan presenting in the same time slot.


Hm, where are the Raelians when I need them? 



--- [EMAIL PROTECTED] wrote:
> I am going to the IOUG - do you recommend any seminars or
> presentations on
> performance that will be presented there?
> 
> Thanks,
> Paula
> 
> -Original Message-
> Sent: Wednesday, February 26, 2003 11:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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-
> >
> > From: DENNIS WILLIAMS 
> >
> > Sent: Saturday, October 05, 2002 4:08 PM
> >
> > To: '[EMAIL PROTECTED]'
> >
> > Subject: Oracle Performance Tuning Class - update
> >
> > 
> >
> >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
> >Wor

RE: Oracle Performance Tuning Exam

[Rachel Carmichael]

Anything by Cary Millsap, Tim Gorman, Jonathan Lewis, Anjo Kolk

there are others but I plan on being at any session I can that the
above give... which should be interesting as they have Anjo and
Jonathan presenting in the same time slot.

Hm, where are the Raelians when I need them? 


--- [EMAIL PROTECTED] wrote:
> I am going to the IOUG - do you recommend any seminars or
> presentations on
> performance that will be presented there?
> 
> Thanks,
> Paula
> 
> -Original Message-
> Sent: Wednesday, February 26, 2003 11:39 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 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-
> >
> > From: DENNIS WILLIAMS 
> >
> > Sent: Saturday, October 05, 2002 4:08 PM
> >
> > To: '[EMAIL PROTECTED]'
> >
> > Subject: Oracle Performance Tuning Class - update
> >
> > 
> >
> >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] 
>

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: 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-
>
>   From: DENNIS WILLIAMS 
>
>   Sent: Saturday, October 05, 2002 4:08 PM
>
>   To: '[EMAIL PROTECTED]'
>
>   Subject: Oracle Performance Tuning Class - update
>
>   
>
>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]>  wrote:
>
>
>Guys, 
>
>I took this exam after 12 hours studying and 

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





I am going to the IOUG - do you recommend any seminars or presentations on performance that will be presented there?


Thanks,
Paula


-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-
>
>   From: DENNIS WILLIAMS 
>
>   Sent: Saturday, October 05, 2002 4:08 PM
>
>   To: '[EMAIL PROTECTED]'
>
>   Subject: Oracle Performance Tuning Class - update
>
>   
>
>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]>  wrote:
>
>
>Guys, 
>
>I took this exam after 12 hours studying and missed 4 questions.  I studi

Re: Oracle Performance Tuning Exam

[Mogens Nørgaard]

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-

	From: DENNIS WILLIAMS 

	Sent: Saturday, October 05, 2002 4:08 PM

	To: '[EMAIL PROTECTED]'

	Subject: Oracle Performance Tuning Class - update

	

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]   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- 
 ] 
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

RE: Oracle Performance Tuning Exam

[DENNIS WILLIAMS]

Mogens - I posted this note back in October.

-Original Message-

From: DENNIS WILLIAMS 

Sent: Saturday, October 05, 2002 4:08 PM

To: '[EMAIL PROTECTED]'

Subject: Oracle Performance Tuning Class - update



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]   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- 
 ] 
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
  
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]   



-Original Message- 
Sent: Tuesday, June 11, 2002 7:38 AM 
To: Mu

Re: Oracle Performance Tuning Exam

[Mogens Nørgaard]

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] wrote:
   
  
 
  
  RE: Oracle Performance Tuning Exam

  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- 
  From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
  
  Sent: Tuesday, June 11, 2002 11:14 AM 
  To: Multiple recipients of list ORACLE-L 
  Subject: RE: Oracle Performance Tuning Exam 
 
  
  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 
  
  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] 
 
 
  
  -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.com 
  
  --  
  Author: Arslan Bahar 
    INET: [EMAIL PROTECTED] 
  
  Fat City Network Services    -- (858) 538-5051  FAX:
(858) 538-5051 
  San Diego, California    -- Public Internet access /
Mailing Lists 
   
  
  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.com 
  
  --  
  Author: DENNIS WILLIAMS 
    INET: [EMAIL PROTECTED] 
  
  Fat City Network Services    -- (858) 538-5051  FAX:
(858) 538-5051 
  San Diego, California    -- Public Internet access /
Mailing Lists 
   
  
  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). 
  
  

RE: Oracle Performance Tuning Exam

[Paula_Stankus]

Title: RE: Oracle  Performance Tuning  Exam





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-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Performance Tuning Exam



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
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]




-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.com
-- 
Author: Arslan Bahar
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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).

Re: Oracle Performance Tuning Exam

[Alexandre Gorbatchev]

Hi,
What you need for the exam is solid understanding of Oracle architecture.
Most of answers are on the surface, so when you think too deeply - double
check that it's not really simple :)
In particular make sure you know the general methodologies of tuning (from
oracle perspective, to be precise). That's 30% of success.
Couchman is very good for exam preparation. At least it was the
only one I used.

Good luck! 8-)
--
Alexandre

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 5:13 PM


> 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
> 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]
>
>
>
> -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.com
> --
> Author: Arslan Bahar
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Alexandre Gorbatchev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Oracle Performance Tuning Exam

[Mohammad Rafiq]

Besides any good OCP book ,STS practice tests questions (full version cost 
$99) really help a lot for practice and real OCP exam...and almost cover 
more than 50% of exam questions...

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 11 Jun 2002 07:13:37 -0800

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
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]



-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.com
--
Author: Arslan Bahar
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).




_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

RE: Oracle Performance Tuning Exam

[DENNIS WILLIAMS]

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
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]



-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.com
-- 
Author: Arslan Bahar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle Performance Tuning Exam

[Arslan Bahar]

  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.com
-- 
Author: Arslan Bahar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).