Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: V$session doubt

AW: V$session doubt

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Thu, 27 Jul 2000 12:29:42 +0200
Message-Id: <10571.113100@fatcity.com>


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
> 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?
Received on Thu Jul 27 2000 - 05:29:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US