Re: measuring the network traffic

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Tue, 11 Dec 2001 14:58:06 -0500
Message-ID: <9v5oe1$d4au5$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"Sybrand Bakker" <oradba_at_sybrandb.demon.nl> wrote in message news:k7oc1u46nu1h8dnp6nf86aq38iemov5be7_at_4ax.com...
> On Mon, 10 Dec 2001 16:36:50 +0100, "alainc" <alain2208_at_lycos.fr>
> wrote:
>
> >hi all,
> >is it possible on 8.0 on nt to find the byte send and receive by a
specific
> >session on the networks
> >
> >Thanks
> >
> >Alain
> >
>
>
> The best thing to do is to find an nt equivalent of the Unix/AIX
> iptrace command.
> Other than that you will need to make sure sqlnet.ora
> trace_level_client is set to 16 and run otrcfmt on the output.
> I've never tried that, if you want me to I can give it a shot, but
> I don't promise I will do it immediately (probably I will delay it
> to the weekend)

Why not just query v$sesstat? Something like this should work (statistcs 155
and 156 are SQLNET stats in 8.0)

SELECT s.sid, n.name, s.value
FROM v$sesstat s, v$statname n

 WHERE s.statistic# = n.statistic#  and
       s.statistic# in (155,156) and
       s.sid = &sid_num

Note: If you're trying to get stats for your own session, change v$sesstat
to v$mystat and remove the "s.sid =" filter from the WHERE clause.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPBZlS2m5A4kkb4ZsEQLgRwCgjdqOer114fSV1MPT2Gd9EHHp5JQAoLDR BpSrDzDy0LpeUQVKiXJx7voy
=mFpd
-----END PGP SIGNATURE----- Received on Tue Dec 11 2001 - 13:58:06 CST