RE: V$session doubt

From: Jeroen van Iddekinge <IddekingeJ_at_vertis.nl>
Date: Thu, 27 Jul 2000 12:23:26 +0200
Message-Id: <10571.113101@fatcity.com>

 

Hi,  

These 6 process are background processes (like ARCH,PMON,SNP? etc..)  

The following query gives more information :  

select s.sid,p.*
from v$session s,v$bgprocess p
where s.paddr = p.paddr    

Grz..  

    Jer.  

-----Original Message-----

From: Uma Sankara_Sivadanam [mailto:UmaSankara_Sivadanam_at_satyam.com] Sent: Thursday, July 27, 2000 10:49 AM
To: Multiple recipients of list ORACLE-L Subject: V$session doubt

Hi,
When i queried v$session , the result is like this.

SVRMGR> select sid,username,serial# ,status,logon_time from v$session;

SID        USERNAME                       SERIAL#    STATUS   LOGON_TIM 


---------- ------------------------------ ---------- -------- --------- 

         1                                         1            ACTIVE
26-JUL-00 
         2                                         1            ACTIVE
26-JUL-00 
         3                                         1            ACTIVE
26-JUL-00 
         4                                         1            ACTIVE
26-JUL-00 
         5                                         1            ACTIVE
26-JUL-00 
         6                                         1            ACTIVE
26-JUL-00 
         7 OPS$MBANAND1             229                 INACTIVE 27-JUL-00 
         8 SYS                                 355              ACTIVE
27-JUL-00 
         9 OPS$NKP                        142           INACTIVE 27-JUL-00 
        10 OPS$NKP                        158           INACTIVE 27-JUL-00 
        11 OPS$MBANAND1              97                 INACTIVE 27-JUL-00 

11 rows selected.

My question is what the first 6 rows indicate?They have no user name.Is it something to do with date?They are all previous days sessions.can anybody update me on what this output says? Received on Thu Jul 27 2000 - 05:23:26 CDT