RE: wield session and process number???
Date: Fri, 21 Aug 2009 10:44:52 -0700 (PDT)
Thank you. I run SQL script you provide and it still show 33 not 99.
- On Fri, 8/21/09, Allen, Brandon <Brandon.Allen_at_OneNeck.com> wrote:
> From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
> Subject: RE: wield session and process number???
> To: "mccdba1_at_yahoo.com" <mccdba1_at_yahoo.com>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Date: Friday, August 21, 2009, 1:39 PM
> Just join them to see what's going on
> - something like this should give you some insight:
> Select a.sid, a.serial#, a.username, a.osuser, a.program,
> b.username, b.spid from v$session a, v$process b where
> Privileged/Confidential Information may be contained in
> this message or attachments hereto. Please advise
> immediately if you or your employer do not consent to
> Internet email for messages of this kind. Opinions,
> conclusions and other information in this message that do
> not relate to the official business of this company shall be
> understood as neither given nor endorsed by it.