In that case you can use dbms_session.set_identifier to set client_id and
use with DBMS_MONITOR.CLIENT_ID_STAT_ENABLE.
On Wed, Mar 9, 2016 at 3:07 PM, De DBA <dedba@xxxxxxxxxx> wrote:
Yes, business unit, department, cost centre.. The problem is of course
that the users log on via middleware. It is a proxy logon to the database,
so that we can identify the users, but the middleware can't (won't) connect
to different services... that would be too easy ;-)
Cheers,
Tony