I think the information you want is normally found in v$session. You
can use the sys.dbms_application_info package to set module columns and
client_info columns in v$session.

Look up:
sys.dbms_application_info.set_module
sys.dbms_application_info.set_client_info

Steve
-----Original Message-----
From: SWISHEB1
[mailto:oracledba-ezmlmshield-x52840590.[Email address protected]
Sent: Tuesday, August 01, 2006 7:46 AM
To: LazyDBA Discussion
Subject: v$process.program column

Does anyone know a way to influence what appears in the program column
in
the v$process view? For example, you have two sqlplus clients connected

to the same instance and you wanted "SP1" to show up in the
v$process.program column for the first one and "SP2" for the second one,

so that you could tell which on is which.

Thanks -- Brian


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page