Re: database monitoring tools - what is your short list of

From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Date: Sat, 4 Apr 2009 12:09:11 -0700
Message-ID: <2ead3a60904041209s6c66c4e1wd0dbe0c13f2c703f_at_mail.gmail.com>

Yong, keep in mind that the time period is dependent on your awr retention. 7 days may be too short to detect trends. You might want to extract selected stats from awr and create a custom sql to graph that. This would probably easier done using apex.

On 4/3/09, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
> Well you can define your own metrics as sql statements. You can also
> define your own reports and graph them. So the short answer is yes.
> Apex is probably more powerful for this though.
>
> On 4/3/09, Yong Huang <yong321_at_yahoo.com> wrote:
>>
>> I want to "borrow" this topic to ask, Is there a way in Enterprise Manager
>> or Grid Control to plot a graph of any statistic or wait event for a given
>> period of time? By any, I mean any one in v$statname or v$event_name.
>>
>> Yong Huang
>>
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
> --
> Sent from Google Mail for mobile | mobile.google.com
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Sent from my mobile device

John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 04 2009 - 14:09:11 CDT