RE: Capacity Planner from OEM VS Statspack
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 2 Feb 2004 09:46:44 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman, Donald
Sent: Monday, February 02, 2004 8:32 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Luc.Demanche@xxxxxxxxxxxxxxx
Sent: Monday, February 02, 2004 9:19 AM
To: oracledba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
- Response time
- Wait events
- I/O
- Storage=20
- ...=09
and servers
- CPU
- Memory
- File system
- ...
=20
Good Report tool, create graphics and you can even do a trend=20
analysis...=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
---------
Luc Demanche
AstraZeneca R&D Montreal
Oracle Database Administrator
514.832.3200 x2356
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
