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>
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