Process COlumn value in V$session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Process COlumn value in V$session

  1. #1
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  3. #3
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- Everything was meant to be---

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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.

  5. #5
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    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
  •  



Click Here to Expand Forum to Full Width