Re: database monitoring tools - what is your short list of requirements?
From: Amar Kumar Padhi <amar.padhi_at_gmail.com>
Date: Fri, 3 Apr 2009 12:57:55 +0400 (GST)
Message-ID: <20226704.5621238749302598.JavaMail.seven_at_aomfe2p1>
One more addition
**orphaned and heavy load session alert ** On my apps instances, there are occurrences of processes at unix/Linux level that occupy more than 20-25% of Cpu load. These sessions are either orphaned or genuine batch process or bad query run by users. I am planning to place an alert during day time to warn end users after certain time interval, and get rid of orphaned ones with proper logs.
Date: Fri, 3 Apr 2009 12:57:55 +0400 (GST)
Message-ID: <20226704.5621238749302598.JavaMail.seven_at_aomfe2p1>
One more addition
**orphaned and heavy load session alert ** On my apps instances, there are occurrences of processes at unix/Linux level that occupy more than 20-25% of Cpu load. These sessions are either orphaned or genuine batch process or bad query run by users. I am planning to place an alert during day time to warn end users after certain time interval, and get rid of orphaned ones with proper logs.
Thanks!
Amar
Www.amar-Padhi.com
-original message-
Re: database monitoring tools - what is your short list of requirements?
From: "Jared Still" <jkstill_at_gmail.com>
Date: 02-04-2009 00:50
On Tue, Mar 31, 2009 at 2:02 PM, Jared Still <jkstill_at_gmail.com> wrote:
> The long running thread on monitoring tools has piqued my curiosity.
>
> What would you say are the essentials for database monitoring?
>
Hard to believe that no one has any input on this.
Here's another chance.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 03 2009 - 03:57:55 CDT