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- Subject: Re: database monitoring tools - what is your short list of requirements? From: "Jared Still" <jkstill@xxxxxxxxx> Date: 02-04-2009 00:50 On Tue, Mar 31, 2009 at 2:02 PM, Jared Still <jkstill@xxxxxxxxx> 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. -- //www.freelists.org/webpage/oracle-l