Re: Average response times, cache hits, etc.

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 27 Jun 2006 05:39:52 -0700
Message-ID: <1151411992.571182.51030@75g2000cwc.googlegroups.com>

Graham wrote:
> Guys,
>
> I am trying to use SQL against an Oracle 10g database to get the
> following metrics:
>
> - SQL average response times
> - Cache hit percentage
> - Shared Segment Utilisation
>
> Ideally we could get these figures every x seconds and the metrics
> reported would be only for the period from the last retrieval to this
> one - although I am sure this can be done in an external script and the
> dates/time supplied as part of the SQL.

Look at the documentation for statspack and awr/addm/ash.

Metrics and statistics are pretty much de-emphasized as a way of solving and investigating oracle performance problems. You may want to look at Cary Millsap's book "Optimizing Oracle Performance" for current thinking.

There a book out "Oracle Database 10g Insider Solutions" that may be worth you purchasing. It has a good extended overview of 10g and several chapters that target the areas you are evidently interested in. Received on Tue Jun 27 2006 - 07:39:52 CDT