RE: SQL Performance Tuning / CBO Training

Just to chime in, I teach said class and I think it’s great! ☺ I can travel too.

+--+--+--+--+--+--+--+--+--+--+--+--+--+--+ Ric Van Dyke
Education Director
Oracle Ace
Hotsos Ltd.
**** Hotsos Symposium
**** MAR 5-8 2018
Make your plans to be there now!

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kellyn Pot'Vin-Gorman Sent: Monday, September 25, 2017 5:45 PM To: jt2354_at_gmail.com
Cc: ruandav_at_gmail.com; Oracle-L oracle-l Subject: Re: SQL Performance Tuning / CBO Training

Hi John and Ruan,
Cary and HotSos became two separate entities a LONG time ago. As much as I worship and have attended the mastering trace data classes, the focus of HotSos vs. Method R can be quite different. I’d recommend both considering HotSos training and purchasing Cary’s book to take advantage of his valuable tracing practices. Another option and different in its approach would be Craig Shallahamer’s classes from Orapub.

Hope this helps,
Kellyn Pot’Vin-Gorman

On Sep 25, 2017, at 3:37 PM, John Thomas <jt2354_at_gmail.com<mailto:jt2354_at_gmail.com>> wrote:

HotSos used to be Cary Milsap's company, so probably the right stuff. Or you could just buy them his book - "Optimizing Oracle Performance". (IMHO)

Regards,

John

On Fri, 22 Sep 2017 at 00:33 Ruan Linehan <ruandav_at_gmail.com<mailto:ruandav_at_gmail.com>> wrote: Hi all,

I am exploring options to improve the understanding of one or two Oracle DBA's with respect to more in-depth / advanced SQL performance tuning. I am aware there are many excellent online resources freely available (and the paper versions) and nothing in my opinion would trump on-the-job experience, however we have a training budget available and I'm curious to see whats available out there.

Would anyone please be so kind as to offer reccomendations/advice on any paid training resources (Preferably available online), else within the UK, with regard to advanced SQL tuning or CBO performance?

What seems like an applicable candidate, of which I have uncovered thus far is from HotSos for Advanced Optimizer concepts (I'll avoid directly linking to the page here).

Any suggestions would be most appreciated.

Regards,
Ruan Linehan
--

Regards,
John

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 26 2017 - 21:25:20 CEST