DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: User session process - where is it ?

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

  2. #2
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    Try spid in v$process and join it to v$session using the addr-paddr columns.

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

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

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  6. #6
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    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
  •  


Click Here to Expand Forum to Full Width