Re: Oracle database pro active monitoring and alerting.
From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Sun, 3 Jun 2012 07:56:32 +0300
Message-ID: <CAKnHwtdp89BBixQ35di6aJS1Hzja1tRVCq7Ay41k4yWGo36+2Q_at_mail.gmail.com>
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.
Date: Sun, 3 Jun 2012 07:56:32 +0300
Message-ID: <CAKnHwtdp89BBixQ35di6aJS1Hzja1tRVCq7Ay41k4yWGo36+2Q_at_mail.gmail.com>
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-lReceived on Sat Jun 02 2012 - 23:56:32 CDT