Message-Id: <10618.116876@fatcity.com> From: Diana Duncan Date: Wed, 13 Sep 2000 14:34:27 -0400 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