Re: database monitoring tools - what is your short list of
- From: Yong Huang <yong321@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx, John Kanagaraj <john.kanagaraj@xxxxxxxxx>
- Date: Sat, 4 Apr 2009 12:48:50 -0700 (PDT)
Yes, I'm aware of the default 7 day limit. I changed it to 14 days on the
database I considered the most important. I just want to have a quick way to
graph the trend of any stat or event on an ad-hoc basis using a tool our team
is already using, i.e. Grid Control.
Writing a SQL to extract numbers and plot is what I usually do. From the
simplest to more sophisticated:
* my rpad()-based SQL
//www.freelists.org/post/oracle-l/making-graphical-reports-from-oracle-metrics,23
* using Excel (put numbers in columns and plot, or use VBA code like the one by
Tanel Poder)
* using specialized tool such as Apex
But since our shop uses GC to do most monitoring, I thought there was a page in
GC where I can pick from a drop-down a statistic or wait event and get the
curve.
Yong Huang
--- On Sat, 4/4/09, John Kanagaraj <john.kanagaraj@xxxxxxxxx> wrote:
From: John Kanagaraj <john.kanagaraj@xxxxxxxxx>
Subject: Re: database monitoring tools - what is your short list of
To: niall.litchfield@xxxxxxxxx, yong321@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Saturday, April 4, 2009, 2:09 PM
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@xxxxxxxxx> 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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
