Re: Monitoring a table

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 17 Oct 2000 18:12:18 +0800
Message-ID: <39EC2601.7B29_at_yahoo.com>


corrado brambilla wrote:
>
> Hi folk
>
> I need to know the way to monitoring a table during normal operation
> (insert, delete ecc..).
>
> Thanks
>
> Ciao Corrado.

Take a look at 'alter table ... monitoring' clause...

You'll get a reasonably accurate (but not exact) count of what mods have been done look at user_tab_modifications

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me... 
  its the voices in yours.
Received on Tue Oct 17 2000 - 12:12:18 CEST

Original text of this message