Re: oracle Bug with JDBC ??

On Aug 20, 6:36 pm, c..._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.

Isn't v$sysstat cumulative since database startup? Received on Wed Aug 20 2008 - 23:47:00 CDT