Re: Insert Rate/Second

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: bruce.mccartney@xxxxxxxxxxxxxxxxx
  • Date: Wed, 24 Aug 2005 02:39:25 +0000

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


Other related posts: