NHibernate, Oracle and sql instrumentation

Hopefully I can express this in a coherent and meaningful way:

Two of our DBA's came up to me today after an email I sent explaining why we were using NHibernate and the benefits of an ORM framework. They have been pushing hard for refactoring our stored procs to include instrumentation like this:

BEGIN DBMS_APPLICATION_INFO.set_module(module_name => 'Human Resources' ,action_name => 'Get Employees');

{sql here}

DBMS_APPLICATION_INFO.set_module(NULL, NULL);

My questions really stem around how could we accomplish this, are there any huge caveats t开发者_StackOverflow中文版hat would recommend against finding an implementation for this, if this is too painful, are there alternatives.

Thank you in advance, -sean

Seems like what you need is auditing? Maybe Data Auditing in NHibernate and SqlServer and http://www.shawnduggan.com/?p=89 can help you out