RE: V$session doubt

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Thu, 27 Jul 2000 16:12:11 +0530
Message-Id: <10571.113103@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_01BFF7B7.0C06A0A0
Content-Type: text/plain;

charset="iso-8859-1"

they are the sessions for oracle processes like pmon, smon, etc

-----Original Message-----
From: Uma Sankara_Sivadanam [mailto:UmaSankara_Sivadanam_at_satyam.com] Sent: Thursday, July 27, 2000 2:19 PM
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?

Thanks
Uma

------_=_NextPart_001_01BFF7B7.0C06A0A0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>V$session doubt</TITLE>

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV>they=20
are the sessions for oracle processes like pmon, smon, = etc</DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: Uma = Sankara_Sivadanam=20
 [mailto:UmaSankara_Sivadanam_at_satyam.com] Sent: Thursday, = July 27,=20
 2000 2:19 PM To: Multiple recipients of list=20 ORACLE-L Subject: V$session doubt </DIV> Hi, When i=20
 queried v$session , the result is like this. SVRMGR> select=20 sid,username,serial# ,status,logon_time  from v$session; =
 <FONT=20

 color=3D#0000ff face=3DArial =
size=3D2>SID       =20 =
USERNAME          &nbs= p;           =20 SERIAL#    STATUS   LOGON_TIM =
 <FONT=20

 color=3D#0000ff face=3DArial size=3D2>---------- =

------------------------------=20

-------- ---------         =20 = 1           &nbsp= ;           &nbsp= ;           &nbsp= ;    =20 1            = ACTIVE  =20 26-JUL-00         =20 = 2           &nbsp= ;           &nbsp= ;           &nbsp= ;    =20 1            = ACTIVE  =20 26-JUL-00         =20 = 3           &nbsp= ;           &nbsp= ;           &nbsp= ;    =20 1            = ACTIVE  =20 26-JUL-00         =20 = 4           &nbsp= ;           &nbsp= ;           &nbsp= ;    =20 1            = ACTIVE  =20 26-JUL-00         =20 = 5           &nbsp= ;           &nbsp= ;           &nbsp= ;    =20 1            = ACTIVE  =20 26-JUL-00         =20 6           &nb= sp;           &nb= sp;           &nb= sp;    =20 1            = ACTIVE  =20 26-JUL-00          7=20 = OPS$MBANAND1          =   =20 229        =20         INACTIVE 27-JUL-00 =
 <FONT=20
color=3D#0000ff face=3DArial=20 size=3D2>         8=20 = SYS           &nb= sp;           &nb= sp;        =20 355      =        =20 ACTIVE   27-JUL-00          9=20 = OPS$NKP          &nbsp= ;           &nbsp= ;=20 142           INACTIVE=20 27-JUL-00         10=20 = OPS$NKP          &nbsp= ;           &nbsp= ;=20 158           INACTIVE=20 27-JUL-00         11=20 = OPS$MBANAND1          =    =20 97        =20         INACTIVE 27-JUL-00 =
 <FONT=20
color=3D#0000ff face=3DArial size=3D2>11 rows selected. My question is what the first 6 rows = indicate?They=20 have no user name.Is it something to do with date?They are all = previous days=20 sessions.can anybody update me on what this output says?

Received on Thu Jul 27 2000 - 05:42:11 CDT