Re: Strange rows resturned from v$session

The blank Lines Correspond to Oracle Background Processes..

Try
Select username,program,machine from v$session;

-Thiru

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?
>
> THanks a bnuch,
> Chuck
Received on Tue Jul 27 1999 - 14:19:52 CDT