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: v$session.program

Re: v$session.program

From: Wolf Grossi <ng-wg_at_magro-soft.com>
Date: Tue, 03 May 2005 09:04:16 +0200
Message-ID: <42772272$1@e-post.inode.at>


yong321_at_yahoo.com wrote:
> I would be interested to know whether anything other than JDBC thin
> driver, such as OCI, can change the program column value in v$session.
> Note:147413.1 has code that uses JDBC thin driver to achieve this, by
> setting a property "v$session.program".
Yes, I've read this. And if it's possible to do it with JDBC it should also be possible with C/OCI.

> I'm not sure why the program name part changes to "?", as if the server
> process has intentionally modified its own argv[0]. If you write your
> own program, I believe you can do it (by setting the second argument of
> exec() to "?"). But I don't know if Oracle OCI can do that to Oracle.
I do not understand what you mean.
The OCI-programm is startet with
int execlp( const char *file, const char *arg, ...); and no '?' is used as arg.

Wolf Received on Tue May 03 2005 - 02:04:16 CDT

Original text of this message

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