Re: Strange rows returned from v$session

From: Kevin Fries <kelfink_at_ecst.csuchico.edu>
Date: 27 Jul 1999 19:51:57 GMT
Message-ID: <7nl2kt$s4o$1@hubble.csuchico.edu>

In article <379dfd5f.801632055_at_client.sw.news.psi.net>, Chuck <rhugfga_at_home.com> 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
>

Sure, Chuck,

Try changing your query to:

select type, process, program from v$session;

You'll see what's going on...

TYPE PROCESS PROGRAM

---------- --------- ------------------------------------------------
BACKGROUND 28281     oracle_at_ca (PMON)
BACKGROUND 28283     oracle_at_ca (DBWR)
BACKGROUND 28284     oracle_at_ca (LGWR)
BACKGROUND 28285     oracle_at_ca (CKPT)
BACKGROUND 28286     oracle_at_ca (SMON)
BACKGROUND 28288     oracle_at_ca (RECO)
USER       18876     sqlplus_at_ca (TNS interface)

Background processes you probably don't want to look at, for the most part. You probably know about the Process monitor, database writer, log writer, checkpoint process, system monitor, and recovery process. You might have others on your system.

The "PROCESS" column actually shows (on UNIX systems) the UNIX pid for the process, so you can verify this with "ps" .

HTH
Kevin Fries

--

---

Kevin Fries                         kelfink_at_ecst.csuchico.edu

CPD/PB, C Developer/DBA http://www.ecst.csuchico.edu/~kelfink Received on Tue Jul 27 1999 - 14:51:57 CDT