OTBI Top 50 poor performing Reports

Fongang

Summary

OTBI Top 50 poor performing Reports

Content

Hi All,

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

- Runtime

- 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?

 

Thanks

 

Kingsley F.

Version

R13