Unknown Active sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Unknown Active sessions

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Unknown Active sessions

    HI,

    Constantly I see many unknown sessions on my DBA studio which do not have a username,osuser,machine name and programs associated with them.

    But they do have a session Id, Status and os process Id fields populated and the status is always active.

    What are these sessions. I have killed them in the past without any issues but they keep popping up.

    ANy Ideas what these are.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Weird, does the application server have any upload/download processes that run on the fly? I have something similar but it does not show as "unknown". Could be a front end process?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you know the client pid, why not just go to that machine and look it up?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Could it be that you are looking at instance background processes (SMON, PMON, DBWR, LGWR, ....)? They perfectly match your description...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    QUOTE]Originally posted by jmodic
    Could it be that you are looking at instance background processes (SMON, PMON, DBWR, LGWR, ....)? They perfectly match your description... [/QUOTE]

    Not in version 9.2, they are clearly identified as

    OSUSER= Oracle
    STATUS = Active
    PROGRAM = Oracle@box_name(CHKPT, DBWO, PMON....Ect...)

    Is this dependant on configuration?
    Even my 8.1.6 box identifies it as an Oracle process.

    MH
    I remember when this place was cool.

  6. #6
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    This is the output of the query on v$session.

    Please note sid 29,36 and 42 have no info on them and are also not background processes.

    1 select SID,SERIAL#,substr(USERNAME,1,10)username,COMMAND,STATUS,SERVER,substr(SCHEMANAME,1,10)SCHAMENAME,
    2* SUBSTR(OSUSER,1,10)OSUSER,PROCESS,substr(MACHINE,1,20),TERMINAL,SUBSTR(program,1,20)PROGRAM from v$session
    SID SERIAL# USERNAME COMMAND STATUS SERVER SCHAMENAME OSUSER PROCESS SUBSTR(MACHINE,1,20) TERMINAL PROGRAM
    --------------- --------------- ---------- --------------- -------- --------- ---------- ---------- --------- -------------------- ---------------- --------------------
    1 1 0 ACTIVE DEDICATED SYS shirley 1876 THELMA THELMA ORACLE.EXE
    2 1 0 ACTIVE DEDICATED SYS shirley 1448 THELMA THELMA ORACLE.EXE
    3 1 0 ACTIVE DEDICATED SYS shirley 1504 THELMA THELMA ORACLE.EXE
    4 1 0 ACTIVE DEDICATED SYS shirley 1468 THELMA THELMA ORACLE.EXE
    5 1 0 ACTIVE DEDICATED SYS shirley 1484 THELMA THELMA ORACLE.EXE
    6 1 0 ACTIVE DEDICATED SYS shirley 1916 THELMA THELMA ORACLE.EXE
    11 15824 0 ACTIVE DEDICATED SYS
    12 1 0 ACTIVE DEDICATED SYS shirley 1380 THELMA THELMA ORACLE.EXE
    13 3 CTXSYS 0 ACTIVE DEDICATED CTXSYS shirley 1512:2092 HEROLD\THELMA THELMA ctxsrv.exe
    19 2766 SYS 3 ACTIVE DEDICATED SYS aminocha 2340:2108 HEROLD\AMINOCHA-DT AMINOCHA-DT SQLPLUSW.EXE
    21 23681 0 ACTIVE DEDICATED SYS
    22 5397 HFOD 0 KILLED PSEUDO HFOD shirley 1516:1220 HEROLD\THELMA THELMA sqlplus.exe
    25 1408 SYS 0 INACTIVE DEDICATED AMINOCHA aminocha 2244:2260 HEROLD\AMINOCHA-DT AMINOCHA-DT jrew.exe
    27 27548 0 ACTIVE DEDICATED SYS shirley 2348 THELMA THELMA ORACLE.EXE
    29 33277 0 ACTIVE DEDICATED SYS
    36 7755 0 ACTIVE DEDICATED SYS
    37 529 COMPANY 0 INACTIVE DEDICATED COMPANY aminocha 1716:2180 HEROLD\AMINOCHA-DT AMINOCHA-DT SQLPLUSW.EXE
    42 2677 0 ACTIVE DEDICATED SYS

    18 rows selected.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Those are probably Oracle's SNP job queue background processes. You can verify this by querying V$BGPROCESS, using SADDR of those "strange" sessions from V$SESSION as ADDR for V$BGPROCESS.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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