Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: v$session slow?

Re: v$session slow?

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 11 Feb 2004 11:24:25 GMT
Message-ID: <c0d3d9$159asc$1@ID-82536.news.uni-berlin.de>

> 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.ch
Received on Wed Feb 11 2004 - 05:24:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US