Thursday, 28 April 2011

No . of Insertions in the Database


 select substr(sql_text,instr(sql_text,'INTO "PRO'),50) Inserts,
         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   sys.v_$sqlarea
  where  upper(sql_text) like 'INSERT %' and sql_text like '%SL%';

No comments:

Post a Comment