DBMS_APPLICATION_INFO

"If developers used the DBMS_APPLICATION_INFO package to instrument their code it would make mine that their life much easy. The package allows you to specify a Module and Action for the current position in the code. This can be monitored externally using V$SESSION and also appears in V$SQLAREA to allow you to match SQL to a module.You can also use the package to put your own progress information in V$SESSION_LONGOPS."