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.