MTS Question

From: Hussain Ahmed Qadri <hussain_at_skm.org.pk>
Date: Tue, 26 Mar 2002 00:48:24 -0800
Message-ID: <F001.00432D6F.20020326004824@fatcity.com>

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 hussain_at_skm.org.pk
www.shaukatkhanum.org.pk

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hussain Ahmed Qadri
  INET: hussain_at_skm.org.pk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 26 2002 - 02:48:24 CST