process serial number: serial# in v$process

[Niy]

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.

[Mark D Powell]

ni***@hotmail.com (Niy) wrote in message news:<55**************************@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 --

[Niy]

Ma*********@eds.com (Mark D Powell) wrote in message news:<26**************************@posting.google. com>...

ni***@hotmail.com (Niy) wrote in message news:<55**************************@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.

[Mark D Powell]

ni***@hotmail.com (Niy) wrote in message news:<55**************************@posting.google. com>...

Ma*********@eds.com (Mark D Powell) wrote in message news:<26**************************@posting.google. com>...

ni***@hotmail.com (Niy) wrote in message news:<55**************************@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 --