| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OCP - Hotsos SQL Optimization
Yes, if your job includes the responsibility to do both "finding" and
"fixing," then I would recommend the order PD101 first, then OP101
second.
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
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Milligan
Sent: Monday, April 26, 2004 11:24 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: OCP - Hotsos SQL Optimization
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_at_hotsos.com]
Sent: Monday, April 26, 2004 4:08 AM
To: oracle-l_at_freelists.org
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
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Milligan
Sent: Friday, April 23, 2004 11:27 AM
To: 'oracle-l_at_freelists.org'
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_at_ingenix.com
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Apr 26 2004 - 11:33:00 CDT
 |
 |