Pretty fast - 6.66 microseconds per call. Linux 7.2, Oracle 8.1.7, Dell 2450 2x P4 CPU begin for i in 1 .. 1000000 loop dbms_application_info.set_client_info('x'); end loop; end;12:04:45 rsysdevdb.radisys.com - jkstill@dv01 SQL> 12:04:45 2 12:04:45 3 12:04:45 4 12:04:45 5 12:04:46 6 / PL/SQL procedure successfully completed. Elapsed: 00:00:06.66 12:04:50 rsysdevdb.radisys.com - jkstill@dv01 SQL> Connor McDonald <hamcdc@xxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 05/10/2004 07:48 AM Please respond to oracle-l To: oracle-l@xxxxxxxxxxxxx cc: Subject: Re: How does Oracle Apps/Dev Tools use DBMS_APPLICATION_INFO? 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------