Re: EM, capacity planning and monitoring

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 14 Sep 2010 18:37:58 -0400
Message-ID: <AANLkTikekraznEuO5JwuGiAjaondMmZCY5zrPyrApPEm_at_mail.gmail.com>

"tablespace free space monitoring is done i think once every 15 minutes only. It can be changed but that is the default. Unfortunately there is no canned report for that but what i have done (when encountered such requests), is to write sql and encapsulate that with some pre-set html and use Google visualization. problem solved.

Google visualization has on advantage over Google charts, no data is sent to servers but it is rendered in your browser only. For charts, their server caches data for some time. For datafile monitoring, I am sure you can add custom monitoring, it isn't very easy. But then again you have to ask yourself, why do you need minute-by-minute monitoring?

BTW there was a bug in dba_free_space (which oem uses) in 10202/10203 and a patch is available. Ensure it is applied so OEM can correctly identify free space.

Raj

On Mon, Sep 13, 2010 at 3:38 PM, Stefano Cislaghi <s.cislaghi_at_gmail.com>wrote:

> Hi all,
>
> does anyone know if, and maybe how, it's possibile with EM to monitor
> datafile space allocation, tablespace free space per minute...
> I've never used EM for this, instead I've always used and seen to be used
> few sql scripts and graphical tools as cacti, rrd, or custom ones...
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 14 2010 - 17:37:58 CDT