<div>
This was identified as a bug and fixed in 8.1.7, what version are you on ?<br />
<br />
Basically the reason given was if the database stays up for too long this number becomes large enough to wrap around and show up as a negative number. This was also related to using parallel query if parallel_max_servers was set &gt;&nbsp;0.<br />

</div>


This was identified as a bug and fixed in 8.1.7, what version are you on ?

Basically the reason given was if the database stays up for too long this number becomes large enough to wrap around and show up as a negative number. This was also related to using parallel query if parallel_max_servers was set > 0.


<div>
My version is 8.1.6.<br />
<br />
Another question about this is if this negative number is a real value. That is, if the real value is the shown number, but positive, not negative. Or the shown value is a wrong value?<br />
I don´t know.<br />
<br />
Thanks in advance, again.
</div>


My version is 8.1.6.

Another question about this is if this negative number is a real value. That is, if the real value is the shown number, but positive, not negative. Or the shown value is a wrong value?
I don´t know.

Thanks in advance, again.

<div>
<div class="content wysiwyg-content">
Hello, I do a query about bytes send/received via SQL*NET by an user, and the result is like this:<br />
<br />
NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUE &nbsp; &nbsp; <br />
--------------------------<wbr />----------<wbr />----------<wbr />-------- ----------<br />
bytes sent via SQL*Net to client &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-1,357E09<br />
<br />
VAULE is NUMBER in the view V$SESSTAT,<br />
<br />
I do not understand why VALUE is negative, is a format question ?? I don´t know.<br />
<br />
Thanks in advance.<br />

</div>
</div>


Hello, I do a query about bytes send/received via SQL*NET by an user, and the result is like this:

NAME                                                             VALUE     
------------------------------------------------------ ----------
bytes sent via SQL*Net to client                        -1,357E09

VAULE is NUMBER in the view V$SESSTAT,

I do not understand why VALUE is negative, is a format question ?? I don´t know.

Thanks in advance.


Negative Number ??

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.