Unknown sessions in v$session

Printable View

06-05-2002, 01:33 PM
ronnie

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
06-05-2002, 01:49 PM
marist89

They are background processes.
06-05-2002, 01:52 PM
dba1

They must be other Oracle server processes similar to LGWR etc.. I'm not sure.
06-05-2002, 01:56 PM
patnams

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 ??
06-05-2002, 01:59 PM
ronnie

Quote:

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
06-05-2002, 02:02 PM
pando

job processes

snpX

if you use unix you can see it but unfortunately it´s windows
06-05-2002, 02:16 PM
dba1

I found the serial#s are changing all the time. Are they some temporary sessions created by background processes.
06-05-2002, 03:10 PM
ronnie

Quote:

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
06-06-2002, 08:51 AM
dba1

BUT why the serial#s are changing?