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