Re: Oracle DB performance tuning training
Date: Fri, 21 Aug 2015 17:52:21 -0500
Message-ID: <CAEueRAWgzLuFqe9+opZaCk+_tmx9nbb_b1WmMBSh8hj7rm4xog_at_mail.gmail.com>
> Sorry, but i totally disagree in this point. I regularly see how these
fency tools are used in the field and how the data is interpreted in relation
> to the performance issue. It is not a question of doing things manually
or the tools itself. It is a question of the methodology and understanding
> (the source of) the data in relation to the issue.
I'm a little confused. You disagree that one should use tools or you disagree that one should use Oracle's tools?
I'm looking at the table of contents for the 12c Performance Management and Tuning course right now. I don't see anything in here indicating that methodology and understanding the data should be ignored in favor of just using the tool blindly.
Oracle Database 12c: Performance Management and Tuning -- Course Topics
Who Tunes?
What Does the DBA Tune?
How to Tune
Tuning Methodology
Basic Tuning Diagnostics
Performance Tuning Diagnostics
Performance Tuning Tools
Tuning Objectives
Top Timed Events
DB Time
CPU and Wait Time Tuning Dimensions
Time Model
Dynamic Performance Views
Seth Miller
On Fri, Aug 21, 2015 at 1:32 PM, Stefan Koehler <contact_at_soocs.de> wrote:
> Hi,
>
> > I teach the Oracle University classes and yes, much of the material is
> focused on the tools (with a heavy focus on Enterprise Manager and Sql
> > Developer) developed by Oracle. Unless your job consists only of
> performance tuning and you have lots of spare time to do everything
> manually, using
> > the tools for as much as possible is a good and necessary thing.
>
> Sorry, but i totally disagree in this point. I regularly see how these
> fency tools are used in the field and how the data is interpreted in
> relation
> to the performance issue. It is not a question of doing things manually or
> the tools itself. It is a question of the methodology and understanding
> (the source of) the data in relation to the issue.
>
> This is one of the main reasons for me to suggest the class by Method-R,
> Cary Millsap. Afterwards you know what performance is about and how to
> collect, process and interpret the performance data correctly.
>
> Best Regards
> Stefan Koehler
>
> Freelance Oracle performance consultant and researcher
> Homepage: http://www.soocs.de
> Twitter: _at_OracleSK
>
> > Seth Miller <sethmiller.sm_at_gmail.com> hat am 21. August 2015 um 19:55
> geschrieben:
> >
> > Deborah,
> >
> > Oracle Database Performance Tuning is a large topic and only so much
> can be covered in a 2-5 day course. What you want to learn and how deep you
> > want to go will have a large influence on the course you will want to
> take.
> >
> > Many of us on this list are instructors and we all have different ways
> of teaching the material with varying levels of experience. In my opinion,
> > your instructor will have the biggest influence on the volume and value
> of the information you retain.
> >
> > I teach the Oracle University classes and yes, much of the material is
> focused on the tools (with a heavy focus on Enterprise Manager and Sql
> > Developer) developed by Oracle. Unless your job consists only of
> performance tuning and you have lots of spare time to do everything
> manually, using
> > the tools for as much as possible is a good and necessary thing.
> >
> > When I teach classes, I try to engage the students as much as possible
> and adapt the material to their environment and how they learn best. Not all
> > instructors are able or willing to do this so it is very advantageous
> for you to know who your instructor will be, the knowledge and experience
> > level of that instructor, and the previous experience of students that
> have taken classes taught by that instructor.
> >
> > Seth Miller
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 22 2015 - 00:52:21 CEST