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: User program name without V$SESSION

Re: User program name without V$SESSION

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Mar 2006 07:10:38 -0800
Message-ID: <1141657838.759985.129320@i39g2000cwa.googlegroups.com> 





Warning, the program column of v$session is often not populated
depending on the version of the Oracle client in use.



ddc1 > select count(*) from v$session


  2  where username is not null and program is null
  3  /



  COUNT(*)





       159



So depending on what this is desired for, what kind of clients are in
use, and the database and client versions the target data may not be
available to begin with.



HTH -- Mark D Powell --
Received on Mon Mar 06 2006 - 09:10:38 CST












Original text of this message













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