Re: Strange rows resturned from v$session

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 27 Jul 1999 15:23:02 -0400
Message-ID: <379E0716.D5C5CA82@Unforgettable.com>

Chuck wrote:

> I am using Oracle 805 as a backend to a Lawson ERP Package.
>
> When I do the following query on V$SESSION, this is what I get:
>
> select username from V$SESSION;
>
> This is what I get back from Oracle:
>
> USERNAME
> ------------------------------------------------------
> <blank line>
> <blank line>
> <blank line>
> <blank line>
> <blank line>
> <blank line>
> SOME_USER
> SOME_USER
> SOME_USER
> SOME_USER
> SOME_USER
> SOME_USER
> SOME_USER
> SOME_USER
> SOME_USER
> SYS
> 16 rows selected.
>
> ANy idea what the blank entries are?

If you had looked at other columns in that view you would have seen what they are. They are your PMON, DBWR, LGWR, SMON and ARCH processes. Received on Tue Jul 27 1999 - 14:23:02 CDT