Re: Insert Rate/Second

This is good for one time inserts. It becomes less accurate once the query gets into the shared pool, but you can still use it as a base. select substr(sql_text,14,instr(sql_text,'(')-16) table_name,rows_processed,

round((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60,1) minutes,

trunc(rows_processed/((sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss'))*24*60)) rows_per_min

from v$sqlarea where sql_text like 'INSERT%'

and command_type = 2 and open_versions > 0

• Original Message ----- From: "mkb" <mkb125_at_yahoo.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, August 23, 2005 11:56 AM Subject: Insert Rate/Second

> Assuming I don't have access to statspack, can I
> figure out the rate of inserts into the database?
>
> This is on a 9.2.0.6 db running RH AS 3.0. Third
> party app issuing JDBC calls to db.
>
> The approach I took is to look at v$sql. The query
> that I'm running is:
>
> select executions, elapsed_time,
> elapsed_time/1000000
> from v$sql
> where sql_text like '<insert statement I'm interested
> in>'
>
> Would this give me a snapshot of the rate at which
> inserts occur for the given statement?

--
http://www.freelists.org/webpage/oracle-l