-
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
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
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 ??
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|