By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

process serial number: serial# in v$process

P: n/a
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.
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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 --
Jul 19 '05 #2

P: n/a
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.
Jul 19 '05 #3

P: n/a
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 --
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.