OS process id, v$session and v$process

Hi,

Pardon me if it's a simple question:

Environment: Oracle 8i on solaris 8

I notice a process is taking alot of CPU resources. By doing the "prstat" command at OS level, I've got its process id but would like to find out who it belongs to, from which it connects from and what action is it doing. I looked up v$process and found the process_id in "spid" column but v$process does not provide enough info. When I looked up v$session, I don't see which column is linked to v$process's column so I can join them together to find out more info.

How do people usually find the information with only OS process id is known?

Thanks,

Code:

---

SELECT s.username, s.terminal, s.program
FROM v$session s, v$process p
WHERE s.paddr = p.addr
AND s.process = your_unix_process_id

---

Even this may help too,

SELECT a.sid , a.username, s.sql_text
FROM v$session a , v$sqltext s
WHERE a.sql_address = s.address
AND a.sql_hash_value = s.hash_value
AND sid= (SPID at OS level)
ORDER BY a.username, a.sid, s.piece

Thanks

Quote:

---

Originally posted by pnrdba
...
AND sid= (SPID at OS level)
...

---

This certainly is not the correct joining condition..... SPID at OS level (the id of the process) is not the same thing as SID in V$SESSION (the id of the session).