Oracle AI and Analytics

Venkata Rachuri

Hi Experts,

My scenario : We have a report that is taking 1m and 24 seconds in  OBIEE. I took the query and ran it on database ( exadata) , it took 45 seconds in database. How to determine what  is taking the BI sever the extra time. This report is just a simple table view . Any suggestion please ? I want to bring the report time to less than 1 minute.

Thanks

Venkat

[Deleted User]

RCA - Root Cause Analysis:

https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world