Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 3035 invoked from network); 25 Sep 2007 16:51:17 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 25 Sep 2007 16:50:54 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 45FA47758C4;
 Tue, 25 Sep 2007 17:44:46 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 03489-02-2; Tue, 25 Sep 2007 17:44:46 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AA351775863;
 Tue, 25 Sep 2007 17:44:45 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 25 Sep 2007 16:56:55 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3EC6077676C
 for <oracle-l@freelists.org>; Tue, 25 Sep 2007 16:56:55 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 31195-05 for <oracle-l@freelists.org>;
 Tue, 25 Sep 2007 16:56:55 -0400 (EDT)
Received: from email10.mywebmailserver.com (email10.mywebmailserver.com [199.231.136.140])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BA32776828
 for <oracle-l@freelists.org>; Tue, 25 Sep 2007 16:56:26 -0400 (EDT)
Received: from 600d620tcoyle ([72.165.244.50])
        by email10.mywebmailserver.com (IntelliMail) with ASMTP id CRY74585;
        Tue, 25 Sep 2007 16:45:40 -0400
From: "Ted Coyle" <oracle-l@webthere.com>
To: <phamou@renaps.com>,
 <Mark.Bobak@il.proquest.com>
Cc: <sunil.kanderi@gmail.com>,
 "'oracle-l'" <oracle-l@freelists.org>
References: <75aa80160709200314h475c66fh2c997c7cc5cae93c@mail.gmail.com> <46F27EC3.2060804@gmail.com> <AA29A27627F842409E1D18FB19CDCF270D69782D@AABO-EXCHANGE02.bos.il.pqe> <BAYC1-PASMTP030F56F9A9FBA9F4435108BFB70@CEZ.ICE>
Subject: RE: Training for Oracle Performance tuning (Optimization)
Date: Tue, 25 Sep 2007 16:44:57 -0400
Message-ID: <000601c7ffb4$efdf1840$3921a8c0@medecision.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C7FF93.68CD7840"
In-Reply-To: <BAYC1-PASMTP030F56F9A9FBA9F4435108BFB70@CEZ.ICE>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-archive-position: 1877
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: oracle-l@webthere.com
Precedence: normal
Reply-to: oracle-l@webthere.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
------=_NextPart_000_0007_01C7FF93.68CD7840
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

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@freelists.org> oracle-l-bounce@freelists.org
[ <mailto:oracle-l-bounce@freelists.org>
mailto:oracle-l-bounce@freelists.org] 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.




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

------=_NextPart_000_0007_01C7FF93.68CD7840
Content-Type: text/html; charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<title> </title>
<style>
<!--a:link
	{mso-style-priority:99;}
span.MSOHYPERLINK
	{mso-style-priority:99;}
a:visited
	{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
	{mso-style-priority:99;}

 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:Calibri;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";
	color:black;}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle18
	{mso-style-type:personal;
	font-family:Calibri;
	color:#1F497D;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>The Hotsos classes I&#8217;ve =
taken changed
how I &#8220;optimize&#8221; Oracle, so I can&#8217;t say enough good =
things
about the Hotsos folks.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>Independently, I know people =
who
have attended Mr. Shallahamer&#8217;s courses as well and have found =
them
equally beneficial.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>As for your course selection, =
what
is it that you most want to accomplish: reactive performance =
optimization, or preemptive,
performance-based SQL development?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>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.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>The Reactive class appears =
similar
to the Hotsos Performance Diagnostics which is more in line with =
production
support.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>Have you checked out =
METHOD-R?&nbsp;
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>What about Craig&#8217;s =
book?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>Method-R<o:p></o:p></span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><a
href=3D"http://www.hotsos.com/method-r.html"><font color=3Dblack><span
style=3D'color:windowtext'>http://www.hotsos.com/method-r.html</span></fo=
nt></a><o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><a
href=3D"http://www.bookpool.com/sm/059600527X">http://www.bookpool.com/sm=
/059600527X</a><o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>Forecasting Oracle =
Performance:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><a
href=3D"http://www.bookpool.com/sm/1590598024"><font color=3Dblack><span
style=3D'color:windowtext'>http://www.bookpool.com/sm/1590598024</span></=
font></a><o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>If you can&#8217;t take both
classes, make sure the focus is what you expect.&nbsp; =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>Personally I&#8217;d opt for =
Hotsos Performance
Diagnostics first, but then I really like Method-R.&nbsp; =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'>-Ted<o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:windowtext'><o:p>&nbsp;</o:p></span></font=
></p>

<div>

<div style=3D'border:none;border-top:solid windowtext =
1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>

<p class=3DMsoNormal><b><font size=3D2 color=3Dblack face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight=
:bold'>From:</span></font></b><font
size=3D2 color=3Dblack face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:windowtext'> <a =
href=3D"mailto:oracle-l-bounce@freelists.org"><font
color=3Dblack><span =
style=3D'color:windowtext'>oracle-l-bounce@freelists.org</span></font></a=
>
[<a href=3D"mailto:oracle-l-bounce@freelists.org"><font =
color=3Dblack><span
style=3D'color:windowtext'>mailto:oracle-l-bounce@freelists.org</span></f=
ont></a>]
<b><span style=3D'font-weight:bold'>On Behalf Of </span></b>Sunil =
Kanderi<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, September =
20, 2007
10:08 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> oracle-l<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Training for =
Oracle
Performance tuning <u1:p></u1:p></span></font><font color=3Dblack><span
style=3D'color:windowtext'><o:p></o:p></span></font></p>

</div>

</div>

<p class=3DMsoNormal><u1:p><font size=3D3 color=3Dblack face=3D"Times =
New Roman"><span
style=3D'font-size:12.0pt;color:windowtext'>&nbsp;<o:p></o:p></span></fon=
t></u1:p></p>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3 =
color=3Dblack
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:windowtext'>All:<br>
<br>
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.<br>
<br>
First Option:<br>
<br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:windowtext'>Advanced Reactive Performance =
Management
for Oracle taught by Craig Shallahamer. </span></font><font =
color=3Dblack><span
style=3D'color:windowtext'><br>
<br>
<a href=3D"http://resources.orapub.com/product_p/rpm.htm" =
moz-do-not-send=3Dtrue><font
color=3Dblack><span =
style=3D'color:windowtext'>http://resources.orapub.com/product_p/rpm.htm<=
/span></font></a><br>
<br>
Second Option:<br>
<br>
Hotsos's Optimizing Oracle SQL, Intensive<br>
<br>
<a href=3D"http://hotsos.com/educ_op.html" moz-do-not-send=3Dtrue><font
color=3Dblack><span =
style=3D'color:windowtext'>http://hotsos.com/educ_op.html</span></font></=
a><br>
<br>
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&nbsp;
classes that you can recommend for performance tuning?. <br>
<br>
Thanks,<br>
Sunil.<br>
<br>
<br>
<o:p></o:p></span></font></p>

<u1:p></u1:p></div>

</body>

</html>
--
http://www.freelists.org/webpage/oracle-l
------=_NextPart_000_0007_01C7FF93.68CD7840--

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


