RE: PROCESS column in V$SESSION

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 11 Oct 2002 10:02:47 -0800
Message-ID: <F001.004E704C.20021011100247@fatcity.com>

Charlie,

XXXX = NT Domain
YYYY = Machine Name

Hope this helps.

PS - do I get a Home Depot Discount Card for this? :)

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
[mailto:Charlie_Mengler_at_HomeDepot.com]
Sent: Friday, October 11, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L

For folks connecting to the DB server from another Unix box the PROCESS field is the Process ID on the host named in the MACHINE field. For folks connecting to the DB server from a PC the values are in the form of XXXX:YYYY

So what do XXXX & YYYY signify?

WENDYC                                   wendyc          1112:1116
HDSWIN\CSCSOPC034
WENDYC                                   wendyc          1172:1140
HDSWIN\CSCSOPC034
MWH                                           williamd        22968     pan
MWH                                           williamd        26653     pan
OPS$WILLIAMD                      williamd        26974     titan
OPS$WKLINE                           wkline          22717     titan
OPS$WSPENCER                  wspencer        24664     titan
OPS$WSPENCER                  wspencer        4824      titan
YSULLIVA                                   ysulliva        728:300
HDSWIN\CSCCSPC105
YSULLIVA                                   ysulliva        1104:1076

HDSWIN\CSCCSPC105
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Charlie_Mengler_at_HomeDepot.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 11 2002 - 13:02:47 CDT