Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Yes Asim, We have done that as well, we have ran the report & immediately went to manage sessions. the entire time is being spent on the Database. the query keeps running on database, this we have checked at the database sessions as well through DBA's. Thanks, Sunil

in OBIEE - Report Performance Issue Comment by 3318159 Nov 30, 2016 4:58AM
Hello, below are the points you have asked for. Number of rows returned - 19 to 25 rows is this running the same exact physical SQL? - Yes Against the same database? From the OBIEE server? - Yes Row count from the Dimensions & facts involved are as below - D1-1819, D2 - 286, D3 - 127636, D4 - 2256479, F1 - 17178977 Thanks,…

in OBIEE - Report Performance Issue Comment by 3318159 Nov 30, 2016 4:56AM