I like this idea about wrapping dbms_application_info and do the captures whenever set_module is called.
Mladen, looks like you found the easiest solution ... oh yeah and don't forget to give your duhvelopers a cookie for using dbms_application_info.
Raj
And actually, as your application happily uses dbms_application_info - why not create your own wrapper around it that the app can call, that turns sql trace on and off for the modules you're interested in ?
-- //www.freelists.org/webpage/oracle-l