Look at ora_module_name. ----------------- Ron Reidy Senior DBA Array BioPharma, Inc. 303.386.1480
-----Original Message----- From: Jim Spath [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: Defining V$SESSION.PROGRAM I was wondering if it is possible to define the program attribute of an Oracle session via DBI or DBD::Oracle (V$SESSION.PROGRAM). SQLPlus will definte the program attribute as: [EMAIL PROTECTED] (TNS V1-V3) But my perl processes always end up with a program attribute of: ? @[HOSTNAME].[DOMAIN].com (TNS V1-V3) I know for a fact that it is possible to set this attribute, as we run some third-party software which identifies itself properly to Oracle. I was hoping Perl would allow me to do the same, so that I could better monitor database activity. Thanks in advance for the help! - Jim PS - I did find this link via Google: http://www.dbforums.com/showpost.php?p=2385561&postcount=2 But it only talks about how to set the properties via the JDBC Thin driver. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
