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
* 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 

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


Other related posts: