RE: Measuring SQL Net Traffic

A web or application server may have thousands of sessions over the =
course
of the day connecting to the database. I am hoping to be able to use a
single point from which I can gather information such as no. of =
connections
made and total no. of bytes received and sent.

Now v$sesstat has session related information which is updated to =
v$sysstat
at session termination. I suppose if I could manufacture some sort of
pre-logoff trigger which captures this information based on machine =
from
v$session (to restrict connections from other sources), but as all the
connections are going through a single SQL Net Listener, isn't there =
some
easier method of information gathering here.

Or did you mean something else?

Ray

-----Original Message-----
From: Tanel P=F5der [mailto:tanel.poder.003@xxxxxxx]
Sent: Friday, July 16, 2004 10:26 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Measuring SQL Net Traffic


Then try v$sesstat (and v$statname).

Tanel.

----- Original Message -----=20
From: "Feighery Raymond" <Raymond.Feighery@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, July 16, 2004 12:18 PM
Subject: RE: Measuring SQL Net Traffic


> I thought about this, but if I understand correctly, V$SYSSTAT =
records
> statistics on an instance basis. I require to be able to restrict =
this to
> traffic from a specific source over a specific time.
>=20

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

________________________________________________________________________=
___=20


This email and any attached to it are confidential and intended only =
for the
individual or entity to which it is addressed.  If you are not the =
intended
recipient, please let us know by telephoning or emailing the sender.  =
You
should also delete the email and any attachment from your systems and =
should
not copy the email or any attachment or disclose their content to any =
other
person or entity.  The views expressed here are not necessarily those =
of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank =
you.=20

Churchill Insurance Group plc.  Company Registration Number - 2280426.
England.=20

Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent =
BR1
1DP.=20


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: