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 -----------------------------------------------------------------