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

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange rows resturned from v$session

Re: Strange rows resturned from v$session

From: Tapan Trivedi <tapan.trivedi_at_abbnm.com>
Date: Tue, 27 Jul 1999 15:11:28 -0500
Message-ID: <379E1270.1B7AC711@abbnm.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?
>
> 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

Original text of this message

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