Re: Measuring a session's performance

From: Dmitriy Evinshteyn <Dmitriy.Evinshteyn_at_lgtna.com>
Date: 1997/12/02
Message-ID: <01bcff77$9ecb5c90$b40174c6@dmitriye>#1/1

Look into v$sesstat and v$statname performance views

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.
>
> Thank you.
>
> Nabil
> moab_at_emirates.net.ae
> =================
>
>
Received on Tue Dec 02 1997 - 00:00:00 CST