MTS configuration, 8.1.7, NT4
Is there anything wrong when we have a negative value, exponential in nature(e.g. -1.838E+09), in the BYTES column of
V$SHARED_SERVER. The bytes column shows the total number of bytes in all messages that have been processed by a particular server.
Just to give an idea, given below is an example row
NAME STATUS MESSAGES BYTES
---- ---------------- ---------- ----------
S001 EXEC 6903137 -1.838E+09
The value of status column is switching between Exec(meaning this server is executing a SQL) or WAIT (common)(meaning its idle)... Does any of this help in explaining the effect of -ve value.
Regards,
Hussain Ahmed Qadri
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
[EMAIL PROTECTED]
www.shaukatkhanum.org.pk
