-
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.
-
They are background processes.
Jeff Hunter
-
They must be other Oracle server processes similar to LGWR etc.. I'm not sure.
-
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 ??
-
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.
-
job processes
snpX
if you use unix you can see it but unfortunately it´s windows
-
I found the serial#s are changing all the time. Are they some temporary sessions created by background processes.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|