Re: Insert Rate/Second

On 08/23/2005 09:28:49 PM, Bruce McCartney wrote:
> Hi Mohammed,
>
> If you want an accurate reading by table you can use dba_tab_modifications;
> something like this, I used SYSTEM so had to grant access:
>
> grant all on SYS.DBA_TAB_MODIFICATIONS to system with grant option;
>

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