Re: How can I create a trigger on a system view

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/06/26
Message-ID: <3957457F.71F6_at_yahoo.com>#1/1


PhilBzh wrote:
>
> I try to install a trigger on upadate of V$SESSION but I
> have an error.
> I work on Oracle8 V8.0.5.1.0
> Please Help me
>
> Philippe.
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Not a good idea...

For starters, many of of these 'tables' are not tables at all - really just a 'look' into the memory structures inside the database...

If you want to regularly scan v$session, take a look at dbms_job to run some pl/sql to scan it..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Mon Jun 26 2000 - 00:00:00 CEST

Original text of this message