Re: ** OCP for 9i requirements -- Instructor Led Class is a
Sure. Read Important Program Announcement: Oracle University Hands-On Course Requirement Oracle customers and business partners are demanding hands-on experience - with all aspects of Oracle's database - from their Oracle Certified Professionals. In order to meet our commitment to our customers and constituents, Oracle University has recently made a significant investment in its Certification Program. Three distinct changes are being rolled out with the goal of increasing the level of quality of our certification skill and ability benchmarks: ·Scenario-based testing in all Oracle9i DBA Certified Professional exams . ·Instructor-led class requirement for candidates starting on the Oracle9i DBA Certified Professional credential exam path. ·A new hands-on Masters Practicum Exam for the Oracle9i Database Administrator Certified Master credential. at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html Instructure-led class is a requirement. You CAN take the Online Training to _prepare_ for the Exams. But you MUST attend at least one Instructor-led class to qualify for the certification. Hemant At 10:34 AM 13-01-04 -0800, you wrote: why dont you just read what is on the oracle website? www.oracle.com do a search for certification. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Subject: Re: ** OCP for 9i requirements Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought that the pre-requisite is at least one Instructor Led Training. Hemant At 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html Justin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: ** OCP for 9i requirements -- Instructor Led Class is a
If you go to the Update 9i exam listing - there are no course requirements. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hemant K ChitaleSent: Wednesday, January 14, 2004 9:09 AMTo: Multiple recipients of list ORACLE-LSubject: Re: ** OCP for 9i requirements -- Instructor Led Class is aSure.Read "Important Program Announcement: Oracle University Hands-On Course RequirementOracle customers and business partners are demanding hands-on experience - with all aspects of Oracle's database - from their Oracle Certified Professionals. In order to meet our commitment to our customers and constituents, Oracle University has recently made a significant investment in its Certification Program. Three distinct changes are being rolled out with the goal of increasing the level of quality of our certification skill and ability benchmarks: ·Scenario-based testing in all Oracle9i DBA Certified Professional exams . ·Instructor-led class requirement for candidates starting on the Oracle9i DBA Certified Professional credential exam path. ·A new hands-on Masters Practicum Exam for the Oracle9i Database Administrator Certified Master credential. "at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html"Instructure-led class" is a requirement.You CAN take the Online Training to _prepare_ for the Exams. But you MUST attend at least one Instructor-led classto qualify for the certification.HemantAt 10:34 AM 13-01-04 -0800, you wrote: why dont you just read what is on the oracle website?www.oracle.comdo a search for certification. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Subject: Re: ** OCP for 9i requirements Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought that the pre-requisite is "at least one Instructor Led Training". Hemant At 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html Justin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes Hemant K ChitaleOracle 9i Database Administrator Certified Professionalhttp://hkchital.tripod.com {last updated 05-Jan-04}-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). Hemant K ChitaleOracle 9i Database Administrator Certified Professionalhttp://hkchital.tripod.com {last updated 05-Jan-04}-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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
RE: ** OCP for 9i requirements -- Instructor Led Class is a
I heard from an Oracle instructor that some idiots were bragging about how they passed the OCP without logging in once. This distressed some important people, so this requirement was added. I asked if this meant each instructor was tasked with ensuring each student logged in, and he just smiled. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 8:09 AM To: Multiple recipients of list ORACLE-L Sure. Read Important Program Announcement: Oracle University Hands-On Course Requirement Oracle customers and business partners are demanding hands-on experience - with all aspects of Oracle's database - from their Oracle Certified Professionals. In order to meet our commitment to our customers and constituents, Oracle University has recently made a significant investment in its Certification Program. Three distinct changes are being rolled out with the goal of increasing the level of quality of our certification skill and ability benchmarks: Scenario-based testing in all Oracle9i DBA Certified Professional exams . Instructor-led class requirement for candidates starting on the Oracle9i DBA Certified Professional credential exam path. A new hands-on Masters Practicum Exam for the Oracle9i Database Administrator Certified Master credential. at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html http://www.oracle.com/education/certification/index.html?dba9i_ocp.html Instructure-led class is a requirement. You CAN take the Online Training to _prepare_ for the Exams. But you MUST attend at least one Instructor-led class to qualify for the certification. Hemant At 10:34 AM 13-01-04 -0800, you wrote: why dont you just read what is on the oracle website? www.oracle.com http://www.oracle.com do a search for certification. - Original Message - To: Multiple recipients of mailto:[EMAIL PROTECTED] list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought that the pre-requisite is at least one Instructor Led Training. Hemant At 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com http://www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq. html http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq .html Justin Cave - Original Message - To: Multiple recipients of mailto:[EMAIL PROTECTED] list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/mail_footer_email/evt=2 1482/*http://hotjobs.sweepstakes.yahoo.com/signingbonus the Signing Bonus Sweepstakes Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com http://hkchital.tripod.com / {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net/ -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com http://www.fatcity.com/ San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com http://hkchital.tripod.com/ {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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
Re: ** OCP for 9i requirements
At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html Justin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
Re: ** OCP for 9i requirements
Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought that the pre-requisite is at least one Instructor Led Training. Hemant At 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount). http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html Justin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: ** OCP for 9i requirements
why dont you just read what is on the oracle website? www.oracle.com do a search for certification. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 13, 2004 9:34 AM Subject: Re: ** OCP for 9i requirements Are you sure that the on-line version qualifies as fulfilling the pre-requisite ? I thought thatthe pre-requisite is "at least one Instructor Led Training".HemantAt 12:04 AM 13-01-04 -0800, you wrote: At 06:14 PM 1/12/2004, Ryan wrote: www.oracle.comdo a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. My understanding is that you need to take a class that corresponds to one of the four OCP exams, which are all 5-day classes. The in-classroom versions run $2500 and the on-line versions run $1250. Oracle partners get a 35% discount (advantage and certified advantage partners may get a larger discount).http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.htmlJustin Cave - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University. What is the minimum? Is any small course good enough? Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes Hemant K ChitaleOracle 9i Database Administrator Certified Professionalhttp://hkchital.tripod.com {last updated 05-Jan-04}-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: ** OCP for 9i requirements
www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University.What is the minimum? Is any small course good enough?Can someone who has gone through this provide details? Thank you Do you Yahoo!?Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: OCP question from Boson practice tests
Hi, This is from a metalink note 1039341.6. It is about 'DEFAULT STORAGE'. I do not know if the OCP question was regarding that. *** Use the following guidelines to specify DEFAULT STORAGE: Set INITIAL=NEXT.Since a process always writes data equal to SORT_AREA_SIZE to a temporary segment, a good value for the extentsize is (n*s + b) where: n is a positive integer s is the value of SORT_AREA_SIZE initialization parameter b is the value of DB_BLOCK_SIZE initialization parameter Using this value optimizes temporary segment usage by allowingsufficient space for a header block and multiple sort run data to bestored in each extent. Is this not correct? Forget OCP. I was just want clarify this issue. Good luck for the exams Prem. Further to that if I give my sort area size as a very odd number which is not a multiple of OS block size then what happens. Thank You[EMAIL PROTECTED] wrote: Prem ,OCP has nothing to do with knowledge and nothing to do with the real world.So if you want to give OCP, forget what you know and humbly, play by itsrules.Right now if your are serious about giving OCP exams then pleaseenable "suspension of disbelief" , don't ask why and just mug up thefollowing 3 (any one of them may come up in the ocp exam , though nottogether) :1.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of the parameter sort_area_size2.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of sort_area_size * db_block_size3.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be n * sort_area_size + db_block_size.OCP has nothing to do with knowledge and nothing to do with the real world.So if you want to give OCP, forget what you know and play by its rules.Best of luck . Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: OCP Question (Perf Tuning)
We'll thats exactly what I'm doing right now, studying Oracle University instructor guides to temporarily start thinking like OU myself again - I'll be instructing an OCP Review course next week, meant for people who want to pass OCP. And in order to not distract the students, I won't even mention the real life situation too much, except in really misleading cases... Hi Tanel I have a Dr. friend of mine who teaches heart surgeons how to pass their medical exams. Basically he simply teaches them to rip out the offending organ (generally found towards the left hand side of the upper chest), give it a bit of a squeeze, shake out any crap that might be inside, measure the Beats outside Chest Heart Ratio (BCHR), stick it back in, hope it's done some good and that the patient at least survives until they're 10 miles from the hospital. He tells the students that it's important to do the above steps in the correct order as it's in the medical exam. After the students have scribbled everything down, he then leans forward and quietly whispers to them that in the real world, heart surgeons actual first check whether or not it's actually necessary to cut out the heart *beforehand*. He then gives them a little wink and a nod, the students usually reply with an hh and the class moves on to discuss how to remove blood stains from their white surgical outfits. IMHO it's all a little scary and a touch surreal and yet it all sounds strangely familiar ... Cheers ;) Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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: OCP Question (Perf Tuning)
After the students have scribbled everything down, he then leans forward and quietly whispers to them that in the real world, heart surgeons actual first check whether or not it's actually necessary to cut out the heart *beforehand*. He then gives them a little wink and a nod, the students usually reply with an hh and the class moves on to discuss how to remove blood stains from their white surgical outfits. IMHO it's all a little scary and a touch surreal and yet it all sounds strangely familiar ... And they don't have too many backups either :( Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: OCP question from Boson practice tests
Hi again Prem, OK, I've changed my opinion of dear Boson. At first I simply thought they had no idea, now I suspect it's all a big joke designed to make DBAs have a bit of a giggle on warm summer nights ... Sizing the temp tablespace by the formula you've given is really quite witty. Perhaps a little on the silly side but I love Monty Python so I liked it. The correct answer is actually none of the four listed (so I'm really struggling to find two of the buggers). A. Users: Not really. I could show you a DW database with only a handful of users that requires a much larger temp tablespace than an OLTP database with 1000s of users. It not the number of users but what the users *do* that's important. B. Sort Area Size. Not really. Although it can influence whether a sort is performed on temp or not, it's the size of the *sort*, not the size of the S_A_S that's important. And not just the size of one sort, but the size of the *max concurrent* sort activity. I guess a badly set S_A_S could result in needing a larger temp tablespace but I doubt that's the point of the question. And then there's hash joins, etc, ooops, the question has kinda forgotten about non sort activity in temp C. tablespace management. Not really although I guess those bitmaps do take up some space ... D. db_block_size. What the #@* ??. Thinking about all this a bit more, if Boson's practice questions puts people off doing OCPs, it might not be such a bad thing after all ... Cheers ;) Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 8:44 PM Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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: OCP question from Boson practice tests
Well, you've certainly gotten a few decent replies. I've never used Boson so I can't comment on their exams, I prefer going to Oracle Press. Anyway, sizing temp is a combination of things many of which are black magic at best. Number of users is an interesting variable to add, but not of an extreme value since it's actually the number of CONNECTED users that will really affect the value arrived at. Sort_Area_size, Maybe. If it's large enough it may well negate the need for temp in a number of cases, but don't bet on it. Type of Tablespace management? OK, who's smoking what. That's a giveaway toss out. DB_Block_Size, again a giveaway, it has no real bearing since the temp tablespace will have the same size, unless you use 9i features, but even then a MB is a MB. The real answer is know what your database is suppose to be doing. If your setting up an OLTP database you may well get away with a very small temp space. On the other hand a data warehouse or decision support system is, by design, going to consume mountains of temp. Also do not forget things like index rebuilds that you will need to do, they do sorts and consequently consume temp in the process. Then there's always that wild user who lets loose the Cartesian product from haties that will blow all of your calculations off the map. Therefore the answer in this case is E: None of the above. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 5:44 AM To: Multiple recipients of list ORACLE-L Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: OCP Question (Perf Tuning)
What I have heard is that all the OCP questions are taken from the Oracle University Student Guide. After all, you wouldn't you expect the class to prepare you? Someone suggested that you think like a computer. Well, for the philosophy behind the exam, think like an organization, namely Oracle University. We'll thats exactly what I'm doing right now, studying Oracle University instructor guides to temporarily start thinking like OU myself again - I'll be instructing an OCP Review course next week, meant for people who want to pass OCP. And in order to not distract the students, I won't even mention the real life situation too much, except in really misleading cases... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: OCP question from Boson practice tests
Prem , OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and humbly, play by its rules. Right now if your are serious about giving OCP exams then please enable suspension of disbelief , don't ask why and just mug up the following 3 (any one of them may come up in the ocp exam , though not together) : 1. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of the parameter sort_area_size 2. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to be a multiple of sort_area_size * db_block_size 3. To optimize the performance of a sort in a temprary tablespace , set the UNIFORM SIZE to ben * sort_area_size + db_block_size. OCP has nothing to do with knowledge and nothing to do with the real world. So if you want to give OCP, forget what you know and play by its rules. Best of luck . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 16:14 Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: OCP Question (Perf Tuning)
D is probably the answer, but most of the time oracle will choose nested loop. Beware the OCP tuning test. It is completely and totally inaccurate. I emailed the author of the Sybex tuning book and he agreed with me. He said he wrote the book to the test and knows its garbage. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:44 PM Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: OCP Question (Perf Tuning)
Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: OCP Question (Perf Tuning)
thought so, I'm not 100% certain the OCP will say that though. alot of inaccuracies in that test. btw, Ive been playing with first_rows lately. I've noticed that it has a preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in some test cases where you have two tables approximately 3m and 1.5m rows in size, that INDEX RANGE SCAN actually returns the first 25 or so records faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior. Surprised me. I've read some docs on this and I think that a range scan is always preferably when you only want a few rows? What am I missing? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:59 PM Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: OCP Question (Perf Tuning)
Think like a computer. Which execution plan will be the result? result of what? an insert statement? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: OCP Question (Perf Tuning)
Note in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 6:59 PM Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. Unless the alternative is a full tablescan on the inner table - in which case merge or hash joins can be considered. The question itself is non-trivial, as the cost of a nested loop is: Cost of outer acquisition + Cost of inner access * cardinality of outer acquisition. But the cost of a merge join is: Cost of first acquisition + cost of first sort + Cost of second acquisition + cost of second sort + Cost of merge It seems likely that if the first table returned 1 or 2 rows, then a nested loop with FTS could be cheaper than a sort merge, but if the outer table returned 3 Oracle would switch to a sort merge. (Assuming equijoin). On the other hand, if the second table required a very large sort, I'm sure you could engineer a sort_area_size that would make the sort cost more than three times the cost of a simple tablescan - which means you could change the access path by changing the sort_area_size. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: OCP Question (Perf Tuning)
FIRST_ROWS would alter the behavior regardless of the number of rows. -Original Message- Jay Wade Sent: Tuesday, January 06, 2004 1:44 PM To: Multiple recipients of list ORACLE-L Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: OCP Question (Perf Tuning)
What I have heard is that all the OCP questions are taken from the Oracle University Student Guide. After all, you wouldn't you expect the class to prepare you? Someone suggested that you think like a computer. Well, for the philosophy behind the exam, think like an organization, namely Oracle University. I can't find anything nearly this detailed in the Student Guide, therefore I conclude that this question will not appear on the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 06, 2004 1:34 PM To: Multiple recipients of list ORACLE-L thought so, I'm not 100% certain the OCP will say that though. alot of inaccuracies in that test. btw, Ive been playing with first_rows lately. I've noticed that it has a preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in some test cases where you have two tables approximately 3m and 1.5m rows in size, that INDEX RANGE SCAN actually returns the first 25 or so records faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior. Surprised me. I've read some docs on this and I think that a range scan is always preferably when you only want a few rows? What am I missing? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:59 PM Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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
Re: OCP Question (Perf Tuning)
Jonathan, you're right. Interesting thing is that bitmap indexes, which were made for DW processing and not for OLTP will also be considered for NL context in First_Rows mode. Here is the proof, which also proves that I'm a lousy typist: SQL set autorace on explain SP2-0158: unknown SET option autorace SQL set autotrace on explain SQL select /*+ first_rows ordered */ ename,dname,loc from emp e,dept d 2 where e.deptno=d.deptno 3 / ENAME DNAME LOC -- -- - ALLEN SALES CHICAGO WARD SALES CHICAGO JAMES SALES CHICAGO FORD RESEARCH DALLAS MILLER ACCOUNTING NEW YORK SMITH RESEARCH DALLAS JONES RESEARCH DALLAS MARTIN SALES CHICAGO BLAKE SALES CHICAGO CLARK ACCOUNTING NEW YORK SCOTT RESEARCH DALLAS ENAME DNAME LOC -- -- - KING ACCOUNTING NEW YORK TURNER SALES CHICAGO ADAMS RESEARCH DALLAS 14 rows selected. Execution Plan -- 0 SELECT STATEMENT Optimizer=HINT: FIRST_ROWS (Cost=135 Card=8 2 Bytes=4100) 10 TABLE ACCESS (BY INDEX ROWID) OF 'DEPT' (Cost=135 Card=1 B ytes=30) 21 NESTED LOOPS (Cost=135 Card=82 Bytes=4100) 32 TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=82 Bytes=164 0) 42 BITMAP CONVERSION (TO ROWIDS) 54 BITMAP INDEX (SINGLE VALUE) OF 'DEPT_DEPTNO' On 2004.01.06 14:49, Jonathan Lewis wrote: Note in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 6:59 PM Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. Unless the alternative is a full tablescan on the inner table - in which case merge or hash joins can be considered. The question itself is non-trivial, as the cost of a nested loop is: Cost of outer acquisition + Cost of inner access * cardinality of outer acquisition. But the cost of a merge join is: Cost of first acquisition + cost of first sort + Cost of second acquisition + cost of second sort + Cost of merge It seems likely that if the first table returned 1 or 2 rows, then a nested loop with FTS could be cheaper than a sort merge, but if the outer table returned 3 Oracle would switch to a sort merge. (Assuming equijoin). On the other hand, if the second table required a very large sort, I'm sure you could engineer a sort_area_size that would make the sort cost more than three times the cost of a simple tablescan - which means you could change the access path by changing the sort_area_size. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: OCP Question (Perf Tuning)
What I meant is that the question cannot be answered without making human assumptions about the question itself. It is a little difficult (Note little not lot) to believe that such a poorly written question would appear on a test that costs money to take. -Original Message- Someone suggested that you think like a computer. Well, for the philosophy behind the exam, think like an organization, namely Oracle University. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: OCP Question (Perf Tuning)
Thanks for the help. Do you have any ideas to the FIRST_ROWS behavior in regards to NL? I've been looking and found http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#39473 it goes into detail about using hints for joins but now how the FIRST_ROWS forces a join selection on anything other then sample size. I'm interested to know more about the behavior and the links that I am finding don't seem to offer the depth I thought they would. Or maybe they do and I'm missing the boat From: Ryan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Question (Perf Tuning) Date: Tue, 06 Jan 2004 11:34:26 -0800 thought so, I'm not 100% certain the OCP will say that though. alot of inaccuracies in that test. btw, Ive been playing with first_rows lately. I've noticed that it has a preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in some test cases where you have two tables approximately 3m and 1.5m rows in size, that INDEX RANGE SCAN actually returns the first 25 or so records faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior. Surprised me. I've read some docs on this and I think that a range scan is always preferably when you only want a few rows? What am I missing? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:59 PM Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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). _ Working moms: Find helpful tips here on managing kids, home, work and yourself. http://special.msn.com/msnbc/workingmom.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: OCP Question (Perf Tuning)
Jonathan noted that Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. Unless the alternative is a full tablescan on the inner table - in which case merge or hash joins can be considered. For some reason hash joins were excluded from the question. I can't speculate as to what, other than oversight or limiting the answers to 4, the reason for this might be. I suspect the answer *wanted* is b) the focus being that FIRST_ROWS favours index scans and NL joins. ISTM that d) ought to be ruled out as it refers to rows not blocks but as usual I am probably wrong. Niall OCP DBA (the last time you'll see that sig for a while). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: OCP Question (Perf Tuning)
I see you're running on Oracle 9 there, and that can make a big difference. After posting my hypothesis, I created a test case, which behaved as I had predicted - but the behaviour changed in Oracle 9, and I had to do some tweaking. Turns out my test case highlighted what looks like a but in the SORT costing in Oracle 8 for a sort/merge join. The Oracle 9 costing is better, so Oracle 9 didn't switch to an NL when Oracle 8 did. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:14 PM Jonathan, you're right. Interesting thing is that bitmap indexes, which were made for DW processing and not for OLTP will also be considered for NL context in First_Rows mode. Here is the proof, which also proves that I'm a lousy typist: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: OCP Question (Perf Tuning)
A bigger error in option (d) is that it leaves open the ambiguity of whether the rows should, or should not, be part of the answer to the join. Oracle's choice of join could be affected by adding 100 rows to the table that should be included in the join, but remain unchanged if you add 100 rows that should not be included in the join. Frankly it's an appallingly bad question, and I think your assumption about the wrong answer you are required to give is correct. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 9:54 PM Jonathan noted that Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. Unless the alternative is a full tablescan on the inner table - in which case merge or hash joins can be considered. For some reason hash joins were excluded from the question. I can't speculate as to what, other than oversight or limiting the answers to 4, the reason for this might be. I suspect the answer *wanted* is b) the focus being that FIRST_ROWS favours index scans and NL joins. ISTM that d) ought to be ruled out as it refers to rows not blocks but as usual I am probably wrong. Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: OCP 8i
Hm... try this link: http://www.oracle.com/education/certification/faq/index.html?faq5.html HTH JL --- Nelson, Allan [EMAIL PROTECTED] wrote: Hi Listers, Does anyone know how long the 8i OCP tests will be offered. I can't seem to find it on the Oracle Education Web site. Thanks Allan L. Nelson Oracle DBA M-I L.L.C. (832) 295-2238 office (832) 351-4180 fax [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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: OCP 8i
Oh, thanks -Original Message- Jose Luis Delgado Sent: Wednesday, December 17, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hm... try this link: http://www.oracle.com/education/certification/faq/index.html?faq5.html HTH JL --- Nelson, Allan [EMAIL PROTECTED] wrote: Hi Listers, Does anyone know how long the 8i OCP tests will be offered. I can't seem to find it on the Oracle Education Web site. Thanks Allan L. Nelson Oracle DBA M-I L.L.C. (832) 295-2238 office (832) 351-4180 fax [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: RE: OCP 9i New Features for DBAs
Jared, I didn't make a detailed list but where I clearly noticed the inaccuracies was in the sample exam questions at the back of the book e.g. In which version of Oracle was hash partitioning introduced? A) 7 B) 8 C) 8i D) 9i Answer D. The real answer as we know is C. Which statement is true about the TIMESTAMP WITH TIME ZONE datatype? A) It represents absolute time. B) In addition to the date and time, you can store the time zone displacement (offset), which requires additional bytes of storage. C) In addition to the date and time, you can store the time zone displacement (offset), without consuming additional bytes of storage. D) You can use the NLS_TIMESTAMP_TZ_FORMAT initialisation parameter to specify the default timestamp format for retrieval. Answer C. The real answer is B. What this means is that you need to checkout the answers when marking yourself just to be on the safe side. I must point out that on a couple of occaisions the book was right when I initially thought it was wrong. Cheers, Chris -Original Message- Sent: 20 November 2003 18:35 To: Multiple recipients of list ORACLE-L Chris, Care to share details on the inaccuracies? Jared Dunscombe, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/20/2003 02:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: OCP 9i New Features for DBAs Ryan, I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle 9i Database: New Features for Administrators Exam Guide book. Even though there are a number of inaccuracies it was good preparation especially the sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all seemed to be 9.0. Hope all goes well when you take your exam. Cheers, Chris -Original Message- Sent: 12 November 2003 18:25 To: Multiple recipients of list ORACLE-L im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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
RE: RE: OCP 9i New Features for DBAs
Ryan, I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle 9i Database: New Features for Administrators Exam Guide book. Even though there are a number of inaccuracies it was good preparation especially the sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all seemed to be 9.0. Hope all goes well when you take your exam. Cheers, Chris -Original Message- Sent: 12 November 2003 18:25 To: Multiple recipients of list ORACLE-L im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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: RE: OCP 9i New Features for DBAs
Chris, Care to share details on the inaccuracies? Jared Dunscombe, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/20/2003 02:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: OCP 9i New Features for DBAs Ryan, I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle 9i Database: New Features for Administrators Exam Guide book. Even though there are a number of inaccuracies it was good preparation especially the sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all seemed to be 9.0. Hope all goes well when you take your exam. Cheers, Chris -Original Message- Sent: 12 November 2003 18:25 To: Multiple recipients of list ORACLE-L im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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: RE: OCP 9i New Features for DBAs
Yeah, tell me, too! I'm about to teach a 5-day course for passing OCP in January. Don't mind if I post completely inaccurate answers to this list at this time, I just have to change my way of thinking for then ;) Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, November 20, 2003 8:35 PM Subject: RE: RE: OCP 9i New Features for DBAs Chris, Care to share details on the inaccuracies? Jared "Dunscombe, Chris" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/20/2003 02:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: RE: OCP 9i New Features for DBAsRyan,I took my exam yesterday and passed!! I used the Oracle Press - OCP Oracle9i Database: New Features for Administrators Exam Guide book. Even thoughthere are a number of inaccuracies it was good preparation especially thesample exams it provides. Regarding 9.2 vs 9.0 content in the exam it allseemed to be 9.0.Hope all goes well when you take your exam.Cheers,Chris -Original Message-Sent: 12 November 2003 18:25To: Multiple recipients of list ORACLE-Lim going to take it soon. I was going to just read howard rogers guide thenthe otn one. you think that is enough? I just want to pass it and get my piece of paper.I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would havefelt compelled to change the name of the test. However, I think it possiblethat any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whetherthe exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: [EMAIL PROTECTED]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Dunscombe, ChrisINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(o
RE: OCP 9i New Features for DBAs
Runs on 9.2 but there's nothing specific to 9.2 rather than 9.0, IIRC. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Dunscombe, Chris Sent: Thursday, November 13, 2003 3:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman 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: OCP 9i New Features for DBAs
Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: RE: OCP 9i New Features for DBAs
im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: OCP 7.3 8 upgrade to 9i
I actually sat for the beta of that exam, the week before OracleWorld. I haven't received my scores yet, so I doubt that it is actually being offered to the general public yet. But that *is* the plan. Brian - | Brian McGraw -+- Senior DBA | | mailto:[EMAIL PROTECTED] | - -Original Message- Rogers Sent: Monday, October 06, 2003 10:39 AM To: Multiple recipients of list ORACLE-L List, While looking at the Oracle Education site I located a link about the Paris OpenWorld this month and the OCP upgrades. In particular was the upgrade that by-passes the 8 to 8i step on the way to 9i. http://www.oracle.com/education/certification/news/index.html?oowexamcram200 3.html Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs Of the list members that attended Open World in San Francisco, was this available there also? I would like to have this test also available to the DBA's that can not attend an open world meeting. It could be a great help if it eliminates the cost of one test along the way to an upgrade of the OCP. It also raises the questions about the training. A normal new features course is 5 days in length and costs BIG BUCK$. This course is less than a day and cheap. What do they do give the answers and hope you remember them later in the day when you take the test? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw 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: OCP 7.3 8 upgrade to 9i
That sounds very interesting. I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i. Being able to skip the 8/8i exams should make this attractive to many folks. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/06/2003 08:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OCP 7.3 8 upgrade to 9i List, While looking at the Oracle Education site I located a link about the Paris OpenWorld this month and the OCP upgrades. In particular was the upgrade that by-passes the 8 to 8i step on the way to 9i. http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs Of the list members that attended Open World in San Francisco, was this available there also? I would like to have this test also available to the DBA's that can not attend an open world meeting. It could be a great help if it eliminates the cost of one test along the way to an upgrade of the OCP. It also raises the questions about the training. A normal new features course is 5 days in length and costs BIG BUCK$. This course is less than a day and cheap. What do they do give the answers and hope you remember them later in the day when you take the test? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: OCP 7.3 8 upgrade to 9i
Hi All, >From the Oracle Education Certification Page: http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html Shows 4 possible tests: Oracle9i DBA OCP Upgrade Path Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs. In order to make the process of staying current as an Oracle Certified technical professional, those already certified on previous releases of Oracle may upgrade to each future release by simply completing one migration exam. Listed below are the migration exams that are currently available to previously certified Oracle DBAs. Please review the listings below for more specific information. Generally, one exam is required for OCPs to upgrade to each new release of an Oracle DBA track. For example, one exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to Oracle9i. Oracle7.3 and Oracle8 DBA OCPs now have another option to upgrade their DBA OCP credential directly to Oracle9i: Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs. This exam will be available beginning October 2003. Select the exam title below to view the exam objectives. Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs Available October 2003 Upgrade Exam: Oracle7.3 to Oracle8 DBA OCP Exam #1Z0-010 Oracle8 New Features for Administrators Upgrade Exam: Oracle8 to Oracle8i DBA OCP Exam #1Z0-020 Oracle8i New Features for Administrators Upgrade Exam: Oracle8i to Oracle9i DBA OCP Exam #1Z0-030 Oracle9i Database: New Features for Administrators Hope this helps, John [EMAIL PROTECTED] wrote: That sounds very interesting. I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i. Being able to skip the 8/8i exams should make this attractive to many folks. Jared "Ron Rogers" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/06/2003 08:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OCP 7.3 8 upgrade to 9i List, While looking at the Oracle Education site I located a link about the Paris OpenWorld this month and the OCP upgrades. In particular was the upgrade that by-passes the 8 to 8i step on the way to 9i. http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html "Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs" Of the list members that attended Open World in San Francisco, was this available there also? I would like to have this test also available to the DBA's that can not attend an open world meeting. It could be a great help if it eliminates the cost of one test along the way to an upgrade of the OCP. It also raises the questions about the training. A normal new features course is 5 days in length and costs BIG BUCK$. This course is less than a day and cheap. What do they do give the answers and hope you remember them later in the day when you take the test? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: OCP 7.3 8 upgrade to 9i
Thanks, didn't know this was available. Ora NT DBA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/06/2003 02:54 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: OCP 7.3 8 upgrade to 9i Hi All, >From the Oracle Education Certification Page: http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html Shows 4 possible tests: Oracle9i DBA OCP Upgrade Path Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs. In order to make the process of staying current as an Oracle Certified technical professional, those already certified on previous releases of Oracle may upgrade to each future release by simply completing one migration exam. Listed below are the migration exams that are currently available to previously certified Oracle DBAs. Please review the listings below for more specific information. Generally, one exam is required for OCPs to upgrade to each new release of an Oracle DBA track. For example, one exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to Oracle9i. Oracle7.3 and Oracle8 DBA OCPs now have another option to upgrade their DBA OCP credential directly to Oracle9i: Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs. This exam will be available beginning October 2003. Select the exam title below to view the exam objectives. Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs Available October 2003 Upgrade Exam: Oracle7.3 to Oracle8 DBA OCP Exam #1Z0-010 Oracle8 New Features for Administrators Upgrade Exam: Oracle8 to Oracle8i DBA OCP Exam #1Z0-020 Oracle8i New Features for Administrators Upgrade Exam: Oracle8i to Oracle9i DBA OCP Exam #1Z0-030 Oracle9i Database: New Features for Administrators Hope this helps, John [EMAIL PROTECTED] wrote: That sounds very interesting. I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i. Being able to skip the 8/8i exams should make this attractive to many folks. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/06/2003 08:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OCP 7.3 8 upgrade to 9i List, While looking at the Oracle Education site I located a link about the Paris OpenWorld this month and the OCP upgrades. In particular was the upgrade that by-passes the 8 to 8i step on the way to 9i. http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs Of the list members that attended Open World in San Francisco, was this available there also? I would like to have this test also available to the DBA's that can not attend an open world meeting. It could be a great help if it eliminates the cost of one test along the way to an upgrade of the OCP. It also raises the questions about the training. A normal new features course is 5 days in length and costs BIG BUCK$. This course is less than a day and cheap. What do they do give the answers and hope you remember them later in the day when you take the test? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: RE: OCP Architecture question
yeah thats what i figured... but having these certifications are good for my career. thanks. I figured it was a stupid question. From: Cary Millsap [EMAIL PROTECTED] Date: 2003/08/15 Fri AM 01:14:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP Architecture question With respect to evaluating answer number one, it's a bad question, because you have know way to know whether the context is supposed to be a) assume a fixed rollback segment size, but use fewer, larger extents; or b) make the rollback segment larger by using the same number of larger extents. In context (a), #1 is a bad answer. In context (b), it's a better answer, but it's still poor. The thing that really chaps me about stupid certification questions like this is that no answer among the choices listed is really the right thing for you to try to do, which is: shoutFIX THE QUERY THAT'S TAKING SO LONG TO RUN./shout In other words, make queries run quickly enough that they don't require multiple-hour-old undo blocks to produce read-consistent results. Jacking around with rollback segments is just a kludge that will produce results far inferior to what you can achieve by attacking the query problem at its root. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic http://www.hotsos.com/training/clinic101 101 in Sydney - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Tim Gorman Sent: Thursday, August 14, 2003 10:54 PM To: Multiple recipients of list ORACLE-L They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value? Title: Re: OCP Architecture question With respect to evaluating answer number one, its a bad question, because you have know way to know whether the context is supposed to be a) assume a fixed rollback segment size, but use fewer, larger extents; or b) make the rollback segment larger by using the same number of larger extents. In context (a), #1 is a bad answer. In context (b), its a better answer, but its still poor. The thing that really chaps me about stupid certification questions like this is that no answer among the choices listed is really the right thing for you to try to do, which is: shoutFIX THE QUERY THATS TAKING SO LONG TO RUN./shout In other words, make queries run quickly enough that they dont require multiple-hour-old undo blocks to produce read-consistent results. Jacking around with rollback segments is just a kludge that will produce results far inferior to what you can achieve by attacking the query problem at its root. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic101 in Sydney - Hotsos Symposium 2004 March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Gorman Sent: Thursday, August 14, 2003 10:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: OCP Architecture question They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
RE: OCP Architecture question
Ryan, I will research the answer but I have an urgentquestion. Do you have SelfTest Software for the SQL and PL/SQL test or do you have the Architecure and Administration SelfTest Software? Thanks, Ed -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: Thursday, August 14, 2003 9:24 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
Re: RE: OCP Architecture question
i have all of it or 8i. this question was in architecture. I havent looked at the sql and pl/sql stuff since the cert test for that was a blowoff. From: Ed Sherman [EMAIL PROTECTED] Date: 2003/08/15 Fri AM 09:00:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP Architecture question Ryan, I will research the answer but I have an urgent question. Do you have SelfTest Software for the SQL and PL/SQL test or do you have the Architecure and Administration SelfTest Software? Thanks, Ed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ryan Sent: Thursday, August 14, 2003 9:24 PM To: Multiple recipients of list ORACLE-L Subject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value? Ryan, I will research the answer but I have an urgentquestion. Do you have SelfTest Software for the SQL and PL/SQL test or do you have the Architecure and Administration SelfTest Software? Thanks, Ed -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: Thursday, August 14, 2003 9:24 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
RE: OCP Architecture question
1. Maybe, maybe not. To make a point, take it to a ridiculous extreme: Suppose you have a tablespace of 100M with two rollback segments made of 1M extents sizes. Then each segment must use 2M each (minextents must be at least 2) which means either segmentcould possibly grow touse 98M if needed (but not at the same time).Now make the extent sizes 25M. Then each segment uses 50M with no growth possibility.Now you don't have the ability to extend a segment to 98M; so this could be bad. But neither do you have a case where one segment can extend to 98M leaving the other poor segment stuck at 2M; so this could be good. So "It Depends." 2. I think this addresses a different issue; i.e. "failed to extend..." 3. Essentially same reasoning as #1. 4. Essentially same reasoning as #1. 5. No comment needed. -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Thursday, August 14, 2003 8:24 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Architecture question Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
Re: OCP Architecture question
A lot of those multiple choice question are best approached from a reverse standpoint, much like a lot of my recent election experiences. You look at the choices and cross out the ones which are definitely not it until you whittled it down to the number of supposedly correct choices you need. If you don't like any of the choices you have to use those that you least not like. At 05:24 PM 8/14/2003 -0800, you wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: RE: OCP Architecture question
Ryan I have found the actual OCP questions to be clearer. I think it is very hard to develop a good multiple choice exam. And these are tricky because the objective is to test more than simple memorization. You need to administer it to many people and find out which questions aren't clear or are easily misinterpreted. Oracle has the resources to do that, an individual author isn't. My claim is that if you have mastered the material enough to point out flaws with your preparation materials, dude you're ready to pass the exam. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 15, 2003 6:29 AM To: Multiple recipients of list ORACLE-L yeah thats what i figured... but having these certifications are good for my career. thanks. I figured it was a stupid question. From: Cary Millsap [EMAIL PROTECTED] Date: 2003/08/15 Fri AM 01:14:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP Architecture question With respect to evaluating answer number one, it's a bad question, because you have know way to know whether the context is supposed to be a) assume a fixed rollback segment size, but use fewer, larger extents; or b) make the rollback segment larger by using the same number of larger extents. In context (a), #1 is a bad answer. In context (b), it's a better answer, but it's still poor. The thing that really chaps me about stupid certification questions like this is that no answer among the choices listed is really the right thing for you to try to do, which is: shoutFIX THE QUERY THAT'S TAKING SO LONG TO RUN./shout In other words, make queries run quickly enough that they don't require multiple-hour-old undo blocks to produce read-consistent results. Jacking around with rollback segments is just a kludge that will produce results far inferior to what you can achieve by attacking the query problem at its root. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic http://www.hotsos.com/training/clinic101 101 in Sydney - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Tim Gorman Sent: Thursday, August 14, 2003 10:54 PM To: Multiple recipients of list ORACLE-L They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: OCP Architecture question
Ah, the Sherlock Holmes method. I've often used the same method on multiple choice tests with meaningless questions and obscure answers. When you have eliminated the impossible, whatever remains, however improbable, must be the truth I think this is how I passed the Oracle 7 Beta tests, which were quite long. Jared On Fri, 2003-08-15 at 08:19, Wolfgang Breitling wrote: A lot of those multiple choice question are best approached from a reverse standpoint, much like a lot of my recent election experiences. You look at the choices and cross out the ones which are definitely not it until you whittled it down to the number of supposedly correct choices you need. If you don't like any of the choices you have to use those that you least not like. At 05:24 PM 8/14/2003 -0800, you wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: OCP Question
Jay, I would guess B and E. I see no reason for a redo-log switch. Looks like a trick question. B is one correct answer. The other correct is either E or A. I would go for E. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, August 05, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hello: I was going through some OCP questions and wanted to make sure that my answers where correct. This question comes from a 3rd party testing site, I have been checking each question against my study guides to make sure they are correct. I've done some testing and think that my answers might be correct but would like to double check as well as get anyone elses option on the answers and the reasoning for option E. When the status of the tablespace moves from read-only to read write, which tow events occur? (Choose Two) A) Redo-log switch must take place B) Normal checkpoints on the file now occur C) Oracle automatically marks the file for backup D) All objects in the tablespace are checked for integrity E) The the DBWn process writes to the data files of the tablespace I believe the answers are A, B Reason: A) I tested moving the a tablespace from read-only to read write and have noticed a log switch after moving the tablespace to a writeable state. B) Since it is on longer Read-Only it will be updated during the checkpoint process C) Doesn't happen, at least in my reading or testing D) No verify structure is issued, or any of the other oracle tools for object checking are used E) I'm alittle unsure of this one, it should update the headers how since it is in a Read Write mode, although this should only happen at a checkpoint right? Thanks in Advance, Jay _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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: OCP Architecture question
Title: Re: OCP Architecture question They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
RE: OCP Architecture question
Title: Re: OCP Architecture question With respect to evaluating answer number one, its a bad question, because you have know way to know whether the context is supposed to be a) assume a fixed rollback segment size, but use fewer, larger extents; or b) make the rollback segment larger by using the same number of larger extents. In context (a), #1 is a bad answer. In context (b), its a better answer, but its still poor. The thing that really chaps me about stupid certification questions like this is that no answer among the choices listed is really the right thing for you to try to do, which is: shoutFIX THE QUERY THATS TAKING SO LONG TO RUN./shout In other words, make queries run quickly enough that they dont require multiple-hour-old undo blocks to produce read-consistent results. Jacking around with rollback segments is just a kludge that will produce results far inferior to what you can achieve by attacking the query problem at its root. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic101 in Sydney - Hotsos Symposium 2004 March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Gorman Sent: Thursday, August 14, 2003 10:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: OCP Architecture question They all allow the RBS to be bigger. More space available for RBS roughly equals fewer ORA-01555, for most situations... on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote: Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
RE: OCP Test Order
Title: RE: OCP Test Order to tell the truth the networking exam is basically some rote memorization and the questions are straightforward - I prepared while waiting 1/2 hour to take exam at most. The performance tuning exam is what I have been told to immediately forget by some certifiable guru's. Basically, not all of it is incorrect but this will be one area you will be studying again from time to time as new versions and new information becomes available and with your own experiences - IMHO. Bottom-line: Don't think it much matters the perf. tuning exam is slightly more to remember then networking. Good luck. Just get it done and don't fret too much about it. It won't and shouldn't be your final studying by a long-shot. I did BR first because it was my #1 priority and I believe the most applicable - good refresher. I did Perf. tuning next. I did networking as a get this over with certification thing. -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED]] Sent: Monday, June 02, 2003 5:35 PM To: Multiple recipients of list ORACLE-L Subject: OCP Test Order Hello: I resently finished my 8i Backup and Recovery test and was thinking about taking the 8i Networking testing before performance tuning. I was wondering if those of you that have taken both test feel that would be an ok choice of action or would taking performance tuning first be better? Thanks In Advance, jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: OCP Test Order
Jay - Personally I did the Tuning exam next after BR and saved the Network for last because most of it is new to me. The BR and Tuning exams share quite a bit of material in terms of they both require a clear understanding of the Oracle architecture, how the rollback, redo, SGA, etc. all interact. Obviously the thrust of the questions are different, with the BR emphasizing integrity and Tuning emphasizing performance. Networking doesn't share anything with the other modules other than it touches on MTS. So I would vote to go ahead and hit the Tuning next. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Hello: I resently finished my 8i Backup and Recovery test and was thinking about taking the 8i Networking testing before performance tuning. I was wondering if those of you that have taken both test feel that would be an ok choice of action or would taking performance tuning first be better? Thanks In Advance, jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: ocp discount
put OTN20 in the discount code -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]En nombre de AKEnviado el: martes, 27 de mayo de 2003 18:45Para: Multiple recipients of list ORACLE-LAsunto: ocp discount I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak
RE: ocp discount
yes they do. to get it, you register with technet. otn.oracle.com April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, May 27, 2003 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: ocp discount I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Re: RE: ocp discount
im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? From: April Wells [EMAIL PROTECTED] Date: 2003/05/27 Tue PM 01:04:44 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ocp discount yes they do. to get it, you register with technet. otn.oracle.com April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Tuesday, May 27, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. yes they do. to get it, you register with technet. otn.oracle.com April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, May 27, 2003 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: ocp discount I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: RE: ocp discount
Title: RE: RE: ocp discount when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests. Don't remember what the code was, off hand, but I remember it was delivered in one of those two manners. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 27, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: ocp discount im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? From: April Wells [EMAIL PROTECTED] Date: 2003/05/27 Tue PM 01:04:44 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ocp discount yes they do. to get it, you register with technet. otn.oracle.com April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Tuesday, May 27, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: RE: ocp discount
OTN20 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 27 May 2003 10:01:44 -0800 when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests. Don't remember what the code was, off hand, but I remember it was delivered in one of those two manners. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Tuesday, May 27, 2003 12:35 PM To: Multiple recipients of list ORACLE-L im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? From: April Wells [EMAIL PROTECTED] Date: 2003/05/27 Tue PM 01:04:44 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ocp discount yes they do. to get it, you register with technet. otn.oracle.com April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Tuesday, May 27, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: RE: ocp discount
When you signed up for the exam, there was a question as to whether you had any discount codes. It is the same screen that asks if you are an Oracle employee. If you enter the code on that screen, then you receive the discount. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 27, 2003 12:35 PM To: Multiple recipients of list ORACLE-L im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? From: April Wells [EMAIL PROTECTED] Date: 2003/05/27 Tue PM 01:04:44 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ocp discount yes they do. to get it, you register with technet. otn.oracle.com April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Tuesday, May 27, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: RE: ocp discount
Title: RE: RE: ocp discount is it OTN20 ? -ak - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 27, 2003 11:01 AM Subject: RE: RE: ocp discount when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests. Don't remember what the code was, off hand, but I remember it was delivered in one of those two manners. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 27, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: ocp discount im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? From: April Wells [EMAIL PROTECTED] Date: 2003/05/27 Tue PM 01:04:44 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ocp discount yes they do. to get it, you register with technet. otn.oracle.com April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Tuesday, May 27, 2003 11:45 AM To: Multiple recipients of list ORACLE-L I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Re: RE: ocp discount
Yes, that's it. Shamita Singh AK [EMAIL PROTECTED] wrote: is it OTN20 ? -ak - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Tuesday, May 27, 2003 11:01 AM Subject: RE: RE: ocp discount when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests. Don't remember what the code was, off hand, but I remember it was delivered in one of those two manners. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 27, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: ocp discount im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? From: April Wells [EMAIL PROTECTED] Date: 2003/05/27 Tue PM 01:04:44 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ocp discountyes they do. to get it, you register with technet. otn.oracle.comApril Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas ! You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need. ~ Jerry Gillies ~ -Original Message- Sent: Tuesday, May 27, 2003 11:45 AM To: Multiple recipients of list ORACLE-LI heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak The information contained in t! his communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically! disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. Shamita Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
RE: Re: OCP
Well said Kirti - Darell, you wil fail every OCP exam you take with 50%. You need a minimum of about 65% and up to 75% on others (don't know why they vary so much) John -Original Message- Sent: 12 March 2003 13:59 To: Multiple recipients of list ORACLE-L You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev 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: Re: OCP
John, Just to clarify, that wasn't me that said you only need to get 50 % correct on the 9i upgrade exam. This thread looks like it, but my message follows: From: Darrell Landrum [EMAIL PROTECTED] Thanks, Darrell [EMAIL PROTECTED] 03/13/03 03:23AM Well said Kirti - Darell, you wil fail every OCP exam you take with 50%. You need a minimum of about 65% and up to 75% on others (don't know why they vary so much) John -Original Message- Sent: 12 March 2003 13:59 To: Multiple recipients of list ORACLE-L You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum 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: OCP
Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell [EMAIL PROTECTED] 03/12/03 04:09AM Dear All, I plan to take up Oracle Certification (DBA) very soon. Iam quite confused about the tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or go straight for the 9i OCP DBA title, with regard to the complexities of the exam. Thanks in advance for all your help and guidance which would be really helpful. Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum 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: Re: OCP
I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell [EMAIL PROTECTED] 03/12/03 04:09AM Dear All, I plan to take up Oracle Certification (DBA) very soon. Iam quite confused about the tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or go straight for the 9i OCP DBA title, with regard to the complexities of the exam. Thanks in advance for all your help and guidance which would be really helpful. Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Re: OCP
You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: Re: OCP
Title: RE: Re: OCP So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam? -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: OCP You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: Re: OCP
Paula, When you completed the OCP exams, you were given a report card that was stamped and sealed by the test provider with a passed notation. After you have completed all of the requirements for the particular track you were taking you should receive a certificate and card from the Oracle Corp. The report from the testing orginization had a disclamer that you should safe guard the report a proof of completing a track. Ron [EMAIL PROTECTED] 03/12/03 09:39AM So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam? -Original Message- Sent: Wednesday, March 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: OCP
Jai An important part of the OCP is what it means to others, that is people you work for, people that will read your resume. Do you see a possibility that having both 8i and 9i on your resume would be a benefit. For example if a hiring manager specifies Oracle8i OCP, and company policy dictates that job requirements be passed to the HR department for screening, there is a possibility that your Oracle9i OCP would not be considered. Frustrating, irritating, I know, but our ancestors got kicked out of Eden and it's been downhill ever since. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 12, 2003 4:09 AM To: Multiple recipients of list ORACLE-L Dear All, I plan to take up Oracle Certification (DBA) very soon. Iam quite confused about the tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or go straight for the 9i OCP DBA title, with regard to the complexities of the exam. Thanks in advance for all your help and guidance which would be really helpful. Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Re: OCP
50% ?? You're joshing me! Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell [EMAIL PROTECTED] 03/12/03 04:09AM Dear All, I plan to take up Oracle Certification (DBA) very soon. Iam quite confused about the tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or go straight for the 9i OCP DBA title, with regard to the complexities of the exam. Thanks in advance for all your help and guidance which would be really helpful. Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: OCP
Title: RE: OCP I thought it was better on principal of not wanting to spend the $2K for a class. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Jai An important part of the OCP is what it means to others, that is people you work for, people that will read your resume. Do you see a possibility that having both 8i and 9i on your resume would be a benefit. For example if a hiring manager specifies Oracle8i OCP, and company policy dictates that job requirements be passed to the HR department for screening, there is a possibility that your Oracle9i OCP would not be considered. Frustrating, irritating, I know, but our ancestors got kicked out of Eden and it's been downhill ever since. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 12, 2003 4:09 AM To: Multiple recipients of list ORACLE-L Dear All, I plan to take up Oracle Certification (DBA) very soon. Iam quite confused about the tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or go straight for the 9i OCP DBA title, with regard to the complexities of the exam. Thanks in advance for all your help and guidance which would be really helpful. Best Regards Jai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Re: OCP
Title: Message I think there are a couple of ways you can do this. Firstly, if you ring Prometric and try to register for the 9iUpgrade exam. IIRC, they'll ask you for your SSN and their system should reject you if you don't have the necessary pre-req certification. Secondly, you can send an email to [EMAIL PROTECTED]. From what it says on http://www.oracle.com/education/certification/faq/index.html?faq8.html, we're attempting to build an automated way of doing this. Problem is of course that all the records are actually held by Prometric as an independent body, so there may be legal issues with Oracle having a way to access that. As for the 50% passing score, sorry that's just wrong. As you can see here (http://www.oracle.com/education/certification/index.html?dba9i_exam.html), the passing score for that exam is 70%. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 6:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Re: OCP So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam? -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: OCP You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: "Darrell Landrum" [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: Re: OCP
Pete - You've made my day. We had some education money to use or lose last fall, and the 9i New Features class was offered locally. I thought I might be able to take the upgrade class even though I hadn't completed the 8i route. December is not a good month for finding study time, so I shelved that idea. I'm glad I didn't waste time cramming for a test I might not have been qualified for. The 50% comment jolted me because I could probably have made that without cramming. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 12, 2003 10:40 AM To: Multiple recipients of list ORACLE-L I think there are a couple of ways you can do this. Firstly, if you ring Prometric and try to register for the 9i Upgrade exam. IIRC, they'll ask you for your SSN and their system should reject you if you don't have the necessary pre-req certification. Secondly, you can send an email to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . From what it says on http://www.oracle.com/education/certification/faq/index.html?faq8.html http://www.oracle.com/education/certification/faq/index.html?faq8.html , we're attempting to build an automated way of doing this. Problem is of course that all the records are actually held by Prometric as an independent body, so there may be legal issues with Oracle having a way to access that. As for the 50% passing score, sorry that's just wrong. As you can see here ( http://www.oracle.com/education/certification/index.html?dba9i_exam.html http://www.oracle.com/education/certification/index.html?dba9i_exam.html ), the passing score for that exam is 70%. Pete?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:39 AM To: Multiple recipients of list ORACLE-L So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam? -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, March 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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
RE: Re: OCP
I think there are a couple of ways you can do this. Firstly, if you ring Prometric and try to register for the 9i Upgrade exam. IIRC, they'll ask you for your SSN and their system should reject you if you don't have the necessary pre-req certification. Secondly, you can send an email to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . From what it says on http://www.oracle.com/education/certification/faq/index.html?faq8.html http://www.oracle.com/education/certification/faq/index.html?faq8html , we're attempting to build an automated way of doing this. Problem is of course that all the records are actually held by Prometric as an independent body, so there may be legal issues with Oracle having a way to access that. As for the 50% passing score, sorry that's just wrong. As you can see here (http://www.oracle.com/education/certification/index.html?dba9i_exam.html http://www.oracle.com/education/certification/index.html?dba9i_exam.html ), the passing score for that exam is 70%. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 6:39 AM To: Multiple recipients of list ORACLE-L So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam? -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, March 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Re: OCP
You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: Darrell Landrum [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: OCP Hands-On Course Requirement
Title: OCP Hands-On Course Requirement I would recommend Oracle University. http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?redir_type=3p_org_id=lang=source_call=global Ken Janusz, CPIM - Original Message - From: Wiegand, Kurt To: Multiple recipients of list ORACLE-L Sent: Thursday, February 27, 2003 7:59 AM Subject: OCP Hands-On Course Requirement Can anyone direct me towards an "Oracle Authorized Education Center or Partner" in the Washington D.C. area? I'm planning on getting certified but only see Oracle University offering 9-5 Monday-Friday courses. Thanks. Kurt
RE: OCP Exams - What to study out of?
Title: RE: OCP Exams - What to study out of? But I did. All I did was study the Corioulus book - and took the exams. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 05, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? Ken - Wow, I'm impressed. I took and passed one APICS module years and years ago and I can testify that they aren't easy. And I took the module related to my daily job. Can you share any tips on how to study for the SQL exam? I find I learn MUCH more from someone that was forced to reassess their strategy than from people that say oh, I took the manual home two nights and breezed through it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I agree that the SQL exam is very difficult. I've taken it twice and missed passing by just a couple of points. But I will persist. Interestingly enough when I got my APICS CPIM certification I took six exams and passed them all on the first try. The passing grade is 90%. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 11:03 AM Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San
Re: OCP Exams - What to study out of?
Title: RE: OCP Exams - What to study out of? Unfortunately there are no Corioulus books for 9i. Ken - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 06, 2002 8:08 AM Subject: RE: OCP Exams - What to study out of? But I did. All I did was study the Corioulus book - and took the exams. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 05, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? Ken - Wow, I'm impressed. I took and passed one APICS module years and years ago and I can testify that they aren't easy. And I took the module related to my daily job. Can you share any tips on how to study for the SQL exam? I find I learn MUCH more from someone that was forced to reassess their strategy than from people that say "oh, I took the manual home two nights and breezed through it". Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I agree that the SQL exam is very difficult. I've taken it twice and missed passing by just a couple of points. But I will persist. Interestingly enough when I got my APICS CPIM certification I took six exams and passed them all on the first try. The passing grade is 90%. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 11:03 AM Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is "don't take the SQL exam as your first exam". Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly "Insect" Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message ar
RE: OCP Exams - What to study out of?
Title: RE: OCP Exams - What to study out of? Just the first one. That is the only one I have tried. I have the second one Nov. 12th. I am spacing them out a little because I have football games to go to, holidays, elderly parents, etc. I will let you know the gory details if you wish. My approach for the second exam I signed up for (backup and recovery) was the same study Cor. book, take self exams. I haven't gotten a chance to do the self exams yet. Too many other commitments. So this is probably more from the seat of my pants. However, while going through Cor. I am using that to tidy up backup/recovery, writing disaster recovery plans, etc. Killing a few birds with one stone. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 05, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? Paula - You're losing me on the connection between SQL and GUI. I can see a connection between command-line DBA actions and GUI DBA tools. And some GUI report writing tools create SQL for you, but usually we DBAs are called when it creates bad SQL code and we must straighten it out. So have you passed all 5 OCP modules? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I took the SQL exam first and had no problems although I have heard others have. I think it has to do with how I learned - I forced myself to use SQL before getting hooked into a GUI tool of any kind. In the long-run that is a good approach as you will always have that but might not always have the GUI. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, November 05, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its
RE: OCP Exams - What to study out of?
Hi, I remember that replication isn't really covered in Robert's book. The way I did this was to step through the candidate guide and compare it to the index of the New Features book to see what was missing. Regards, Mike Hately -Original Message- Sent: Wednesday, November 06, 2002 3:56 PM To: Multiple recipients of list ORACLE-L Just bought Oracle Press 9i New Features by the illustrious Robert Freeman. Seems good and I have also seen another Oracle Press Book 9i New Features Exam Guide by Daniel Benjamin. This follows the Corioulus format of a chapter and questions and a big test at the end. The worrying thing about Robert's book is that in the introduction he states that due to lack of space he has had to miss certain features out. Unfortunately he does not even list the ones he has missed out. However these books should be used in conjunction with the Oracle documentation so should it should not be too much of an issue. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) 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: OCP Exams - What to study out of?
Just bought Oracle Press 9i New Features by the illustrious Robert Freeman. Seems good and I have also seen another Oracle Press Book 9i New Features Exam Guide by Daniel Benjamin. This follows the Corioulus format of a chapter and questions and a big test at the end. The worrying thing about Robert's book is that in the introduction he states that due to lack of space he has had to miss certain features out. Unfortunately he does not even list the ones he has missed out. However these books should be used in conjunction with the Oracle documentation so should it should not be too much of an issue. John -Original Message- Sent: 06 November 2002 14:34 To: Multiple recipients of list ORACLE-L Unfortunately there are no Corioulus books for 9i. Ken - Original Message - To: Multiple mailto:ORACLE-L;fatcity.com recipients of list ORACLE-L Sent: Wednesday, November 06, 2002 8:08 AM But I did. All I did was study the Corioulus book - and took the exams. -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Tuesday, November 05, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Ken - Wow, I'm impressed. I took and passed one APICS module years and years ago and I can testify that they aren't easy. And I took the module related to my daily job. Can you share any tips on how to study for the SQL exam? I find I learn MUCH more from someone that was forced to reassess their strategy than from people that say oh, I took the manual home two nights and breezed through it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I agree that the SQL exam is very difficult. I've taken it twice and missed passing by just a couple of points. But I will persist. Interestingly enough when I got my APICS CPIM certification I took six exams and passed them all on the first try. The passing grade is 90%. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 11:03 AM Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by
RE: OCP Exams - What to study out of?
In many cases the exams extract exact sentences from the Oracle Uinversity manuals for their correct answers. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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
RE: OCP Exams - What to study out of?
Title: RE: OCP Exams - What to study out of? I took 8i - am taking 8i because I am hoping that then I can just take an upgrade exam for 9i without the $1,000+ course requirement. I believe that is still the case. Please tell me if I am wrong. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: Re: OCP Exams - What to study out of? Unfortunately there are no Corioulus books for 9i. Ken - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 06, 2002 8:08 AM Subject: RE: OCP Exams - What to study out of? But I did. All I did was study the Corioulus book - and took the exams. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 05, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? Ken - Wow, I'm impressed. I took and passed one APICS module years and years ago and I can testify that they aren't easy. And I took the module related to my daily job. Can you share any tips on how to study for the SQL exam? I find I learn MUCH more from someone that was forced to reassess their strategy than from people that say "oh, I took the manual home two nights and breezed through it". Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I agree that the SQL exam is very difficult. I've taken it twice and missed passing by just a couple of points. But I will persist. Interestingly enough when I got my APICS CPIM certification I took six exams and passed them all on the first try. The passing grade is 90%. Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 11:03 AM Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is "don't take the SQL exam as your first exam". Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly "Insect" Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or l
RE: OCP Exams - What to study out of?
And I hope it is okay to take 9i New Features before you've finished all your 8i modules, because I wound up taking a new features class to use up some education money that was expiring. The Oracle instructor, John Hibbard, is superb. He makes the class very entertaining and he has done a lot of research outside the class manual and he throws that in as well. I wanted a short cram sheet with a fast overview of topics likely to be on the 9i New Features exam and ended up writing my own 5-page document, so if anyone wants a copy, send me a private note and I'll send you a copy. No guarantees, and if you find any errors, let me know. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 06, 2002 12:29 PM To: Multiple recipients of list ORACLE-L You are not wrong! And I, too, am doing OCP 8i, then the upgrade. Using the Couchman study guide and sample tests books, Self Test Software sample tests, and (don't laugh) the CBTs by SmartForce (since our company paid for them, might as well use them). Brian 60% 8i OCP (SQL, BR, A A) -Original Message- Sent: Wednesday, November 06, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I took 8i - am taking 8i because I am hoping that then I can just take an upgrade exam for 9i without the $1,000+ course requirement. I believe that is still the case. Please tell me if I am wrong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: OCP Exams - What to study out of?
So you took and passed the upgrade exam already? Brian -Original Message- Sent: Wednesday, November 06, 2002 2:13 PM To: Multiple recipients of list ORACLE-L And I hope it is okay to take 9i New Features before you've finished all your 8i modules, because I wound up taking a new features class to use up some education money that was expiring. The Oracle instructor, John Hibbard, is superb. He makes the class very entertaining and he has done a lot of research outside the class manual and he throws that in as well. I wanted a short cram sheet with a fast overview of topics likely to be on the 9i New Features exam and ended up writing my own 5-page document, so if anyone wants a copy, send me a private note and I'll send you a copy. No guarantees, and if you find any errors, let me know. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richards, Brian 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: OCP Exams - What to study out of?
No (sigh), I just took the class, so now I've got to get the energy to take the test. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 06, 2002 2:20 PM To: Multiple recipients of list ORACLE-L So you took and passed the upgrade exam already? Brian -Original Message- Sent: Wednesday, November 06, 2002 2:13 PM To: Multiple recipients of list ORACLE-L And I hope it is okay to take 9i New Features before you've finished all your 8i modules, because I wound up taking a new features class to use up some education money that was expiring. The Oracle instructor, John Hibbard, is superb. He makes the class very entertaining and he has done a lot of research outside the class manual and he throws that in as well. I wanted a short cram sheet with a fast overview of topics likely to be on the 9i New Features exam and ended up writing my own 5-page document, so if anyone wants a copy, send me a private note and I'll send you a copy. No guarantees, and if you find any errors, let me know. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richards, Brian 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: OCP Exams - What to study out of?
Title: OCP Exams - What to study out of? I only studied the Coriolius books and done the self-exams (which are harder then the real one) and passed with 85+% each time. I think the course materials were not as concise as the Cor. books. I believe you can get some of those books still on Amazon. That publisher is out of business. Someone recently posted which publisher is taking over for them. Good luck. -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 05, 2002 7:09 AMTo: Multiple recipients of list ORACLE-LSubject: OCP Exams - What to study out of? Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly "Insect" Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: OCP Exams - What to study out of?
Denham, I have just passed my 8i upgrade exam and added some notes to a page about getting OCP certification. It can be accessed on http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm Hope you find it interesting John -Original Message- Sent: 05 November 2002 12:09 To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OCP Exams - What to study out of?
Title: RE: OCP Exams - What to study out of? Guys, anyone know about an application called Cloverleaf? Basically, my organization is pursuing using Cloverleaf as the data integration sole application of choice. To me Unix/SQL*Loader and native tools for the various RDBMS usually are more straightforward and provide simplication and less proprietary coding and it is easier for an organization to find others who have those type of skills. Any ideas guys? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 05, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? Denham, I have just passed my 8i upgrade exam and added some notes to a page about getting OCP certification. It can be accessed on http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm Hope you find it interesting John -Original Message- Sent: 05 November 2002 12:09 To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OCP Exams - What to study out of?
Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: OCP Exams - What to study out of?
Title: RE: OCP Exams - What to study out of? I took the SQL exam first and had no problems although I have heard others have. I think it has to do with how I learned - I forced myself to use SQL before getting hooked into a GUI tool of any kind. In the long-run that is a good approach as you will always have that but might not always have the GUI. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 05, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: OCP Exams - What to study out of?
The Cloverleaf product I know is from Quovadx. One of its usages it provides an interface between Healthcare systems and Oracle(many other DBMS). For ex. we use to interface with hospitals sending data in standard HL7 format and Cloverleaf interprets HL7 format and data is loaded directly into Oracle for further processing. See http://www.quovadx.com/ for more info Rick [EMAIL PROTECTED] tate.fl.usTo: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: OCP Exams - What to study out of? 11/05/2002 10:23 AM Please respond to ORACLE-L Guys, anyone know about an application called Cloverleaf? Basically, my organization is pursuing using Cloverleaf as the data integration sole application of choice. To me Unix/SQL*Loader and native tools for the various RDBMS usually are more straightforward and provide simplication and less proprietary coding and it is easier for an organization to find others who have those type of skills. Any ideas guys? -Original Message- Sent: Tuesday, November 05, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Denham, I have just passed my 8i upgrade exam and added some notes to a page about getting OCP certification. It can be accessed on http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm Hope you find it interesting John -Original Message- Sent: 05 November 2002 12:09 To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City
Re: OCP Exams - What to study out of?
I agree that the SQL exam is very difficult. I've taken it twice and missed passing by just a couple of points. But I will persist. Interestingly enough when I got my APICS CPIM certification I took six exams and passed them all on the first try. The passing grade is 90%. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 11:03 AM Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ 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
RE: OCP Exams - What to study out of?
Paula - You're losing me on the connection between SQL and GUI. I can see a connection between command-line DBA actions and GUI DBA tools. And some GUI report writing tools create SQL for you, but usually we DBAs are called when it creates bad SQL code and we must straighten it out. So have you passed all 5 OCP modules? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I took the SQL exam first and had no problems although I have heard others have. I think it has to do with how I learned - I forced myself to use SQL before getting hooked into a GUI tool of any kind. In the long-run that is a good approach as you will always have that but might not always have the GUI. -Original Message- mailto:DWILLIAMS;LIFETOUCH.COM ] Sent: Tuesday, November 05, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: OCP Exams - What to study out of?
Ken - Wow, I'm impressed. I took and passed one APICS module years and years ago and I can testify that they aren't easy. And I took the module related to my daily job. Can you share any tips on how to study for the SQL exam? I find I learn MUCH more from someone that was forced to reassess their strategy than from people that say oh, I took the manual home two nights and breezed through it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 2:04 PM To: Multiple recipients of list ORACLE-L I agree that the SQL exam is very difficult. I've taken it twice and missed passing by just a couple of points. But I will persist. Interestingly enough when I got my APICS CPIM certification I took six exams and passed them all on the first try. The passing grade is 90%. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 11:03 AM Eva - Everything I've heard says that all the exam questions come out of the Oracle University class Student Guides. To put it bluntly, your goal is to pass the exam. You could study the Oracle manuals, but there is a lot of material to cover and what strikes you as important might not be covered on the exam, and vice-versa. Essentially you are getting two levels of filtering. Somebody read the manuals and used that to prepare student guides, then a group of Oracle instructors read the student guide and prepared questions. I think that most of the exam guides were prepared from the Oracle Student Guides and the author has at least taken the exam, so they have a general idea of how the test is approached. Everyone has their favorite exam preparation book and I consider this a worthwhile investment, I bought Couchman - http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 H http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 0Hsourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=007 2133414 sourceid=00400731866779927243bfdate=11%2D05%2D2002+10%3A16%3A17isbn=00721 33414 Two issues: Which exam track are you planning to take? 9i? 8i? The advice I received is don't take the SQL exam as your first exam. Take the DBA exam first. The SQL exam is reported to be quite hard because it covers all the odd SQL functions and can really catch you unawares. As a practicing DBA you should find the DBA exam pretty easy. I didn't personally take that path for my own reasons, but I still consider it good advice. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 05, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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:
RE: OCP Exams - What to study out of?
Title: OCP Exams - What to study out of? Thanks to everyone for their input. I am considering the 8i track. a. Because I work mainly with the 8i DB. b. I hear that for the 9i a attendance of a course is a prerequisite. Regards Denham -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 05, 2002 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: OCP Exams - What to study out of? Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly "Insect" Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Re: OCP (OPP number)/OTN20
If you are an employee of OPP then you can use this code. Enter required info on screen or call them for test appointment and if you want that discount they will ask this question there. Alternately get registered on OTN and claim 'OTN20' for 20% discount(net $100). At examination center they don't ask anything except your identity.. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 07 Oct 2002 10:49:04 -0800 Hi, I just registered for oracle 8i upgrade exam and enter the promotion code OPP(Oracle preffered partner) but it never prompt to enter my company name or partner number. Do i need to take copy of OPP copy at centre or they will not see it at all?? Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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). _ Send and receive Hotmail on your mobile device: http://mobile.msn.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 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: OCP discount
OPP gets you 35% discount (state member of OTN) John -Original Message- Sent: 05 July 2002 16:13 To: Multiple recipients of list ORACLE-L Anybody knows of a current magic code for a discount on OCP exams. I am particularly looking into the 8i DBA upgrade if this does matter. Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic 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: 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: ocp exam/when?
http://www.oracle.com/education/certification/index.html?dba9i_ocp.html The above page shows , Candidates for Oracle9i DBA OCP must pass the following two exams as well as completing at least one Oracle University required hands-on course within the Oracle9i DBA learning path to obtain your OCP credential: check out on the page , even I am not very clear about this ... but seems like you can not eliminate that HANDS ON from Oracle to get OCP credential --Madhu -Original Message-From: Lyuda Hoska [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 20, 2002 4:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ocp exam/when? Thanks. I was scared... I am going to take it a step at the time and become an Associate first. To me it is a good deal you become an Oracle certified (how sweet the sound) only after two exams. I'll move to a next level after gaining more knowledge and taking a little break from studying. Just talked to a friend of mine. He decided to finish his 8i first and then go for upgrade (trying to avoid that exam). He is a consultant. I think my company would pay $2000 if I asked. Depends on the situation... Buy the way; do you have any reference to Oracle official statement that it is required for Masters only? I would appreciate it. Thank you. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 2:37 PMTo: [EMAIL PROTECTED]Subject: RE: ocp exam/when? Check out education.oracle.com and look for certification. the reality is unless you want to become an Oracle Certified Master(which you have to be Oracle Certified Professional first), then the 2K price tag will not pertain to you. joe
Re: OCP Related
Hi Santosh, At the time I needed this material, I didn't find anything valuable in the internet for free. Maybe coz DBA's don't have much free time except for books (which is paid). Maybe reasons are different. :) My advice: nothing better buying good OCP book for 50$. that's 10% of what you're gonna spend for the exams. Some may say about STS practice question software. (again not fo free) The only good free resource i know is education part of Oracle's web site. You may find sample tests of 20 questions there. BTW, they somewhat harder than real exams. :) -- HTH, Alexandre - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Tuesday, June 18, 2002 12:13 PM Subject: OCP Related could any one of you tell me the sites where OCP related materials are available and where i can give free tests for readying for OCP exams ? Thanks and regards,Santosh
RE: RE: OCP newsletter, latest changes...
Here in Canada I was told you can do it if you have a letter from your employer stating that they are unable to provide you with the training you require to stay up-to-date in your field. I asked my previous manager if he could write me such a letter, he just grinned and said: well, it should be our responsibility to provide you with the training you require to stay up to date in your field... and no letter. Since then I spoke with a contractor here, who said that if I keep requesting for training and never get it, I can keep the e-mails as evidence and submit them along with my income tax forms. I'll give it a try, though I give it a 5% chance of success. The irony of all this is that I work for the Federal government here. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 6:22 PM To: Multiple recipients of list ORACLE-L In the US one can put training on their income tax forms, but the IRS will disallow it. Dick Goulet One of the disallowed! Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 6/17/2002 12:05 PM I think this change will up the ante for corporations that do not send their staff to official training courses or expect that staff will keep up to date in their certifications on their own time and money, a $50 book out of one's own pocket doesn't compare with a $2000 course. Employees in Canada can't deduct training etc. before income taxes, only consultants can. I don't know if that's the case in the U.S. or the UK as well. Maybe more people will become consultants, but then again there is a bit of a crunch in the IT job sector right now. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, June 17, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Soon we will be required as a part of the hiring process to make a visit to Oracle for certification, medical check, and brain wash! Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Monday, June 17, 2002 3:18 PM To: Multiple recipients of list ORACLE-L I couldn't believe that, Ron, so I had to check it out myself. You're right: http://www.oracle.com/education/certification/index.html?dba9i_ocmpract.html http://www.oracle.com/education/certification/index.html?dba9i_ocmpract.htm l Oracle Certified Master DBA Practicum Exam An OCM candidate must successfully pass the Oracle Certified Master DBA practicum after having completed the required OU advanced learning requirements. The practicum will be conducted at an Oracle University facility in each global region. The location for Americas is Chicago, IL. The cost for the practicum is $2000.00 US Dollars. Locations for EMEA and APAC have not yet been determined. The practicum is a two-day, hands-on performance based event where candidates will be presented with numerous scenarios that will require them to diagnose and solve highly technical Oracle server related problems. Each candidate will have their own dedicated LINUX server that is configured with the Oracle server software, Oracle Enterprise Manager, and the Oracle documentation set. Topics on the practicum include core database technology, database configuration, replication, partitioning, parallel operations, diagnostics, troubleshooting, performance tuning, and backup and recovery. Candidates may also encounter ad hoc database problems that they will have to resolve, therefore simulating real-world database operations. Oracle tools such as Oracle Enterprise Manager, Data Guard, Flashback, Recovery Manager, and Oracle documentation will be available to candidates during the practicum. Candidates will be scored on their ability to successfully complete the scenarios and if they obtain a passing score they will be awarded the OCM certification. Based upon a candidate's performance during the practicum, they may not be awarded the OCM certification if they do not achieve the preset passing score. I think that the price tag is a way too high to start with, but the thing that really blew me away is that the test is on Linux only??? It's hard for me to believe that they won't let you take it on your platform of choice, especially for the hard-core-Windows guys out there. And I have to use Enterprise Manager? Give me a break - and a SQL prompt. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Rogers Sent: Monday, June 17, 2002 1:34 PM To: Multiple recipients of list ORACLE-L Did you check out the prices for the OCM? Two classes plus $2,000 for the exam the last time I