Re: dbms_application_info
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 20 Sep 2001 22:46:13 +0100
Message-ID: <3BAA63A5.1BF_at_yahoo.com>
Date: Thu, 20 Sep 2001 22:46:13 +0100
Message-ID: <3BAA63A5.1BF_at_yahoo.com>
sweidanz_at_yahoo.com wrote:
>
> Hi folks,
> Has anyone had any overhead impact on the system when using
> dbms_application_info to record names of executing modules and actions?
>
> Thanks,
> ZS
Try this
for i in 1 .. 100000 loop
dbms_application_info.set_module('xxx');
end loop;
I got 200,000 per sec out of a server here - its has "0" overhead
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Thu Sep 20 2001 - 23:46:13 CEST