Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> "bytes sent via SQL*Net to client" decreases

"bytes sent via SQL*Net to client" decreases

From: Matthias Rogel <rogel_at_web.de>
Date: Wed, 24 Nov 2004 14:32:51 +0100
Message-ID: <30jgs4F31fcraU1@uni-berlin.de>


Hallo

I want to monitor
"bytes sent via SQL*Net to client"

on my database

so I created a table
t(
snap date,
"bytes sent" number)

and a job which runs every minute and does an insert into t
select sysdate, value
from v$sysstat
where name='bytes sent via SQL*Net to client'

runs well - but now I noticed from time to time that
"bytes sent" decreased !!

Is it a bug or a feature ?
(9.2.0.5)

For example, I had this morning

snap 		24.11.2004 10:15:02   (dd.mm.yyyy HH24:MI:SS)

"bytes sent" 476660504533
snap 24.11.2004 10:16:04
"bytes sent" 473680754223,

How to interprete this ?

Does it mean , between 10:15:02 and 10:16:04 this morning, there were

473680754223 - 476660504533 = - 2979750310 (note: result is negative)

Bytes sent via SQL*Net to clients ?

Matthias Received on Wed Nov 24 2004 - 07:32:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US