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 >> >> >> > > -- > Sent from Google Mail for mobile | mobile.google.com > > Niall Litchfield > Oracle DBA > http://www.orawin.info > -- > //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 ** -- //www.freelists.org/webpage/oracle-l