| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_mail.ee]
Sent: Friday, July 16, 2004 10:26 AM
To: oracle-l_at_freelists.org
Subject: Re: Measuring SQL Net Traffic
Then try v$sesstat (and v$statname).
Tanel.
> 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
-- 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_at_freelists.org 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 -----------------------------------------------------------------Received on Fri Jul 16 2004 - 04:31:38 CDT
 |
 |