Re: SQL Performance Tuning / CBO Training

Ruan,

Just to add, Jonathan Lewis did some online sessions and you can subscribe for recordings at http://www.speak-tech.com/

Regards,
Vijay Sehgal

> On Sep 25, 2017, at 6:35 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
>
> Nail hit on head. If you happen to be more European in location I would add to these three excellent references Jonathan Lewis and Trivadis (Christian Antognini), and I leave it up to you to discover when and where all of them are having seminars. There are more, but all those mentioned so far are amongst the cream.
>
> mwf
>
> 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> 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> 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