Re: process serial number: serial# in v$process

niy38_at_hotmail.com (Niy) wrote in message news:<55dd405a.0402231424.23947fdc_at_posting.google.com>...
> Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0402230708.7276d661_at_posting.google.com>...
> > niy38_at_hotmail.com (Niy) wrote in message news:<55dd405a.0402212138.29530501_at_posting.google.com>...
> > > what does that mean? what for? I searched a lot but
> > > failed to find explanation.
> > >
> > > Sometimes I really have difficulty finding documentation
> > > for some views.
> >
> > Niy, all the v$ views are documented in the Oracle version# Reference
> > Manaual.
> >
> > PID NUMBER Oracle process identifier
> > SPID VARCHAR2(12) Operating system process identifier
> >
> > Serial# is in v$session. It is an Oracle generated value used in
> > combination with the SID to create a unique session identifier.
> >
> > HTH -- Mark D Powell --
>
> Thanks for the reply, Mark.
>
> Just as you said, serial# in v$session is used to identify unique
> session combined with sid, but is this serial# in v$session same
> meaning as serial# in process?
>
> From the reference 9.2, serial# in v$process is:
> Process serial number
>
> That's equal to say: this boy is his dad's son.
> Unfortunately many documentation for views is just like this.

 1 select s.sid, s.serial# "Session", p.serial# "Process"  2 from v$session s, v$process p
 3 where s.paddr = p.addr
 4* and s.username = 'MPOWEL01'
SQL> /        SID Session Process
---------- ---------- ----------

        18 8219 68

No, they are not the same. The first is the session serial no and the second is the process serial no and othewise the two column have nothing to do with each other.

HTH -- Mark D Powell -- Received on Wed Feb 25 2004 - 16:27:19 CET