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
![]() |
![]() |