RE: V$session doubt

From: Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>
Date: Thu, 27 Jul 2000 17:37:02 +0530
Message-Id: <10571.113108@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_01BFF7C3.2A9CC000
Content-Type: text/plain;

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

Thanks a lot to all for the help.

> ----------
> From: Libal, Ivo[SMTP:ivo.libal_at_knapp-systems.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, July 27, 2000 5:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: AW: V$session doubt

>=20

> these are server background processes
> Ivo Libal

>=20


> > -----Urspr=FCngliche Nachricht-----

> > Von:	Uma Sankara_Sivadanam [SMTP:UmaSankara_Sivadanam_at_satyam.com]

> > Gesendet am:	Donnerstag, 27. Juli 2000 10:49

> > An:	Multiple recipients of list ORACLE-L

> > Betreff:	V$session doubt

> >=20

> > Hi,=20

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

> >=20

> >=20
> > SVRMGR> select sid,username,serial# ,status,logon_time from =
v$session;=20
> > SID USERNAME SERIAL# STATUS =
LOGON_TIM=20
> > ---------- ------------------------------ ---------- -------- =
---------=20
> > 1 1 =
ACTIVE
> > 26-JUL-00=20
> > 2 1 =
ACTIVE
> > 26-JUL-00=20
> > 3 1 =
ACTIVE
> > 26-JUL-00=20
> > 4 1 =
ACTIVE
> > 26-JUL-00=20
> > 5 1 =
ACTIVE
> > 26-JUL-00=20
> > 6 1 =
ACTIVE
> > 26-JUL-00=20
> > 7 OPS$MBANAND1 229 INACTIVE
> 27-JUL-00
> >=20
> > 8 SYS 355 =
ACTIVE
> > 27-JUL-00=20
> > 9 OPS$NKP 142 INACTIVE
> 27-JUL-00
> >=20
> > 10 OPS$NKP 158 INACTIVE
> 27-JUL-00
> >=20
> > 11 OPS$MBANAND1 97 INACTIVE
> 27-JUL-00
> >=20
> > 11 rows selected.=20
> >=20
> > 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?
> >=20
> > Thanks=20
> > Uma=20
> >=20
> --=20
> Author: Libal, Ivo
> INET: ivo.libal_at_knapp-systems.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>=20

------_=_NextPart_001_01BFF7C3.2A9CC000
Content-Type: text/html;

charset="iso-8859-1"
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=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: V$session doubt</TITLE>
</HEAD>
<BODY>

Thanks a lot to all = for the help.

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Libal, =

Ivo[SMTP:ivo.libal_at_knapp-systems.com] Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Thursday, July 27, 2000 5:35 = AM
 To: =     Multiple = recipients of list ORACLE-L
 Subject: =        AW: V$session doubt

these are server background = processes
 Ivo Libal

> -----Urspr=FCngliche = Nachricht-----
 > Von:  Uma Sankara_Sivadanam = [SMTP:UmaSankara_Sivadanam_at_satyam.com] > Gesendet am:  Donnerstag, = 27. Juli 2000 10:49

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; An:&nbsp;&nbsp; Multiple =
recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; =
Betreff:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; V$session doubt</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; SVRMGR&gt; 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>

>        &nbsp= ; =

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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =