How to find no of rows

From: M.Balaji <muni_balaji_at_yahoo.com>
Date: 10 Sep 2002 03:57:38 -0700
Message-ID: <3ce48062.0209100257.6bd51173@posting.google.com>

Hi All,
 When i run a SQL statement, to find out the no of rows processed and no of times the SQL statement as executed i use the following query.

set echo off
set feedback off
set heading off
set line 100

select '-----------------------  '|| chr(10),


       'Session Id      :       ' || b.sid || ' Serial# ' || b.serial#

    || chr(10) ||


       'Username        :       ' ||

decode(b.username,NULL,'System',b.username)            || chr(10) ||


       'Rows Processed  :       ' || a.rows_processed || chr(10) ||

       'Executions      :       ' || a.executions     || chr(10) ||

       'Sql Statement   :       ' || a.sql_text        || chr(10)

from v$sql a , v$session b
where a.hash_value = b.sql_hash_value and b.status = 'ACTIVE' and (b.username is not null and b.username <> 'SYS') /

For the following SQL statement,with the above query, i canno see how many rows
processed

insert into table_a select * from table_b;

Anyone aware of how to get the no of rows processed. Please help me out.

Thanks and Regards
M.Balaji Received on Tue Sep 10 2002 - 05:57:38 CDT