Re: V$session doubt

From: Jack van Zanen <nlzanen1_at_ey.nl>
Date: Thu, 27 Jul 2000 12:45:30 +0100
Message-Id: <10571.113102@fatcity.com>

HI

These are your ORACLE Background processes (LGWR, DBWR,CKPT, etc etc..)=

jack

Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>@fatcity.com on 07/27/2000 09:48:59 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: V$session doubt

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

SVRMGR> select sid,username,serial# ,status,logon_time=A0 from v$sessio= n;
SID=A0=A0=A0=A0=A0=A0=A0 USERNAME=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0 SERIAL#=A0=A0=A0 STATUS=A0=A0 LOGON_TIM

---------- ------------------------------ ---------- -------- ---------=



=A0=A0=A0=A0=A0=A0=A0=A0 1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 1 =A0=A0 =A0=A0=A0=A0=A0=A0=A0 ACTIVE
26-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 2=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 1 =A0=A0 =A0=A0=A0=A0=A0=A0=A0 ACTIVE
26-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 3=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 1 =A0=A0 =A0=A0=A0=A0=A0=A0=A0 ACTIVE
26-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 4=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 1 =A0=A0 =A0=A0=A0=A0=A0=A0=A0 ACTIVE
26-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 5=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 1 =A0=A0 =A0=A0=A0=A0=A0=A0=A0 ACTIVE
26-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 6=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 1 =A0=A0 =A0=A0=A0=A0=A0=A0=A0 ACTIVE
26-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 7 OPS$MBANAND1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 229 =A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0 INACTIVE 27-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 8 SYS=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 355 =A0=A0=A0=A0=
 =A0=A0=A0=A0=A0=A0=A0 ACTIVE
27-JUL-00
=A0=A0=A0=A0=A0=A0=A0=A0 9 OPS$NKP=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 142 =A0 =A0=A0=A0=A0=A0=A0=A0 INACTIVE 2=
7-JUL-00
=A0=A0=A0=A0=A0=A0=A0 10 OPS$NKP=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 158 =A0 =A0=A0=A0=A0=A0=A0=A0 INACTIVE 2=
7-JUL-00
=A0=A0=A0=A0=A0=A0=A0 11 OPS$MBANAND1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 97 =A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0=A0=A0 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 anybo= dy update
me on what this output says?

Thanks
Uma

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd v= oor
de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreid= ing
en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging va= n de
inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The information contained in this communication is confidential and may=  be
legally privileged. It is intended solely for the use of the individual=  or
entity to whom it is addressed and others authorised to receive it. If = you
are not the intended recipient you are hereby notified that any disclos= ure,
copying, distribution or taking any action in reliance on the contents=  of
this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of th= e
information contained in this communication nor for any delay in its receipt.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
Received on Thu Jul 27 2000 - 06:45:30 CDT