RE: Measuring SQL Net Traffic
- From: Feighery Raymond <Raymond.Feighery@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Jul 2004 10:34:57 +0100
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
