RE: Training for Oracle Performance tuning (Optimization)

  • From: "Ted Coyle" <oracle-l@xxxxxxxxxxxx>
  • To: <phamou@xxxxxxxxxx>, <Mark.Bobak@xxxxxxxxxxxxxxx>
  • Date: Tue, 25 Sep 2007 16:44:57 -0400

The Hotsos classes I've taken changed how I "optimize" Oracle, so I can't
say enough good things about the Hotsos folks.

 

Independently, I know people who have attended Mr. Shallahamer's courses as
well and have found them equally beneficial.

 

As for your course selection, what is it that you most want to accomplish:
reactive performance optimization, or preemptive, performance-based SQL
development?

The SQL Intensive will give you great SQL development and adjustment
techniques, but my opinion is that this class is better for developers and
secondarily beneficial to database administrators.

The Reactive class appears similar to the Hotsos Performance Diagnostics
which is more in line with production support.

 

Have you checked out METHOD-R?  

What about Craig's book?

 

Method-R

 <http://www.hotsos.com/method-r.html> http://www.hotsos.com/method-r.html

http://www.bookpool.com/sm/059600527X

 

Forecasting Oracle Performance:

 <http://www.bookpool.com/sm/1590598024>
http://www.bookpool.com/sm/1590598024

 

If you can't take both classes, make sure the focus is what you expect.  

Personally I'd opt for Hotsos Performance Diagnostics first, but then I
really like Method-R.  

 

 

 

-Ted

 

 

 

 

 

 

From:  <mailto:oracle-l-bounce@xxxxxxxxxxxxx> oracle-l-bounce@xxxxxxxxxxxxx
[ <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sunil Kanderi
Sent: Thursday, September 20, 2007 10:08 AM
To: oracle-l
Subject: Training for Oracle Performance tuning 

 

All:

I am thinking of enrolling in an Oracle tuning class and I have narrowed
down to the two options below. I took one Oracle DBA class from Oracle and I
was pretty disappointed since the instructor was pretty bad and it was very
clear that whatever real world Oracle DBA experience he had, was quite
dated. But the class served it purpose though, since Oracle requires(devious
in my mind) one instructor-led class before you can get certified in 10g. I
realize it is hit and miss if you take a class from Oracle, so I am not
considering their courses.

First Option:

Advanced Reactive Performance Management for Oracle taught by Craig
Shallahamer. 

 <http://resources.orapub.com/product_p/rpm.htm>
http://resources.orapub.com/product_p/rpm.htm

Second Option:

Hotsos's Optimizing Oracle SQL, Intensive

 <http://hotsos.com/educ_op.html> http://hotsos.com/educ_op.html

Both classes deal with Oracle tuning and I realize that the curriculum is
not exactly the same, but I was wondering if any of you that took these
classes have any feedback on how good or bad they were. Any other
instructor-led  classes that you can recommend for performance tuning?. 

Thanks,
Sunil.




-- //www.freelists.org/webpage/oracle-l

Other related posts: