Program field in v$session

This column is 64 characters in length - if for example the shortcut to a program is longer than this, it can't all be stored, so is there any way of getting this info? Thanks, Steven H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL

RE: Program field in v$session

DBMS_APPLICATION_INFO Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford