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
> >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
> 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=1G60ZMKA
> 1
>
><http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMK
> A
> >1>
> >J&isbn=0072133414 (hopefully this link will work, it will be broken
> into
> two
> >
> >lines which you must patch back together).
> >
> >Dennis Williams
>
=== message truncated ===
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
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).