So, would it be fair to say that "find 'em then fix 'em" may be a better order than "fix 'em then find 'em"? PD101 then OP101? -----Original Message----- From: Cary Millsap [mailto:cary.millsap@xxxxxxxxxx] Sent: Monday, April 26, 2004 4:08 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: OCP - Hotsos SQL Optimization Michael, Some thoughts "from the vendor," if you don't mind. Here are the official course objectives from www.hotsos.com/education: PD101 -- To introduce students to a scientific method for diagnosing Oracle system performance problems rapidly and accurately, no matter what the root cause. OP101 -- To provide direct hands-on experience that will improve a student's ability to improve the data access performance of individual SQL statements. In other words: OP101 teaches you how to fix the SQL statements that someone who took PD101 has handed you. :) Many of our students, of course, act in both roles. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22 Pittsburgh - SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael Milligan Sent: Friday, April 23, 2004 11:27 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: OCP - Hotsos SQL Optimization Is there a particular recommended order for taking PD101 vs. OP101? Do you recommend both? Now that the quest for my OCP is over, I feel very excited about actually learning about Oracle in ways that will help me be a better DBA! Thanks, Michael Milligan 9i OCP Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 michael.milligan@xxxxxxxxxxx This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------