RE: PROCESS column in V$SESSION

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Sun, 13 Oct 2002 22:03:26 -0800
Message-ID: <F001.004E7C1B.20021013220326@fatcity.com>

Charlie,

I think Tom explained the machine column.

For process column it is:

XXXX = client PID
eg start sqlplusw on your PC, connect to a DB and run query then start Taskmanager on your PC - XXXX = PID of sqlplusw.exe

Not sure what YYYY (it's not the thread ID on the server - that is v$process.spid

        Run orakill with no parameters to see the join syntax for v$process and v$session

Regards,
Bruce Reardon

-----Original Message-----
Sent: Saturday, 12 October 2002 5:03 AM

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: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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 Mon Oct 14 2002 - 01:03:26 CDT