Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange rows resturned from v$session
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
The blank lines correspond to the oracle background processes like dbwriter, log writer, smon ,pmon etc. Query v$bgprocess. If you are on UNIX then do a ps -G dba (where dba is the dba group) if the number of processes equals the number of blank lines then you are ok. Received on Tue Jul 27 1999 - 15:11:28 CDT