Re: v$session slow?

From: <sybrandb_at_yahoo.com>
Date: 11 Feb 2004 07:13:16 -0800
Message-ID: <a1d154f4.0402110713.251705b9@posting.google.com>

schonlinner_at_yahoo.com (Alex Schonlinner) wrote in message news:<56fd2574.0402110058.2d8b8254_at_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

You don't need v$session, you can use the user pseudo function.

Sybrand Bakker
Senior Oracle DBA Received on Wed Feb 11 2004 - 09:13:16 CST