Re: Blank lines in v$session for username and program

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Fri, 29 Mar 2002 10:36:38 +0500
Message-ID: <a80uhc$osanj$1@ID-127142.news.dfncis.de>

Hi,

it's not oracle processes, because type is USER. It may relate to job activity. Check for cursors which belong to these session to discover what's going on.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

"Mark & Kristi Wagoner" <mwagoner_at_iac.net> wrote in message
news:a804ge$20jl$1_at_genma.iac.net...


> I believe these are the Oracle processes (pmon, etc).

>

> "Kirk Hill" <khill_at_scic.com> wrote in message

> news:3d440d91.0203280843.686d74c3_at_posting.google.com...

> > I run the following query and get blank lines for user name and

> > program name and would like to know what they are.  Does anybody have

> > a clue?

> >

> > select username,status,type,program from v$session

> >

> > Here is a part of the result

> >

> > username status type program

> > ACTIVE USER

> >          ACTIVE USER

> >

> > Does anyone have any ideas?

>

>

Received on Thu Mar 28 2002 - 23:36:38 CST