RE: Insert Rate/Second

For sure. Depends what you are trying to measure and why. I suppose for performance/capacity metrics, including the rollbacks might be best. Wouldn't want to rely on dba_tab_modification to give an exact record count.

Bruce McCartney
bruce.mccartney_at_dbinfosystems.com  

>
>
> Of course, one must be sure not do any rollbacks, because, as
> Niall has so masterfully proven to me, even transactions that
> rolled back are recorded in SYS.MON_MODS$.
> --
> Mladen Gogala
> http://www.mgogala.com
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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