Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: v$session slow?
> Hi,
>
> in our production database we would like to use an update trigger on
> an table, which accesses v$session in order to extract the information
> about the person who is currently performing this update.
>
> I thought I have read something about *not* using v$session for such
> purposes because it may be very slow.
>
> Is this correct? If yes, what other methods are there?
I wonder which information you find in v$session about "the person who is currently performing this update" that you might find useful and is not stored somewhere else.
Rene
-- Rene Nyffenegger http://www.adp-gmbh.chReceived on Wed Feb 11 2004 - 05:24:25 CST