| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 -----------------------------------------------------------------Received on Mon Feb 02 2004 - 08:32:16 CST
 |
 |