Message-Id: <10619.117054@fatcity.com> From: "Allan Nelson" Date: Thu, 14 Sep 2000 23:15:46 -0500 Subject: Re: Collecting "Metrics" One basic source of information, though kind of dated, is the UTLBSTAT and UTLESTAT scripts provided in $ORACLE_HOME/rdbms/admin. They will give you an overview of the general condition of your Oracle instance. You can modify these scripts to store data in another instance...... Allan ----- Original Message ----- From: "Diana Duncan" To: "Multiple recipients of list ORACLE-L" Sent: Wednesday, September 13, 2000 2:40 PM Subject: Collecting "Metrics" > Listers, > > I've been asked to collect "metrics" on database performance. > Unfortunately, those asking can't give me a straight answer as to what they > are looking for. Anyway, I haven't had to do this before other than for > specific tuning problems, so I thought I'd ask how anyone here goes about > it? Should I use TKPROF over a specific period of load testing? Or some > tool that can generate statistics? Or does anyone have any interesting > queries to extract stats from the v$ views? I think they would like numbers > such as average response time of queries (which I have already managed to > provide somewhat through a test harness), percentage of cache hits, numbers > of transactions processed in a time period, etc. > > Sorry for the general nature of the question, but I haven't been given much > to go on myself... > > Diana Duncan > Database Architect > fileFrenzy.com > diana@filefrenzy.com > 919.833.1766 x 238 > > -- > Author: Diana Duncan > INET: Diana@fileFRENZY.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).