Re: V$session doubt

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Thu, 27 Jul 2000 11:36:55 +0200
Message-Id: <10571.113098@fatcity.com>

Hi

They are your oracle background processes. pmon,smon,dbwr,lgwr,arch,snp

Regards
$uhen

>>> UmaSankara_Sivadanam_at_satyam.com 07/27/00 10:48AM >>>
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 - 04:36:55 CDT