They're awesome... Try set timing on begin for i in 1 .. 1000000 loop dbms_application_info.set_client_info('x'); end loop; end; You'll get a very impressive rate hth connor --- David Kurtz <info@xxxxxxxxxxxxxxx> wrote: > Hello > > Can anyone tell me how and when Oracle Apps or the Oracle Development tools > use the DBMS_APPLICATION_INFO package. > > There are four producedures in this package > SET_CLIENT_INFO > SET_MODULE > SET_ACTION > SET_SESSION_LONGOPS > ===== Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald@xxxxxxxxx Coming Soon! "Oracle Insight - Tales of the OakTable" "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ------------------------------------------------------------ ____________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------