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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Feb 2004 07:08:45 -0800
Message-ID: <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 -- Received on Mon Feb 23 2004 - 16:08:45 CET

This message: [ Message body ]
Next message: kibeha: "Re: Need help on a query with analytics"
Previous message: D: "Can I concatenate varchar2 and long datatypes together?"
In reply to: Niy: "process serial number: serial# in v$process"
In reply to Niy: "process serial number: serial# in v$process"
Next in thread: Niy: "Re: process serial number: serial# in v$process"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message