Re: Oracle DB performance tuning training
- From: Stefan Koehler <contact@xxxxxxxx>
- To: sethmiller.sm@xxxxxxxxx
- Date: Sat, 22 Aug 2015 09:41:29 +0200 (CEST)
Hi Seth,
I'm a little confused. You disagree that one should use tools or you disagree
that one should use Oracle's tools?
I disagree with the focus on Enterprise Manager and SQL Developer in such
classes and the suggestion to use them is a necessary thing. Why? Two
obvious reasons for that:
1) Not every client got EE with Diagnostic + Tuning pack and so the benefit of
such a class may not be huge
2) Both tools rely on diagnostic data related to Oracle's database time
definition. This is probably fine for reducing CPU or I/O load on the database
server, but may miss the point in case of a performance issue of the end user
I highly recommend to use tools on proper diagnostic data in relation to the
issue. For example i also use the Enterprise Manager at client site to
get Real Time SQL monitoring reports, etc. but only after it is clear that SQL
<X> is the main driver of user response time. But at first you have to
get there in a systematic way.
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.
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=609&get_params=dc:D79236,clang:EN
http://education.oracle.com/pls/web_prod-plq-dad/view_pdf?c_org_id=34&c_lang=D&c_id=D79236GC10
--------------------------------------------
Introduction
Basic Tuning Diagnostics
Using Automatic Workload Repository
Defining the Scope of Performance Issues
Using Metrics and Alerts
Using Baselines
Using AWR-Based Tools
Real-Time Database Operation Monitoring
Monitoring Applications
Identifying Problem SQL Statements
Influencing the Optimizer
Reducing the Cost of SQL Operations
Using SQL Performance Analyzer
SQL Performance Management
Using Database Replay
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning PGA and Temporary Space
Automatic Memory
Performance Tuning Summary with Waits
--------------------------------------------
Tuning methodology is only one tiny sub chapter of the introduction (and it
seems like based on DB time only as this is a tiny sub chapter in Basic
tuning diagnostics as well). Tuning objectives is also in the subsequent
chapter basic tuning diagnostics, but this should be the first part of the
methodology (in my opinion). Heavily focus on EE option tools that may can not
be used in clients environment and metric (+/- ratio) based tuning.
From my field experience with clients - they usually take the following from
such a class:
1) End user complains about performance
2) Look at top wait events in graphical representation in EM or top section in
AWR in this time window
3) Analzye and reduce it with the mentioned and trained tools
4) Result = Happy end user
... and we all know that this does not work out well in an effective way
(otherwise we would be jobless). A lot of work time in organizations is
wasted on tuning wait event <X> without any notice to the complaining end
users, just because of some tools show some high colorful graphs :-)
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage:
http://www.soocs.de
Twitter: @OracleSK
Seth Miller <sethmiller.sm@xxxxxxxxx> hat am 22. August 2015 um 00:52
geschrieben:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
