Re: Measuring a session's performance

On 2 Dec 1997 17:55:32 GMT, "Nabil Courdy" <moab_at_emirates.net.ae> wrote:

>I want to be able to collect the following stats for the
>duration of an Oracle session:
>
> Elapsed time
> No. of Physical IO reads and writes
> No. of Logical IO reads and writes
> SGA hit/miss ratio
> CPU consumption
>
>What is the universal way to fetch this info. I know I can
>look into the v$filestat and the utlbstat and utlestat to arrive
>at an abundance of performance data. However, I am after
>a straight forward solution since I am benchmarking Oracle
>under different variables and I do not want to run these
>utilities at the end of each sample run.
>
>Thank you.
>
>Nabil
>moab_at_emirates.net.ae
>=================
>

alter session set sql_trace = true timed_statistics = true;

This'll generate a trace file for your session with statistics for every command you do as well as overall statistics for the session. When you disconnect, you can use tkprof to analyze the trace file.

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!