Don't know of any tool that will put all the instrumentation in for you, but you might want to consider using ILO instead of using DBMS_APPLICATION_INFO directly. http://sourceforge.net/projects/ilo/ It's from those nice people at Method-R. :) Cheers Tim... -- //www.freelists.org/webpage/oracle-l