Re: Hotsos Training
Date: Thu, 06 Dec 2012 11:27:30 -0600
Message-ID: <50C0D582.8080505_at_multiservice.com>
I have taken the Hotsos Optimizing Oracle SQL class and found it worthwhile.
For a reference point I've worked with Oracle for 6 years, 2 as a full time DBA. There was some review to the course, however many areas of review clarified items that I thought I fully understood. As Rick said, the class does cover tracing, but (IMO) at a high level and only done to show where the data consumed by their "Harness" tool is coming from.
I'd agree the class isn't particularly tailored towards DBA's and is suited to anyone writing SQL. That being said; plenty of time is spent describing oracle internals and insuring you have a clear view of what oracle is doing behind the scenes when you issue a query. If it's assistance in writing efficient SQL you're after, the Hotsos class is a fantastic starting point which I would recommend.
I've also read Cary's book and attended his Mastering Oracle Trace Data class. If tracing is specifically what you're looking for I would look no further than his class. It's most of a single day and gave me a fantastic jumpstart on understanding how to interpret the trace data and, more importantly, how to present that data to the business to support your decisions.
In either class don't be afraid to ask questions, there's a lot of years of experience hidden in the presenters head. In my experience I've gained as much benefit from sidebar conversations as I've taken away from the classes themselves.
Thanks,
Ryan
On 12/05/2012 01:39 PM, Jeff Chirco wrote:
> Has anyone taken a training class from Hotsos? Specifically I am looking at the Optimizing Oracle SQL, Intensive class. Is this a good class, is it for more advance DBA's? I don't know if I will consider myself advanced yet. Is ready trace files a big or small part of it. Thanks for any input.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
This email is intended solely for the use of the addressee and may contain information that is confidential, proprietary, or both. If you receive this email in error please immediately notify the sender and delete the email.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 06 2012 - 18:27:30 CET