OBIEE Purpose of Usage Tracking Ability

Question

my requirement is, when a business use runs a query,

As admin, I would like to know the query being run by business. I would like not to see the session log from 'Manage Sessions'.

What we noticed, there is a huge time log for the query to appear in usage tracking. is this expected? How can we make it work in quick realtime to appear in usage trackng?

Thanks,

Gianni Ceresa · Answer

Look into the official documentation of the product. All that is covered in detail, including the parameter that manage that part.

By default Usage Tracking is asynchronous, with a buffer on the BI Server. There are various parameters defining how often UT is inserted into the table, in between these INSERT statements the logs are kept in the buffer.

[Deleted User] · Answer

You're not providing any key information required to precisely answer your question like the exact version you're using:

And exact version means "12.2.1.4.200716" and not "12.2.1.1" or "12c".

Did you correctly set up Usage Tracking already?

https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-BDEB11A5-00F5-47E4-8904-C74F654546F3.htm#BEGIN