RE: V$session doubt

Hi,

Aren't these Background-processes like LGWR etc ... ?

Greets,

Kirsten

> -----Original Message-----
> From: Uma Sankara_Sivadanam [SMTP:UmaSankara_Sivadanam_at_satyam.com]
> Sent: Thursday, July 27, 2000 9:49 AM
> 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?
Received on Thu Jul 27 2000 - 06:05:21 CDT