User session process - where is it ?

SCO Unix 7
Oracle 8.1.6

Hi friends..

I did a sar and have a lot of resource consumed in usr%

I then did a ps -ef and found some processes which belonged to oracle sessions where a lot of processing resource was consumed. I took a note of the pid (1234).

From Sqlplus i issued :

select username, osuser, sid, serial#
from v$session
where process like '%1234%';

I got 'no rows selected'

Does anyone know where this session is ?

It is not background process I know it is a user session as it has a CMD of 'sid (LOCAL= NO)'.

can anyone tell me what/where this process is ?

Thanks

Suresh

Try spid in v$process and join it to v$session using the addr-paddr columns.

you should check for spid in v$process, I bet the pid you looked at is the server process not the user process. v$session show user process but not the server process which can be queried in v$process

Hi Folks.. Thaks for your replies.
Select * from v$process shows the following info :


ADDR PID SPID USERNAME SERIAL# TERMINAL
-------- ---------- --------- --------------- ------- ----------
PROGRAM B LATCHWAI LATCHSPI
------------------------------------------------ - -------- --------
32D07AF8 11 22742 oracle 5 syscon
oracle@amlux72 (TNS V1-V3)


There are about 5 of these processes..

do you know what they are ??

ADDR -
Address of process state object

PID -
Oracle process identifier

SPID -
Operating system process identifier

USERNAME -
Operating system process username. Any Two-Task user coming across the network has "-T" appended to the username.

SERIAL# -
Process serial number

TERMINAL -
Operating system terminal identifier

PROGRAM -
Program in progress

BACKGROUND -
1 for a background process; NULL for a normal process

LATCHWAIT -
Address of latch the process is waiting for; NULL if none

LATCHSPIN -
Address of latch the process is being spun on; NULL if none


Hope this would help you to undestand.

Sam

You should be able to link to v$session using a query of the following sort:

select s.sid,s.program,s.username,s.process
from v$session s, v$process p
where p.addr = s.paddr
and p.spid = 'xxx'