Ram, To graph data using EM you need to store it in the repository under the user MGMT_VIEW (or make sure MGMT_VIEW has access to the table). Use the "Reports" tab to create a graph on whatever data you're trying to graph. You could also work with GNU and have the entire process automated. DAVID HERRING DBA Acxiom Corporation EML dave.herring@xxxxxxxxxx TEL 630.944.4762 MBL 630.430.5988 1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ram K Sent: Tuesday, November 06, 2012 1:56 PM To: rjamya Cc: oracle-l Subject: Re: Performance graphs Thanks a lot. To generate graphs via OEM do we store data inside OEM? I am talking several months of data. OEM newbie here. When something goes wrong in a DB, they may want to pull up the data from several months ago to compare. On Tue, Nov 6, 2012 at 1:39 PM, rjamya <rjamya@xxxxxxxxx> wrote: > AWR cant be stored in OEM, AWR stays in individual DB (unless you > export and consolodate). But is is possible to generate your graphs > via oem or Excel or using google visualization. You can also use APEX > to generate your own graph pages. > > > On Tue, Nov 6, 2012 at 2:19 PM, Ram K <lambu999@xxxxxxxxx> wrote: > >> Thanks Raj. Can we store data in OEM and get graphs for the previous >> months or establish baselines like we do with awr? >> >> >> On Tue, Nov 6, 2012 at 1:08 PM, rjamya <rjamya@xxxxxxxxx> wrote: >> >>> I thought OEM already does some of it. is that not sufficient? >>> >>> Raj >>> >>> >>> On Tue, Nov 6, 2012 at 2:01 PM, Ram K <lambu999@xxxxxxxxx> wrote: >>> >>>> All >>>> Our management has decided to put together statistics from various >>>> resources including OS, network, san etc into a central location >>>> and plot things in the form of a graph. The purpose is to track the >>>> trends in growth and utilization patterns in the resource usage. >>>> >>>> We can use awr to track database related information. Is there >>>> anyway to see data in the form a graph; upper management is >>>> interested in graphical outputs. >>>> >>>> -- >>>> Thanks, >>>> Ram. >>>> >>>> >>>> -- >>>> //www.freelists.org/webpage/oracle-l >>>> >>>> >>>> >>> >> >> >> -- >> Thanks, >> Ram. >> > > -- Thanks, Ram. -- //www.freelists.org/webpage/oracle-l *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. **************************************************************************** -- //www.freelists.org/webpage/oracle-l