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

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. Received on Mon Feb 23 2004 - 23:24:08 CET