Re: Unknown sessions

From: Ronnie <ronnie_yours_at_yahoo.com>
Date: 23 Apr 2003 14:50:11 -0700
Message-ID: <ea603f8d.0304231350.cf09181@posting.google.com>

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.sid's 1 through 9 are 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. Received on Wed Apr 23 2003 - 16:50:11 CDT