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 -> v$session slow?

v$session slow?

From: Alex Schonlinner <schonlinner_at_yahoo.com>
Date: 11 Feb 2004 00:58:35 -0800
Message-ID: <56fd2574.0402110058.2d8b8254@posting.google.com>


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?

Regards,
  Alex Received on Wed Feb 11 2004 - 02:58:35 CST

Original text of this message

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