Unknown sessions in v$session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Unknown sessions in v$session

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

    I queried my v$session table .
    Below is the sample output

    Please note SID 7,8,9,14 and 17

    They have no Info about the Username, The machine , the OSUSER and the program.

    What are these sessions for.

    I know that SID 1 thro 6 are background sessions.

    SID SERIAL# USERNAME STATUS OSUSER MACHINE PROGRAM
    ---------- ---------- --------------- -------- --------------- -------------------- -------------------
    1 1 ACTIVE SYSTEM THELMA ORACLE.EXE
    2 1 ACTIVE SYSTEM THELMA ORACLE.EXE
    3 1 ACTIVE SYSTEM THELMA ORACLE.EXE
    4 1 ACTIVE SYSTEM THELMA ORACLE.EXE
    5 1 ACTIVE SYSTEM THELMA ORACLE.EXE
    6 1 ACTIVE SYSTEM THELMA ORACLE.EXE
    7 3661 ACTIVE
    8 3661 ACTIVE
    9 3661 ACTIVE
    11 2036 COMPANY INACTIVE amallya HEROLD\AMALLYA-DT SQLPLUSW.EXE
    12 3 ACTIVE SYSTEM THELMA ORACLE.EXE

    SID SERIAL# USERNAME STATUS OSUSER MACHINE PROGRAM
    ---------- ---------- --------------- -------- --------------- -------------------- -------------------
    13 3 CTXSYS ACTIVE SYSTEM HEROLD\THELMA ctxsrv.exe
    14 4678 ACTIVE
    17 3704 ACTIVE
    18 714 SYS INACTIVE SYSTEM HEROLD\AMINOCHA-DT jre.exe17 3676 ACTIVE
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    They are background processes.
    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."

  3. #3
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    They must be other Oracle server processes similar to LGWR etc.. I'm not sure.

  4. #4
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Is a background process a Session in Oracle. Is it that say DBWR has 1 session, LGWR has 1 etc...

    I'm quite confused with this.

    -- What I think ??

    Oracle in order to manipulate dictionary needs its own session(s). Each session in turn will obtain RBS, TEMP, generate Redo just like a regular session all to manipulate the Data Dictionany.

    But again why more that 1 session ??

  5. #5
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by marist89
    They are background processes.
    Background processes for what?

    I dont see them on my other databases.

    Are they specific to any particular oracle version.

    Both my databases are 8.1.7 with the exception that in One the compatible parameter is 8.1 and in the other its 8.0.5

    Please advice

    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    job processes

    snpX

    if you use unix you can see it but unfortunately itīs windows

  7. #7
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    I found the serial#s are changing all the time. Are they some temporary sessions created by background processes.

  8. #8
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by pando
    job processes

    snpX

    if you use unix you can see it but unfortunately itīs windows

    Bingo!!!!!!!!!!!!!!

    I forgot that I have set up job_queue parameter to 5.

    I should have realized it myself.

    Thanks Pando


    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  9. #9
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    BUT why the serial#s are changing?

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