Re: v$session slow?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 11 Feb 2004 10:04:01 +0100
Message-ID: <4029ef7b$0$28142$626a14ce@news.free.fr>

"Alex Schonlinner" <schonlinner_at_yahoo.com> a écrit dans le message de 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

What is your Oracle version?
Which information do you need to get?

Regards
Michel Cadot Received on Wed Feb 11 2004 - 03:04:01 CST