RE: wield session and process number???
Date: Fri, 21 Aug 2009 10:44:52 -0700 (PDT)
Message-ID: <243602.33464.qm_at_web65710.mail.ac4.yahoo.com>
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
> a.paddr=b.addr;
>
> Regards,
> Brandon
>
>
>
> 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.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 21 2009 - 12:44:52 CDT