Are you willing to share the solution with
us ? George ________________________________________________ Oracle Database
Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575
0573 Fax: (+27 11) 576
0573 E-mail:[EMAIL PROTECTED] You Have The Obligation
to Inform One Honestly of the risk, And As a Person You Are Committed to
Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally
Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as
They See Fit! -----Original Message----- I concur with the recommendation to use STATSPACK but
you might want to augment it. I take STATSPACK snapshots every 15 minutes and
if there's a performance problem caused by a few bad queries I can usually
isolate the offenders. But constant fined-grained STATSPACK snapshots can be a
lot of overhead so you may want something more lightweight. I've developed a DBA web app which queries V$SYSSTAT
and V$SYSTEM_EVENT every minute. I assume regular queries on these tables do
not impact system performance enough to worry about. I record the result sets
from these queries outside of Oracle in a very light weight RRDTool "round
robin database." (RRDTool is free, http://people.ee.ethz.ch/~oetiker/webtools/rrdtool/.)
>From this I can produce 55 graphs on demand for 5 different time spans: daily;
weekly; monthly; quarterly; and yearly. Of course damagement loves
graphs/pictures. The storage needed for one plus year's worth of minute to
minute V$SYSSTAT/V$SYSTEM_EVENT query data only comes to 3.2MB for each
database instance being monitored. A cool thing to do is produce a graph with a
visually obvious spike in some V$SYSTEM_EVENT wait statistic at say 3:15PM
yesterday then correlate that graphic spike to a specific problem query as
recorded in STATSPACK. It provides nice "smoking gun" incriminating
evidence to be used for putting duhvelopers on trial. Steve Orr -----Original Message----- Ok, thanks -----Original Message----- Tom - I'll provide an example of what we do and maybe
it will give you some Dennis Williams -----Original Message----- All, I would like to track the performance of my
production databases by running |
Title: RE: Database tracking
- RE: Database tracking Jared . Still
- RE: Database tracking Post, Ethan
- Re: Database tracking Arup Nanda
- RE: Database tracking Jamadagni, Rajendra
- RE: Database tracking STEVE OLLIG
- RE: Database tracking Charu Joshi
- RE: Database tracking Jamadagni, Rajendra
- RE: Database tracking Orr, Steve
- RE: Database tracking Post, Ethan
- RE: Database tracking Rajesh . Rao
- RE: Database tracking Leonard, George
- RE: Database tracking Orr, Steve
- Re: Database tracking Anjo Kolk