| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: v$session doubt
Include the PROGRAM column to see that the first 6 entries are the db
processes' sessions...
09:14:37 SQL> select SID, SERIAL#, STATUS, PROGRAM from v$session;
SID SERIAL# STATUS PROGRAM
---------- ---------- -------- ---------------------------------------------
---
1 1 ACTIVE oracle_at_yogi (PMON)
2 1 ACTIVE oracle_at_yogi (DBWR)
3 1 ACTIVE oracle_at_yogi (ARCH)
4 1 ACTIVE oracle_at_yogi (LGWR)
5 1 ACTIVE oracle_at_yogi (CKPT)
6 1 ACTIVE oracle_at_yogi (SMON)
8 9 INACTIVE runform45_at_yogi (TNS interface)
10 4 ACTIVE ? @yogi (TNS V1-V2)
11 27 INACTIVE runform45_at_yogi (TNS interface)
12 14 INACTIVE runform45_at_yogi (TNS interface)
13 11 INACTIVE runform45_at_yogi (TNS interface)
14 43 INACTIVE F45RUN32.EXE
17 4 ACTIVE sqlplus_at_yogi (TNS V1-V2)
13 rows selected.
Elapsed: 00:00:00.04
John W Grover Lake Michigan College
http://www.lmc.cc.mi.us/~grover
<<Press any key to continue, press any other key to quit>>
Received on Fri Jul 28 2000 - 08:19:00 CDT
![]() |
![]() |