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_at_filefrenzy.com
919.833.1766 x 238 Received on Wed Sep 13 2000 - 13:34:27 CDT