OTBI Top 50 poor performing Reports
SummaryOTBI Top 50 poor performing Reports
I am trying to find out reports that are performing poorly in our environment. I am running analytics and reports in oracle fusion cloud (OTBI/BIP) R13.
I am looking for list of :
- Report name with path
- Execution time and date
For the past two months for example. The session manager cursor cache provides such information but it is retained for just about an hour depending on the number of ongoing transactions. Oracle support suggested I build a BIP report from the FUSION_ORA_ESS.REQUEST_HISTORY table but this does not provide much information. Can anyone help with some ideas?