Average response times, cache hits, etc.

From: Graham <graham.parsons_at_reflective.com>
Date: 27 Jun 2006 03:16:07 -0700
Message-ID: <1151403367.504653.139760@x69g2000cwx.googlegroups.com>

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.

I know I will be using V$ tables but there seems so many and its pretty confusing to someone who doesn't know Oracle that well; and 10g even less.

If anyone could supply the SQL or point me at the right tables and columns I'd appreciate it a lot.

TIA Graham Received on Tue Jun 27 2006 - 05:16:07 CDT