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: What's my session's pid?

Re: What's my session's pid?

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Wed, 17 Aug 2005 14:05:30 -0400
Message-ID: <11g6v3rmdmvqncb@corp.supernews.com>


"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> a écrit dans le message de news:Xns96B54F1EA17FASunnySD_at_68.6.19.6...
> "Syltrem" <syltremzulu_at_videotron.ca> wrote in
> news:11g6id6ji4e3f3_at_corp.supernews.com:
>
> > select sid from v$mystat where rownum=1;
> > is shorter...
> >
>
> except that returns the SID not the PID
> SID<>PID

Oops. I should have read more carefully.

-- 
Syltrem

http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
Received on Wed Aug 17 2005 - 13:05:30 CDT

Original text of this message

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