| big doubt [message #60426] |
Fri, 06 February 2004 18:08  |
vadlamani
Messages: 39
Registered: November 2003
|
Member |
|
|
when i give the SELECT SID USER#,USERNAME,SCHEMANAME,PROCESS,TERMINAL,PROGRAM,TYPE FROM V$SESSION ;
i got this out put, i can understand there are 6 background process & one sys process by which i got connected,but what are the other two user process.can any ontellme what are why they are 3 user process( one is SYS )
# USERNAME SCHEM PROCESS TERMINAL PROGRAM TYPE
------ ---------- ----- ------------ ---------------- --------------- ----------
1 SYS 2256 BA140-012 ORACLE.EXE BACKGROUND
2 SYS 240 BA140-012 ORACLE.EXE BACKGROUND
3 SYS 2280 BA140-012 ORACLE.EXE BACKGROUND
4 SYS 356 BA140-012 ORACLE.EXE BACKGROUND
5 SYS 216 BA140-012 ORACLE.EXE BACKGROUND
6 SYS 4020 BA140-012 ORACLE.EXE BACKGROUND
7 SYS 4036 BA140-012 ORACLE.EXE USER
8 SYS 396 BA140-012 ORACLE.EXE USER
9 SYS SYS 3692:3860 BA140-012 sqlplusw.exe USER
9 rows selected.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
