Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> "bytes sent via SQL*Net to client" decreases
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