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: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Wed, 11 Feb 2004 17:53:37 GMT
Message-ID: <B_tWb.33560$964.29952@edtnps84>


Alex Schonlinner wrote:
  > The information we would like to use is osuser, machine and program from
> v$session, so our system can recognize who (i.e. what interface or human
> being) made the update.
>
> But as I said above, I'm personally anxious about retrieving that information
> from v$session.
> But I'm not sure why...it's only a feeling not to use such views for such
> jobs...
>
> But perhaps others have a much better experience with Oracle...
>
> Regards,
> Alex

check out sys_context, may be what you're after http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/function.htm#88703 Received on Wed Feb 11 2004 - 11:53:37 CST

Original text of this message

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