Thanks to Niall Litchfield on the Oracle-L listserver, I’ve just been reading a paper (in pdf form) on the package dbms_application_info presented at the UKOUG annual conference 2005 by Gerry Miller of Miller and Bowman.
In case you’re not familiar with it, the basic package allows you to update and read some of the columns in the dynamic view v$session.
This paper is worth reading to show you how to progress from that starting point to a useful level of monitoring, debugging and control mechanisms.
