Re: oracle Bug with JDBC ??

From: <sybrandb_at_hccnet.nl>
Date: Sun, 24 Aug 2008 23:30:30 +0200
Message-ID: <qik3b493vr894lhijubljimksms8tgeu59@4ax.com>

On Fri, 22 Aug 2008 19:13:38 -0700 (PDT), chen_at_live.com.au wrote:

>I was using v$sysstat to grab the transmission of "Statistic value
>bytes sent via SQL*Net to client", if I do close the connection in my
>JAVA code, it won't have 3GB transmission. just about 200M as what I
>expect...
>so... is it a bug???

Look, yet again....

v$sysstat contains INSTANCE WIDE STATISTICS SINCE STARTUP. Querying it to obtain your 'own' transmission rates is WRONG.

So, why would it be a bug?
Your query to v$sysstat is IN ERROR, and you shouldn't have had access to v$sysstat at all.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Sun Aug 24 2008 - 16:30:30 CDT

This message: [ Message body ]
Next message: Shakespeare: "Re: Help for an Oracle Newbie"
Previous message: sybrandb_at_hccnet.nl: "Re: Avoid multiple scan of the same table"
In reply to: chen_at_live.com.au: "Re: oracle Bug with JDBC ??"
Next in thread: sybrandb_at_hccnet.nl: "Re: oracle Bug with JDBC ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message