Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OTBI Top 50 poor performing Reports — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Top 50 poor performing Reports

Question
17
Views
0
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!