Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: v$session doubt

RE: v$session doubt

From: John W Grover <grover_at_raptor.lmc.cc.mi.us>
Date: Fri, 28 Jul 2000 09:19:00 -0400
Message-Id: <10572.113232@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US