-
Process COlumn value in V$session
I have followed the below steps:
1)From sqlplus on my PC I connect to a remote database(On a Unix Box) using Host String(this creates an session on database)
2)I queried v$session like this and output given here
select sid,serial#,username,osuser,process,status from v$session;
SID SERIAL# USERNAME OSUSER PROCESS STATUS
---- --- -------------- ---------- --------- --------
1 1 oracle 18814 ACTIVE
2 1 oracle 18833 ACTIVE
3 1 oracle 18848 ACTIVE
4 1 oracle 18857 ACTIVE
5 1 oracle 18884 ACTIVE
6 1 oracle 18902 ACTIVE
7 3 SYS oracle 20055 ACTIVE
8 4 SYS Bandith 2244:1632 INACTIVE
MY QN. IS when I grep for the process id 2244:1632 at $prompt it is not displaying this process id. Can Someboxy explain why. Whereas
other processes r shown when I use ps -ef |grep
what does the ":" indicate in the process column value
-
process in v$session means client process ID
processes which look like 2244:1632 means it´s Windows client
if you want to see your server process PID you have to query v$process
-
For more column values in the v$process, check out...
http://download-west.oracle.com/docs...h3136.htm#9225
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
How to get hostpid:
SELECT P.SPID, P.PID, S.SID, S.SERIAL#, S.OSUSER
FROM V$PROCESS P, V$SESSION S
WHERE S.PADDR = P.ADDR
ORDER BY S.OSUSER
/
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
V4process
Thank u Suresh for the Information. I had the doubt as I was joining on wrong columns i.e. serial#.
Thanks once again to all of you who answered my qn.
Tharaka
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
|