RE: Session info

Maybe it has something to do with the client. I just did the same (ora81634 on NT) and the program contain only the program name,
not the whole path.
Our clients are sqlnet that came with 734 or 816.

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Aldi Barco [SMTP:ipal_at_hotmail.com]
> Sent: Thu, January 17, 2002 6:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Session info
>
> I did that from sqlplus.
> In 816 Linux that is varchar2(48).
> The output is truncated so I don't know the name of the application from
> the
> client (it just showing
> C:\WINNT\Profiles\AldiTest\NewApplication\Sales\D).
>
> Aldi
>
> -----Original Message-----
> Sent: Thursday, January 17, 2002 10:07 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I just did describe v$session and the program field is 64 bytes long.
> Maybe you are using a tool that limits the value to 48 bytes.
> Oracle 8.1.6 on NT.
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> >-----Original Message-----
> >From: Aldi Barco [SMTP:ipal_at_hotmail.com]
> >Sent: Thu, January 17, 2002 5:12 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: Session info
> >
> >Hi Listers,
> >We can find the program executed from Client in 'program' field in
> >v$session. But the problem is the field length just 48 character. Is
> there
> >
> >any other dictionary (v$ or x$ ?) to find 'the client program' completely
>
> >(more than 48 character) ?
> >Thanks.
> >
> >Aldi
> >
> >_________________________________________________________________
> >Join the world's largest e-mail service with MSN Hotmail.
> >http://www.hotmail.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Aldi Barco
> > INET: ipal_at_hotmail.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > This e-mail was scanned by the eSafe Mail Gateway
> >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> INET: adary_at_mehish.co.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Aldi Barco
> INET: ipal_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).