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: Blank lines in v$session for username and program

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

From: fran keenan <fran.keenan_at_yac.com>
Date: 28 Mar 2002 13:59:55 -0800
Message-ID: <8b7972b3.0203281359.4d3028bb@posting.google.com>


khill_at_scic.com (Kirk Hill) 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?

It would be due to something like db server being 8.1.7 and client you are using is 8.1.6 ?? I've seen similar and put it down to this. Received on Thu Mar 28 2002 - 15:59:55 CST

Original text of this message

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