RE: guidance

I took the 8i Performance exam a little while back and I think my book is by the same author as yours (Jason Couchman). I found that it gave a really good feel for the level of the exam. In fact, I did better on the actual exam than on the practice exams. As far as the many views/columns/parameters, the key is to figure out which ones are considered key by the test authors. There may be 100 views you could use, but can you identify the 3-4 key views to quickly performing performance tuning? The other key is the fact that the exam is taken from the Oracle Education class notes by Oracle Education instructors, so if you can get your hands on them, you're ahead of the game. Again, the class certainly won't cover 100 views/columns/parameters, but the notes will help you identify the ones that Oracle Education consider key. And it isn't like a college entrance examination where a failure will doom you to a career in the custodial industry. After 3 passing scores you are entitled to risk failure.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, September 25, 2003 3:05 PM To: Multiple recipients of list ORACLE-L

Give or take ??
Dennis I hope that one I can be on the examiner side of Oracle exams, but alas right now I am only the examinee.
Jokes aside, I have appeared for fundamentals 1, backup and recovery. This is my third foray into ocp exams. But performance tuning is really vast and scary. I find that most of the time I am going over the reference documentation trying to find out the names of views and what their different columns mean.
The problem is that give me a system and allow me to refer to the docs and I will be able to create a resource manager plan and implement it . But its difficult for me to remember where exactly the underscores appear in the parameter names of the dbms_resource_manager procedures. But basically performance tuning touches so many many new subjects that I am quite nervous about this exam.
What do you recommend ?
I am using the osborne book, and Oracle docs.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, September 25, 2003 02:44

> Give or take the exam? Makes a big difference ;-)
> Is this your first OCP module? If not, which other modules have you taken?
> What are you using as study materials?
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, September 24, 2003 4:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> List , I am planning to give my 9i performance tuning exam on the first .
> Any advice you all want to give me ? Pretty nervous about it. Sure would
> appreciate your guidance.
> ........
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

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