Re: Measuring a session's performance

From: Paul Osborn <posborn_at_menlosoftware.com>
Date: 1997/12/03
Message-ID: <348536D9.9D4BD10C@menlosoftware.com>#1/1

This is a multi-part message in MIME format.

--------------42127FDA2BABF38427448673
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Nabil Courdy 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

I have some queries on my web page - http://www.menlosoftware.com - that will return the above stats. Alter them to insert a row into a temp table, put them into a procedure, and call the procedure whenever you need to gather the data.

Regards,
Paul

>
>
> 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
> =================

--------------42127FDA2BABF38427448673
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Paul Osborn
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Paul Osborn
n:              Osborn;Paul
org:            Menlo Software
adr:            744 College Avenue;;;Menlo Park;CA;94025-5204;US
email;internet: posborn_at_menlosoftware.com
title:          Founder
tel;work:       650.324.1286
tel;fax:        650.324.1287

x-mozilla-cpt: ;0
x-mozilla-html: FALSE

version:        2.1
end:            vcard

--------------42127FDA2BABF38427448673-- Received on Wed Dec 03 1997 - 00:00:00 CST