Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Capacity Planner from OEM VS Statspack
I'd summarize this way:
Statspack is "worse than useless" for diagnosing performance problems. Something is useless if it doesn't work. It is worse than useless if it inspires confidence while not working.
I regularly meet clients who learn the inadequacies of Statspack data only after months--sometimes years--of pain. The problem with Statspack in the problem diagnosis application is that it's *unreliable*. It works sometimes, but not always. Being unreliably correct is even worse than being reliably incorrect, because unreliably correct tools inspire false confidence.
That said, Statspack is an excellent tool in the capacity planning application, where you *need* aggregated data.
So, please don't take me wrong. Statspack is a tool. A tool itself is neither good nor bad; it's the *application* of a tool that is good or bad. A screwdriver is lousy at driving a nail but good at turning a screw.
Statspack is a lousy tool for performance problem diagnosis. It's a fine tool for some other applications.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald
Sent: Monday, February 02, 2004 8:32 AM
To: oracle-l_at_freelists.org
Subject: RE: Capacity Planner from OEM VS Statspack
I'm a relatively new DBA but I have 30 years electronic engineering =
experience. I'm used to tools that work and actually measure what they
=
purport to. I got all excited about the capacity planner about 6 months
=
ago and asked the same questions you are asking now. Mostly, nobody is
=
using it. It becomes a headache itself, the agent fails and causes you
=
grief. I don't think you'll find much usefulness in it. When you start
=
troubleshooting it won't give you anything helpful.=20
After reading Carey Milsaps Optimizing Oracle Performance I am less than
=
thrilled with statspack also. You can't solve (or even determine) a =
particular problems origin while looking at aggregate values.
The main value of these things is to provide a comfort level and =
distraction to management. Attach your statspack report to an email and
=
send it to your boss. It should keep him (or her) busy for some time =
while you work on the database.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Luc.Demanche_at_astrazeneca.com
Sent: Monday, February 02, 2004 9:19 AM
To: oracledba_at_lazydba.com; oracle-l_at_freelists.org
Subject: Capacity Planner from OEM VS Statspack
Hi DBA,
I'm starting to take a look at the "Capacity Planner" tool from the
Diagnostics Pack.
Great tool, collects info on lots of interesting statistics ... =20
from databases=20
I have two questions:
1- Are a lot of you using it?
2- Does STATSPACK become less usefull? I would keep STATSPACK for the =
SQL
level. Capacity Planner doesn't seem to handler that level. Right?
Thanks
Luc
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Feb 02 2004 - 09:46:44 CST