Re: Measuring a session's performance

You might look at AUDIT SESSION (audit_trail=DB in init.ora). Then query dba_audit_session. This doesn't give you exactly what you asked for,
but I've found it very useful as a cheap starting point for investigating batch costs
or relative benchmark costs.

Nabil Courdy <moab_at_emirates.net.ae> wrote in article <01bcff08$ecf2fd20$afa7aac2_at_msdusr>...
> 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.
Received on Wed Dec 03 1997 - 00:00:00 CST