Re: oracle Bug with JDBC ??

From: <sybrandb_at_hccnet.nl>
Date: Thu, 21 Aug 2008 11:42:24 +0200
Message-ID: <p0eqa4tvvds2lq3frg7qut9iq5aoue8t9a@4ax.com>


On Wed, 20 Aug 2008 18:36:32 -0700 (PDT), chen_at_live.com.au wrote:

>Hi all, I'm currently doing some research on Oracle 10g server in our
>university (Uni of Wollongong,Australia).
>Well, I have a Java file which connects to the database and create and
>select some tables but doesn't close connection with the codes. and
>then I try to "select value from v$sysstat where name='bytes sent via
>SQL*Net to client' under sqlplus via the same user as the java file
>connect with, after I ran the java file. and the results is amazing!!
>------------------------------------
>Statistic value bytes sent via SQL*Net to client
> 3,545,613,496(bytes)
>
>---------------------------------
>I've got over 3 GB transmission data in 20 secs!!
>I've found out the problem is because I didn't close the connection in
>my JAVA file, but 3 GB transmission data is just impossible with some
>little select statements in the java file...
>
>anyone knows how can this transmission happens?
>or it is a bug from Oracle??
>
>
>Wenzheng.

v$sysstat is a global, database wide, statistic. It is cumulative since startup.
Apart from that it scares me you have access to v$sysstat from Java.

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Aug 21 2008 - 04:42:24 CDT

Original text of this message