statistiques net8

From: <y.abiad_at_waika9.com>
Date: Fri, 6 Apr 2001 23:23:42 +0200
Message-ID: <9albv8$s6r$1@fenris.isp.9tel.net>

Hello,
I need to tune an application to know what excatly bytes its sql*net send and receive,
and determine what is the heavy request (request who fetch and send a lot of data)
I know that V$SYSSTAT can help, but
The pb is i dont have the dba privileges on the server, only CONNECT and RESOURCE. Is the request OK to have a net trafic ?

sql> set autotrace on
sql> select num_rows*avg_row_len from user_tables ;
sql> analyse table emp delete statistics ;
sql> analyse table emp estimate statistics ;
sql> select num_rows*avg_row_len from user_tables ;

I also tried this :
sql> alter session set sql_trace=true ;
sql> @batch_sql
$ tkprof *.trc res
I didnt seen sql*net traces...

yhab.abiad-sica_at_renault.com Received on Fri Apr 06 2001 - 16:23:42 CDT