Re: Can I measure average response times from command line (or SQL)

Graham wrote:
> Guys,
>
> I would like to run a command/SQL every say 10 seconds and get the
> average repsonse times of all SQLs issued against the Oracle database
> in the last 10 seconds.
>
> I can manipulate dates, etc. - but is there an interface or table or
> view that will give me this information?
>
> TIA
>
> Graham

What version of Oracle?

For what purpose? Ten seconds is a very short period of time. On a larger system it might take more than 10 seconds just to scan the shared pool to see how many SQL statements are currently executing.

Take a look at the information provided by the statspack report.

Individual sessions of interest can be traced. The raw trace file can be feed to tkprof or a profiler for analysis as well as read directly though this last activity takes practice.

With version 10g Oracle automatically makes a record of the heavy hitters and provides access to the current and historic information. But access to some of the views involved with the AWR require purchase of the Performance Pack license along with a database license.

HTH -- Mark D Powell -- Received on Sun Jan 21 2007 - 16:09:25 CST