Follow Us on Twitter

Monitoring Business Objects end user activity using Oracle Enterprise Manager

by Maarten van Luijtelaar on February 25, 2013 · 1 comment

Recently, one of our clients upgraded their Business Objects environment to version 4. Reports are run on datamarts in the datawarehouse, but there are also older reports running directly on operational databases. These are subject to move to the dedicate datawarehouse environment eventually. From an instrumentation perspective, we couldn’t see what was going on exactly using the Oracle Enterprise Manager during the day. Especially, the question of which end user was doing what and how many resources a particular report in total would consume in the database was a real pain. Also an insight on if, and how much a particular report was used would be valuable information. The only thing we could see is the name of the originating BO machine, and the executable firing off the BI queries (WireportServer.exe)

So we tried to find a way to expose the current Business Objects universe, report- and end user name in the Oracle Database’s session information and came up with this solution:

Be sure the user you connect through has execute rights on DBMS_SESSION.
In your Business Objects Universe Designer goto:
and add the following to the ConnectInit parameter:


ConnectInit Screenshot

Above will set the client identifier, client info, module and action in the session info, ready for us to do some aggegration upon in Enterprise Manager:

As you can see in the above screenshot, you can view the actions (report names) per module(BO universe) and enable aggegration. This wil save statistics on a particular module/action to be viewed in detail:


If you need to find out what a specific user is executing, simply view the session information filtering on client identifier:


I hope this helps in providing more insight in database activity.
In fact, this approach can of course be used for any PL/SQL program or third party tooling which has the possiblity to execute some code when the connection to the database is set up.

Monitoring Business Objects end user activity using Oracle Enterprise Manager, 3.0 out of 5 based on 2 ratings
VN:D [1.9.22_1171]
Rating: 3.0/5 (2 votes cast)

{ 1 comment… read it below or add one }

Vigneshwaran October 6, 2016 at 6:27 pm


We have implemented this in our BI 4.1 Universe. It works fine when we ran the report without special character ‘&’ .. but it throws error for ‘&’ named reports.

Can you please tell me to solution.


Leave a Comment


Previous post:

Next post:

About Whitehorses
Company profile

Whitehorses website

Home page

Follow us
Blog post RSS
Comment RSS