V$session doubt

From: Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>
Date: Thu, 27 Jul 2000 13:07:38 +0530
Message-Id: <10571.113091@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF79D.885F61D0
Content-Type: text/plain

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?

Thanks
Uma

------_=_NextPart_001_01BFF79D.885F61D0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>V$session doubt</TITLE>
</HEAD>
<BODY>

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

 

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

USERNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
SERIAL#&nbsp;&nbsp;&nbsp; STATUS&nbsp;&nbsp; LOGON_TIM</FONT>

 ---------- =

------------------------------ ---------- -------- ---------</FONT>

          =

1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;&nbsp; =