Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Collecting "Metrics"
You may want to try statpack (new with 8i, but can also run against 8.0)
also. I haven't really used it yet, but it looks like it's more versatile
than utlbstat/utlestat...
-----Original Message-----
From: Allan Nelson [mailto:anelson_at_houston.rr.com]
Sent: Friday, September 15, 2000 1:11 AM
To: Multiple recipients of list ORACLE-L
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 -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, September 13, 2000 2:40 PM
> 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
>
> --
> Author: Diana Duncan
> INET: Diana_at_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_at_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).
-- Author: Allan Nelson INET: anelson_at_houston.rr.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_at_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 mayReceived on Fri Sep 15 2000 - 08:05:21 CDT
![]() |
![]() |