Re: How can I monitor .....

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Mon, 25 Jun 2001 02:20:59 GMT
Message-ID: <3B36A293.BA857397@telusplanet.net>

I'd recommend Oracle Enterprise Manager [OEM] - Diagnostic Pack, or StatsPack. Or you could write your own utillity. Or you could get a freeware or purchased utility to do this (I'm sure lots of people will give advice on this aspect).

OEM is free with the database (See technet documentation for installation, etc.) but Diagnostics Pack, which has exactly this functionality and more, does require an additional license.

StatsPack is a major enhancement of bstat/estat and a lot more - there is a decent Oracle Press book titled "Oracle High Performance Tuning with STATSPACK" which includes a section on gathering long term trend stats. Oracle Press can be accessed through Technet (http://technet.oracle.com)

/Hans

Baba Yetunde wrote:

> I need some advice on how to monitor database/table growth over a period.
> What would be the best practise to
> aceive this?
>
> regards
>
> Fogun
Received on Sun Jun 24 2001 - 21:20:59 CDT