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 New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
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!

Oracle Fusion Data Intelligence Idea Lab

Ability to generate Explain Plan for queries using out of the box FAW or data augmentation tables

Needs Votes

Views

Comments

Celine Paul Rank 2 - Community Beginner

Feb 15, 2024 8:36AM edited Mar 12, 2025 4:55PM in Oracle Fusion Data Intelligence Idea Lab

We are not able to generate Explain Plan for queries using out of the box FAW or data augmentation tables, it says insufficient privileges. This makes it difficult to troubleshoot performance issues of SQLs using these tables. There are no issues in generating explain plan if query uses only custom tables.

Tagged:

setup/administration

2 votes

MFA for Oracle Community

Oracle Fusion Data Intelligence Idea Lab

Categories

Ability to generate Explain Plan for queries using out of the box FAW or data augmentation tables

Needs Votes · Last Updated Mar 12, 2025 4:55PM