Re: Oracle database pro active monitoring and alerting.

Thanks for your comments.
We have RDBMS and RAC licenses. Are you saying that grid / cloud control is included RDBMS licenses ? In technology price list April 2012, this is an extra cost option 'cloud management pack for oracle database ' under Database Enterprise Management.

Regards,
Sreejith
-- Sent from my iPhone

On 03-Jun-2012, at 10:26 AM, Ilmar Kerm <ilmar.kerm_at_gmail.com> wrote:

On Sun, Jun 3, 2012 at 5:47 AM, Sreejith S Nair <sreejithsna_at_gmail.com> wrote:
> We have our production databases ( most 11.2.0.2 RAC on Solaris 10) pro -actively monitored by BMC performance manager. We are not really satisfied with this tool.
> We also have set up few cron jobs to monitor few things like ASM disk usage , tablespace usage , mount point usage and all.
>
> I would like to know which tool most of the people use in industry. We do no have grid control and I suppose this is the widely used tool. Does someone use any performance monitoring tool ?
> Or is it managed by SQL queries run by cron ?
> We have OEM dbconsole configured but we are looking for a tool that can monitor alert log , wait events , regular monitoring stuffs and send an email when something crosses a threshold.
>
> Any free tool ?
> Any tool that can execute SQL query at a pre defined interval and send a mail when query returns output.

Grid/cloud control does all these things, it is included in the RDBMS price and it is a very good tool.

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


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