Re: Oracle database pro active monitoring and alerting.

  • From: Ilmar Kerm <ilmar.kerm@xxxxxxxxx>
  • To: Oracle - L <Oracle-L@xxxxxxxxxxxxx>
  • Date: Sun, 3 Jun 2012 07:56:32 +0300

On Sun, Jun 3, 2012 at 5:47 AM, Sreejith S Nair <sreejithsna@xxxxxxxxx> wrote:
> We have our production databases ( most 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

Other related posts: