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
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 worseReceived on Mon Jun 26 2000 - 00:00:00 CEST